Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Items display for wrong bib record

    Items display for wrong bib record

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    We have experienced problems with items erroneously displaying for bib records other than their own.
    Please explain.

    Resolution:
    The items which display for a particular bib can come either from that bib's own items (Z103 type "ADM" link), from items of other bib records (Z103 type "ITM"), or, if the site has "union-view", from an item connected to a non-preferred bib record of the same title. (The latter, of course, is not an error....)

    The most common cause of *erroneous* display is items whose z30_order_number (incorrectly) points to this title, along with the inclusion of an "update_z103_order_itm" line in the ADM tab_z103.

    Two different cases, incorrect order# in subscription record and saved Item Defaults with Order number included.
    In all cases the diagnosis is similar.

    First, you need to do this SQL: SQL-xxx01> select substr (Z103_REC_KEY,1,14) from z103 where Z103_REC_KEY_1 like 'xxx01nnnnnnnnn%' and Z103_LKR_TYPE = 'ITM'; (where xxx01 is the bib library and nnnnnnnnn is the number of the bib record which has this problem).

    You should see a list of lines like this: xxx50-000123456 xxx01-nnnnnnnnn The xxx50 number is an ADM which has an item linked to this bib. You need to check the z30_order_number's of this ADM's item records. If it has just one or two items, then you may use util f/4 to view them. But if it has many, then you can do this SQL:

    select z30_rec_key, z30_order_number from z30 where substr(z30_rec_key,1,9)= 000123456;
    (where "000123456" is an xxx50 record key you got from the previous SQL).

    You are looking for cases like this: 000123456000030 19178-1 (where "19178-1" is an incorrect order number, the order number of the problem bib record's order ).

    Removing the "update_z103_order_itm" line from the ADM tab_z103 will prevent instances of the problem from being generated in the future. In regard to correcting existing situations, see KB 8192-3607.

    Additional Information

    items, display, bibliographic records


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Items cataloged via Fast-Cat at multiple sites generating Holds on single ADM
      • Items do not go In Transit w/ Print Letter function
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved