Course Catalog New: "Unable to create bib record"
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
When we select a particular course in the GUI Circ List of Courses, select "Course Doc List", click on Catalog New, fill in the bib and item screens, and then click "OK", we get the error message "Unable to create bib record".
Resolution:
The message "Unable to create bib record" is message 0034 in pc_cir_c0402. It is produced when, after writing the record ("update_docx") the program attempts to read the record ("get_buf_docx") and gets a non-zero return code.
Looking in the pc_server log, I see the following message:
Oracle error: io_z00_write
ORA-00001: unique constraint (ABC30.Z00_ID) violated
SQL showed these existing abc30 doc records:
abc30@ALEPH20> select z00_doc_number from z00;
**** Hit return to continue ****
Z00_DOC_N
---------
007339496
007339397
007339595
007339389
000000002
000000004
but abc30 util g/2 showed:
last-doc-number 0
I used the util g/2 update-function to change this to
last-doc-number 5
After doing this, I was able to successfully create an abc30 doc record with the Catalog New button.
- Article last edited: 10/8/2013