Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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
    • Was this article helpful?