manage-62: z30h: unique constraint violated

• Product: Aleph
• Product Version: 20, 21, 22, 23
• Relevant for Installation Type: select the relevant: Dedicated-Direct,Direct,Local,Total Care

Description:

In running manage-62 (p_manage_62) the following error appears repeatedly:

  Oracle error: io_z30h_write

  ORA-00001: unique constraint (XXX50.Z30H_ID) violated

  Failed to Write item history :088888888-600001

Resolution:

The z30h_rec_key is assigned by adding 1 to the highest existing Z30H-SEQUENCE number for this Z30H-DOC-NUMBER + Z30H-ITEM-SEQUENCE and using that as the Z30H-SEQUENCE for this new z30h record.

The highest Z30H-SEQUENCE for this item was 999999.  Adding 1 to it gave 000001 and the system was trying to create a record with Z30H-SEQUENCE 000001 -- which already existed.

Since there was no z30 record for this item key ("088888888-600001") SQL was used to delete these extraneous z30h records.  (Note: in version 22-up the util x/13 utility could be used.)

After doing this, there were other problems with manage-62.  See article ("manage-62 hangs when no input file is specified") in this regard.

Note:  If large numbers of items are being read/changed (such as when no input file is being used),  making the change via SQL will be faster.