Upgrade Express: CREATE Z127_TRIGGER ... failed with ORACLE error 942
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
We are getting the following errors in running the Upgrade Express Install Customer Data step:
start : oracle_imp_aleph_libs_a abc01 abc10 abc50 at 2010-11-15 17:03
...
. importing ABC01's objects into ICA01
IMP-00017: following statement failed with ORACLE error 942:
"CREATE TRIGGER ABC01.Z127_TRIGGER"
" AFTER UPDATE"
" ON ABC01.Z120"
" FOR EACH ROW"
" BEGIN"
" UPDATE ABC01.Z127"
" SET Z127_REC_KEY = :NEW.Z120_REC_KEY,"
" Z127_PREFERRED_DOC_NUMBER= TO_NUMBER(:NEW.Z120_REC_KEY_1)"
" WHERE Z127_REC_KEY = :OLD.Z120_REC_KEY;"
" END;"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
...
<followed by the same for z127_trigger_1 and z127_trigger_2>
Resolution:
It's not clear what is causing this, but, regardless, the best thing is to just ignore it, and after the Upgrade has completed, do the following:
> csh -f create_z127 ABC01 (less than 1 minute)
> util a /17/6/4
If it shows the z127_trigger, z127_trigger_1, and z127_trigger_2, then you're OK. If not, do util a /17/6/1 to create them.
- Article last edited: 10/8/2013