Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. manage-50: Oracle unique constraint errors on xxx60 z00, z13, z103, and z07

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

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • manage-50 deletes item on loan
      • manage-62 - How to find out which records were fixed?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. Cataloging (500)
      3. contype:kba
      4. Prod:Aleph
      5. Services
      6. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved