Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    ORA-00001 in SIP2 Server log

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    * Seeing these messages in SIP2 Server logfile sip2_server_nnnn.log:
    Oracle error: io_z36_write
    ORA-00001: unique constraint (XXX50.Z36_ID) violated

    Cause:
    Wrong behaviour of self check machine
    The machine is sending "Cancel Checkin Requests" (SIP2 message 11 with Cancel Flag BI= Y) after a preceding "Checkout message" (SIP2 message 11 without Cancel Flag)

    Resolution:
    * Check with vendor of self check machine to correct the behaviour

    Additional Information

    According to SIP2 protocol definition "Checkout"-messages (SIP2 message 11) must be canceled with SIP2 Message 09 (Checkin) with Cancel Flag (BI) = Y.

    Category: Circulation (500)

    Subject: Self check (500)

    • Article last edited: 10/8/2013