manage-50: Oracle unique constraint errors on xxx60 z00, z13, z103, and z07
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
Oracle unique constraint errors in xxx60 library in running manage-50 ("Create Holdings and Item Records Using Bibliographic Data"):
Oracle error: io_z103_write
ORA-00001: unique constraint (XXX60.Z103_ID) violated
Oracle error: io_z00_write
ORA-00001: unique constraint (XXX60.Z00_ID) violated
Oracle error: io_z13_write
ORA-00001: unique constraint (XXX60.Z13_ID) violated
Oracle error: io_z07_write
ORA-00001: unique constraint (XXX60.Z07_ID) violated
Cause:
A z00 [Doc record] was being created with a blank z00_doc_number. The program then tried to add another record with a blank doc number and got the unique constraint.
The xxx50 util g/2 had a prefix of "B" for last-doc-number:
20. last-doc-number 238710 y S B
Resolution:
Removing the prefix ?B?:
20. last-doc-number 238710 y S
allowed manage-50 to run without error.
Additional Information
The following SQL in xxx60 shows that manage-50 had created one doc record with a blank key:
SQL> select z00_doc_number from z00;
Z00_DOC_N
---------
And a z13 record with a blank key:
SQL> select z13_rec_key from z13;
Z13_REC_K
---------
Category: Cataloging (500)
Subject: Services
- Article last edited: 10/8/2013