Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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