• 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;