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

    trigger 'xxx50.Z105H_TRIGGER' is invalid and failed re-vali

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 19.01

    Description:
    The client hangs while trying to catalogue a new item. Below is the log.
    I will begin my investigations, but thought I would report right away, in case you have a quick fix...

    SERVICE : C0402
    MODULE : Circulation Services
    DESCRIPTION: Catalog a New Item - Minimal
    ACTION : WRITE-CRS
    PROGRAM : pc_cir_c0402

    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu30/tab/tab_tag_text
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu30/tab/tab01.eng

    expand_doc_bib_loc_1_c2 debug mode is off


    expand_doc_sort_loc_a debug mode is off

    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu30/tab/tab00.eng
    Load: /exlibris/aleph/u19_2/alephe/unicode/unicode_to_filing_01
    Load: /exlibris/aleph/u19_2/mgu30/tab/tab11_ind
    Load: /exlibris/aleph/u19_2/mgu30/tab/tab_z103
    Load: /exlibris/aleph/u19_2/mgu30/tab/tab_z105
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu30/tab/tab_publish
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/alephe/tab/union_global_param
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu30/tab/tab_fix
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_tag_text
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_fix
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab01.eng
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_expand
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab00.eng
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_filing
    Load: /exlibris/aleph/u19_2/mgu50/tab/tab11_ind
    Load: /exlibris/aleph/u19_2/mgu50/tab/tab_z103
    Load: /exlibris/aleph/u19_2/mgu50/tab/tab_z105
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_checksum
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_filing_call_no
    Load: /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_z105_z30
    Info: Empty table /exlibris1/utf19/utf_files/exlibris/aleph/u19_2/mgu50/tab/tab_z105_z30

    Oracle error: io_z105_write
    ORA-04098: trigger 'MGU50.Z105H_TRIGGER' is invalid and failed re-vali

    Resolution:
    As can be seen in the mgu50 $data_scratch/file_list, the z105h tab and trigger *are* being included (from the $aleph_root/tab/file_list.z105):

    TAB z105h 100K 0K ts0
    TRI z105h_trigger

    There was a similar existing SI which I have made into a KB record (16384-16193).

    We see that, though the z105h_trigger exists, the z105h table does not. There are two possible solutions:

    1. Do util a/17/1 for the z105h in the $z105_library to define the z105h. Or

    2. Drop the table and trigger:

    SQL> drop table z105h;
    SQL> drop trigger z105h_trigger;

    and add these lines to the $z105_library $data_root/file_list:

    NA z105h
    NA z105h_trigger

    • Article last edited: 10/8/2013