- Article Type: General
- Product: Aleph
- Product Version: 18.01
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
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.
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:
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';
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';
- Article last edited: 10/8/2013