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. unique constraint (XXX50.Z36_ID) in pc_server.log

    unique constraint (XXX50.Z36_ID) in pc_server.log

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    Seeing many such error messages in pc_server.log:
    Oracle error: io_z36_write
    ORA-00001: unique constraint (XXX50.Z36_ID) violated

    Cause:
    Aleph GUI tries to perform a loan of an item that is already on loan. This is (properly) blocked by Oracle.

    Resolution:
    Z36_ID is a unique index on Z36_REC_KEY that contains the ADM-number plus item sequence.

    The message indicates that the system tries write a loan record for an item that already has a loan record. Of course this is not allowed. Usually such cases should already blocked by Aleph GUI and not by Oracle. Obviously GUI for any reason did not block this attempt in this single case.

    WE see in the logfile that there were exactly 1000 such messages during few seconds (there are 1000 error messages as Aleph tries 1000 times to write the Z36-record before it gives up). There were no other such messages before or after that.

    So the message does not indicate a general problem if it happens randomly. In any case there is no problem with the data consistency.

    Category: System Management (500)

    Subject: Oracle (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • unique constraint (xxx50.z34_ID )"
      • Unique constraint (xxxnn.Znn_ID) violated" *COMPREHENSIVE RECORD*
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Oracle (500)
      4. Prod:Aleph
      5. System Management (500)
      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