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_z05_write

    Oracle error: io_z05_write

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    Problem Symptoms:
    The following error messages in the www_server_nnnn.log, pc_server_nnnn.log, or output of some other Aleph process:
       Oracle error: io_z05_write
       ORA-00001: unique constraint (VIR01.Z05_ID) violated
       io_z05_write: REATTEMPTING TO WRITE Z05...


    Cause:
    Duplicate Oracle key for Oracle table VIR01.Z05.   util a/17/11/2 for the vir01 z05 table shows:

           COUNT(*)
       ----------------------------------------
          1000000

     

    As seen in the ./alephm/source/copy/Z05 file:

              02 Z05-REC-KEY.                                                      K
                03 Z05-NUMBER           PICTURE 9(6).

    the z05 rec-key is only 6 digits; the maximum value is 999,999.   When it reaches 1000000, it wraps around and attempts to write a key of '000000', which already exists.  Thus, the "unique constraint (VIR01.Z05_ID) violated".


    Resolution:
    Stop all the Aleph server and services as follows
       cd $alephe_root
       csh -f aleph_shutdown

    Clean the VIR01 library with  $aleph_proc/clear_vir01 or Util x/8 (cold mode).
    Restart the Aleph server and services with csh -f aleph_startup.

    Note:  If it's a time of low activity, util a/17/1 ("Drop & Create Table and Index") could probably be run successfully for the vir01 z05 and z110 tables.  (The z05 and z110 go together and both would need to be dropped/recreated.) This would immediately fix the z05 error without requiring aleph_shutdown/_startup. 

    Additional Information

    It is strongly recommend to execute clear_vir01 on regular basis. See Regularly Performed Jobs in Aleph.

    Check for clear_vir01 in the $alephe_tab/job_list.  Make sure that the entry is active (-- not commented out --). 

     

     


    • Article last edited: 7-Nov-2017
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Oracle error: io_z02_write
      • Oracle error: io_z07_write; unique constraint (xxx01.Z07_ID) violated
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. Cataloging (500)
      3. contype:kba
      4. Create / Edit records (500)
      5. Prod:Aleph
      6. 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