Fast Cataloging generates extraneous HOLding record

Description

In version 23 when an item is created in the Circulation module using the “Catalog Record and Create Item” ("Fast Cataloging") button a holding record appears to be created. The newly created item is not attached to the holding and the holding is not editable – clicking the Edit button gives a Remote Service Error (c0202 11) “Record does not exist”. 

1. We created a new document with the fast cataloging option in Circulation. 
2. The following records were created: BIB - 2994451 and ADM - 2994451 with the correct links (z103) 
3. Another link from the BIB (xxx01) to the HOL library (xxx60) was indeed "created*"* which is wrong of course! 
4. Then we did a check for the next BIB that should be created (2994452). There is no such BIB, of course, BUT there is a link (z103) from this number to an xxx60 document! This means that the next time a document is created there will be already a link to the xxx60 library! 

Analysis

We confirmed via the xxx01 util f/4 that last-doc-number = 2994451. 

And via this SQL: 

SQL> select max (z00_doc_number) from z00; 

MAX(Z00_D 
--------- 
002994451 

that 002994451 is also the highest actual xxx01 z00_doc_number. 

But the following SQLs showed anomalies in the xxx01 *z103*s:

SQL> select max (Z103_REC_KEY_1) from z103 where Z103_REC_KEY_1 like 'XXX01%'; 

MAX(Z103_REC_K 
-------------- 
XXX01W00052415  

and 

SQL> select count(*) from z103 where Z103_REC_KEY_1 > 'XXX01002994451' and Z103_REC_KEY_1 like 'XXX01%' and z103_lkr_type = 'HOL'; 

COUNT(*) 
---------------------------------------- 
14847 

Resolution

We were unable to determine the cause of this situation where the BIB and HOL doc numbers are OK, but the Z103_rec_key's are incorrect.   The normal solution is to run the manage-12 service in all the BIB, ADM, HOL, and Course libraries, as described in the article, manage-12: sequence for BIB, ADM, HOL, and Course libraries *MASTER RECORD* .

In this particular case, since there were 30 ADM libraries and 30 Course libraries, SQL was used instead.  The SQL is in this article's "Internal comment" (visible to only to staff).  Consult with your Ex Libris Support Team in this regard.

• Article last edited: 30-Oct-2018