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. Oracle error: io_z07_write; unique constraint (xxx01.Z07_ID) violated

    Oracle error: io_z07_write; unique constraint (xxx01.Z07_ID) violated

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    • Article Type: Q&A
    • Product: Aleph

    Question

    The following error message appears in pc_server log or in the xxx50/scratch/ ue_01 log or in a p_manage_50 log:
    Oracle error: io_z07_write
    ORA-00001: unique constraint (xxx01.Z07_ID) violated

    What is this message about and how to avoid it?

    Answer

    This indicates that an attempt to create a Z07 (indexing request) for a particular doc record has failed because a Z07 already exists for this doc #. The system intentionally prevents a second z07 for the same doc number from being written (to avoid unnecessary processing).

    Since this duplicate Z07 doesn't really *need* to be written, this message can be ignored.

    Category: Background processing (500) - ALEPH

    Subject: Indexing (500) - ALEPH


    • Article last edited: 12/5/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Oracle error: io_z05_write
      • Oracle error: io_z07a_write; unique constraint (xxx01.Z07A_ID) violated
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. Background processing (500) - ALEPH
      2. contype:kba
      3. Indexing (500) - ALEPH
      4. Prod:Aleph
      5. Type:Q&A
    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