Oracle error: io_z01_write; unique constraint (ABC60.Z01_ID2) violated

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

Description:
I find these errors in the abc60 $data_scratch/ue_01 log:
Oracle error: io_z01_write
ORA-00001: unique constraint (ABC60.Z01_ID2) violated

Resolution:
The abc60 util g/2 had: last-acc-number 232429
while sql showed:
SQL-ABC60> select max (Z01_ACC_SEQUENCE) from z01;
001469828

Therefore, I corrected last-acc-number to be 1469828.

After doing this, the doc records which were sent to the server during the time that the last-acc-number was incorrect will need to be re-sent to the server. You can do this by running p_ret_01 to locate records updated today and using its output as input to p_manage_40. p_manage_40 will produce a z07 indexing request record for each record# in the input file. These z07's will then be processed by ue_01.

KEYWORDS: UTIL-G-2 p-manage-40 manage-40 manage_40