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

    Faulty links on a single record

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

    Description:
    Bib record number 401718 is displaying items which are actually connected to 394067 and 401847 (in addition to displaying its own correct items) in the Web OPAC..... 390467 and 401847 are displaying fine.

    UTIL-F-3-12 produces this:
    ENTER HOME LIBRARY : ABC01
    ENTER DOC-NUMBER : 401718
    ABC01 000000000 PAR
    ABC60 000403909 HOL
    ABC50 000394076 ITM
    ABC50 000401718 ADM
    ABC50 000401847 ITM
    ABC60 000390569 HOL
    END

    So, I see that a PAR LKR has been created for 401718 and there are the suspect ITM fields which are dragging in the wrong Items. BUT when I query 401718 via UTIL-F-4 (below), I do NOT see an LKR field; nor do I see it in the cataloging module. So, I can't delete a field which isn't actually there (right?)

    I tried saving the record to the server both through cataloging and through the util, but that didn't correct the problem.

    Resolution:
    The 000394076 and 000401847 items have z30_order_number's linking them to 000401718. (See SQL below.)

    And the abc50 tab_z103 has this line:
    update_z103_order_itm

    This causes the links to be created which are displayed in OPAC.

    As described in KB 4085, we suggest that you *not* have this line in the ADM tab_z103. Eliminating it will prevent such links from being created in in the future.

    To handle the existing cases, you will need to run the following SQL:

    SQL> delete from z103 where Z103_REC_KEY_1 like 'ABC01000401718%' and Z103_LKR_TYPE = 'ITM';
    SQL> commit;

    Note: The preceding SQL needs to be run in both the ADM library *and* the BIB library.

    The following is the SQL Select showing the linked item records:
    SQL> select z30_rec_key from z30 where z30_order_number = '401718-1';

    Z30_REC_KEY
    ---------------
    000401718000100
    000401718000050
    000401718000060
    000401718000110
    000401718000120
    000401718000180
    000401718000190
    000401718000200
    000401718000010
    000401718000020
    000401718000030
    000401847000020
    000401847000040
    000394076000020
    000394076000030
    000401718000070
    000401718000080
    000401718000040
    000401847000050
    000394076000060
    000401718000150
    000401718000160
    000401718000170
    000401718000140
    000401847000010
    000401847000030


    • Article last edited: 10/8/2013