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

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

    • Article Type: Q&A
    • Product: Aleph


    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?


    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