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

    Missing Z324s; "io_z105 - table doesn't exist in database or tab_io_remote ... "

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

    Why is there no entry for record 030160886 in the Z324?

    As described in KB 8504 (v16 rep_change 703): the creation/update of the Z324 table is done by ue_11. Item changes trigger a creation of Z105 and the Z105 is handled by ue_11 type 8.

    The following SQL shows that there are thousands of unprocessed type 8 z105's in the $z105_library (abc50):

    abc50@ALEPH20> select substr(z105_text,1,5), count(*) from z105 where Z105_TYPE = '8' group by substr(z105_text,1,5);
    **** Hit return to continue ****

    --------------- ----------
    ABC50 20742

    (Note: there are also thousands of unprocessed z105's for z105_type 'e's. See KB 16384-35474.)

    util a/17/14 showed that the z105_id Oracle index was missing for z105 in the $z105_library (abc50):

    Enter Table Name : z105

    Defined in file_list:
    IND z105_id 4M 0K TS2X

    Exist in the Database:

    I did util a/17/2 to generate the z105_id. I have stopped the abc00 ue_11 and did util a/17/2 to create the z105_id Oracle index.

    I restarted ue_11 and, looking at the current run_e_11.22274, find that it is now processing the z105's without error.

    • Article last edited: 10/8/2013
    • Was this article helpful?