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

    unique constraint (ABC01.Z69_ID) violated

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

    Description:
    In the www_server_4991.log files I see a couple of errors that are:

    WWW-F : SCAN 2007-04-10 09:08:33 17
    server_main: OUT 0.5367 16841

    Oracle error: io_z69_write
    ORA-00001: unique constraint (ABC01.Z69_ID) violated

    They are for the same IP address, but there are other scans and finds by that IP that aren't generating messages.

    Resolution:
    You can ignore this error. The Z69 table is an OPAC transaction log. The unique constraint is that records have to have different time stamps for each entry.

    In this case, two events happened so close together that they shared the exact same time stamp. If two transactions are written at the same time, the second will fail -- but then another (successful) attempt will be done a second later.

    • Article last edited: 10/8/2013