Skip to main content
ExLibris
  • 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

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

    Resolution:
    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 ****

    SUBSTR(Z105_TEX COUNT(*)
    --------------- ----------
    ABC50 20742
    <etc.>

    (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:
    <blank>

    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?