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 (ABC01.Z69_ID) violated

    unique constraint (ABC01.Z69_ID) violated

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • unique constraint (ABC01.Z69_ID) violated -- and (ABC01.Z35_ID3) violated
      • Unique constraint (XXX50.Z305_ID) violated
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. 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