• Article Type: General
• Product: Aleph
• Product Version: 17.01

Description:
www_server log shows 1834 occurrences of this error:
Oracle error: io_z110_write
ORA-00001: unique constraint (VIR01.Z110_ID) violated

>>grep -c 'unique constraint (VIR01.Z110_ID) violated' www_server_14600.log
1834

Resolution:
This error occurs because the Z110-NUMBER (the first 6 digits of z110_rec_key) has reached 999999:

SQL-VIR01> select max (z110_rec_key) from z110;
MAX(Z110_
---------
999999001

The routine which is supposed to reinitialize the Z110 is clear_vir01.

Running clear_vir01 corrected this problem.

clear_vir01 needs to be run with greater frequency.