Upgrade Express 19-20: unique constraint error on Z52_ID
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description:
We've run through the entire UE19-20 and UE20-21 upgrade processes once for both the Aleph files & Oracle data. Now we're rerunning the upgrade for just the Oracle data to get better test data. I ran the UE19-20 upgrade express and everything went fine except for step 1010, where we got a unique constraint violation for Z52_ID:
Step begin 1010
Inserting new record to xxx50.Z52
DBD::Oracle::db do failed: ORA-00001: unique constraint (xxx50.Z52_ID) violated (DBD ERROR: OCIStmtExecute) [for Statement "insert into IBT50.z52 values ('last-invoice-no', '', '0', 'Y', '', 'S') "] at ./source/1010/implement_a.pl line 14.
Step end 1010
Resolution:
The z52 is the util g/2. Step 1010 is trying to add the last-invoice-no to the abc50 z52.
The abc50 util g/2 shows that it already has a last-invoice-no, so this step is not necessary. You can ignore this error.
- Article last edited: 12-Mar-2016