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