Oracle error: io_z30_update ORA-04098: trigger 'DAH50.Z1000_TRIGGE
- Article Type: General
- Product: Aleph
- Product Version: 16.02
Description:
We installed Service Pack: 1296 on our test server and are unable to update item records.
The error in the pc log file is
Oracle error: io_z30_update
ORA-04098: trigger 'DAH50.Z1000_TRIGGER' is invalid and failed re-vali
The error in the GUI is remote service is:
error (c0138 replace 30) Failed to modify item
The problem does not occur in usm, only in dah.
What have we done wrong?
Resolution:
You don't want these Z1000 triggers.
You can see them by doing "dlib xxx50" and then util a/17/6/4. I commented them out in the xxx50/file_list and tried util a/17/6/1 to recreate triggers, but that didn't work.
So I did this SQL to remove them:
SQL> drop trigger Z1000_TRIGGER;
SQL> drop trigger Z1000_TRIGGER_1;
SQL> drop trigger Z1000_TRIGGER_2;
SQL> drop trigger Z1001_TRIGGER;
SQL> drop trigger Z1002_TRIGGER;
SQL> drop trigger Z1002_TRIGGER_1;
SQL> drop trigger Z1002_TRIGGER_2;
SQL> drop trigger Z1003_TRIGGER;
SQL> commit;
Additional Information
service pack, item record, trigger, z100, z1003
- Article last edited: 10/8/2013