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

    Items display for wrong bib record

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

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

    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