- Article Type: General
- Product: Aleph
- Product Version: 17.01
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
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;
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.
- Article last edited: 10/8/2013