Items display for wrong bib record

• 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.