GUI message: "Item, HOL linked to different Bibs"
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
When clicking Refresh on an Item record in the GUI there's a pop-up message that says “Item, HOL linked to different Bibs”. In the item record you can see that there's an HOL link listed, but it doesn't show on the "HOL Links" tab of the Item record.
It seems that this came about because of someone not properly moving Holdings records from one Bib to another.
Resolution
The following SQL looks for cases where the item is linked (via its ADM record) to bib record A, but the item's z30_hol_doc_number_x points to an HOL record which is linked to bib record B.
SQL> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ unique
substr (a.z103_rec_key_1,6,9),
substr (b.z103_rec_key_1,6,9),
substr (z30_rec_key,1,9),
substr (b.z103_rec_key,6,9)
from xxx01.z103 a, xxx01.z103 b, xxx50.z30
where a.z103_lkr_type = 'ADM' and substr (a.z103_rec_key,6,9) = substr (z30_rec_key,1,9)
and b.z103_lkr_type = 'HOL' and substr (b.z103_rec_key,6,9) = Z30_HOL_DOC_NUMBER_X
and substr (a.z103_rec_key_1,6,9) ^= substr (b.z103_rec_key_1,6,9);
--------------------------------------------------------------------------------------------
substr (a.z103_rec_key_1,6,9) is the bib record the item is linked to (via its ADM record)
substr (b.z103_rec_key_1,6,9) is the bib record the HOL is linked to
substr (z30_rec_key,1,9) is the ADM# of the item, and
substr (b.z103_rec_key,6,9) is the HOL record#.
Additional Information
The message "Item, HOL linked to different BIBs" (message# 0223 in ./error_eng/check_z30) is produced by the ./check_record/check_z30 program when it calls check_hol_link, which calls get_adm_bib and finds that
HOL-BIB-DOC-NUMBER NOT = ADM-BIB-DOC-NUMBER
OR HOL-BIB-LIBRARY NOT = ADM-BIB-LIBRARY
The article " SQL to locate items with z30_hol_doc_number which bib record isn't actually linked to " describes a more general case where the z30_hol_doc_number_x points to a deleted or non-existent HOL record.
Case#: 00508735.