Oracle error: io_z05_write

• 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.