Skip to main content
ExLibris

  • Subscribe by RSS
    • Aleph
    Ex Libris Knowledge Center

    manage-50: Oracle unique constraint errors on xxx60 z00, z13, z103, and z07

    1. Last updated
    2. Save as PDF
    • 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