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

    ORA-04098: trigger 'xxxxx_TRIGGER' is invalid and failed re-validation

    • Article Type: General
    • Product: Aleph
    • Product Version: 17.01

    After enabling triggers, we find that neither the source record of the trigger nor the target record is created/updated.

    The following message appears in the pc_server log and the Oracle alert log:

    ORA-04098: trigger 'xxxxx_TRIGGER' is invalid and failed re-validation

    (The triggers for which this might occur are the z07h_trigger and the z1000_trigger, z1000_trigger_1, z1000_trigger_2
    z1001_trigger z1002_trigger, z1002_trigger_1, z1002_trigger_2 z1003_trigger)

    This message occurs when the trigger references columns which don't exist in the source record or when the columns in the trigger itself (defined in the ./alephm/sql_tab) do not match the columns in the target record.

    In the case of the z07h, there are some z07h_trigger definitions which include a "date" column when the z07h target lacks it -- or vice versa.

    In the case of the z100n tables.... as described in KB# 5274, the z1000, z1001, and z1002 tables are obsolete in version 16-up. So these TRI lines in your file_list should be commented out or deleted. [Note: As described in KB# 5274, the z1002 has been resurrected in v18. See KB 5274.]

    Additional Information

    trigger, oracle log, z07h, z1000

    • Article last edited: 10/8/2013