Links from Course Reserve library to ADM library not working

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

Description:
Circ staff cannot search or browse the course reading database, UCD30, with the CIRC2 client. Furthermore, items that should link to the UCD30 bibs do not display in the web services course list.

Here are examples of the outstanding problems: In CR web services, Course POL121 has 12 titles listed. Since rerunning p_manage_12, we can see the items associated with the UCD01 titles, but not those that are in UCD30.

Searching/scanning in the CIRC client gets errors, even though the items are in UCD50 and can be circulated.

It seems as if the z103 records are not correct.

Resolution:
We found that there were 929 UCD50 ADM Z103 links to UCD30 records which were in the UCD50 library but not in the UCD30.

I did a p_file_03 backup of the ucd30 z103 and this SQL which corrected the problem:

s+ ucd30
SQL-UCD30> insert into z103 select * from UCD50.Z103 where Z103_REC_KEY_1 like 'UCD30%' minus select * from z103;
(Do not perform this without consulting Ex Libris Support.).

Since you saw the extra Z103 type "ADM"s for ucd30 in the ucd50 library, I assume that the run of p_manage_12 for ucd50 put them in the ucd30 library also, but they were removed by the run of p_manage_12 for ucd30. Since you, correctly, ran p_manage_12 for ucd30 with "N,Y", this should not of happened.

You ran them in the order xxx01, xxx60, xxx50, xxx30 (with "N,Y"). See our revised suggestion for the order/parameters in KB 8192-3511.