Upgrade 6.2.x to 9.x fails due to ORA-02449

Document ID : KB000128529
Last Modified Date : 12/04/2019
Show Technical Document Details
Issue:
Upgrade from CA Strong Authentication 6.2.x to 9.x fails with the following error:

Caused by: java.sql.SQLException: ORA-20010: -2449-ORA-02449: unique/primary keys in table referenced by foreign keys
ORA-06512: at "ARCOTUSER.ARMODIFY_REPORTS_SP", line 14
ORA-06512: at line 1
Environment:
CA Strong Authentication 6.2.11 to 9.x running with an Oracle dB
Cause:
DROP of tables during upgrade of DB via "aa-common-procedure-alterprocedures-1.0.x-to-8.1.2.sql" script fails with the following error message.

Caused by: java.sql.SQLException: ORA-20010: -2449-ORA-02449: unique/primary keys in table referenced by foreign keys 
ORA-06512: at "ARCOTUSER.ARMODIFY_REPORTS_SP", line 14 
ORA-06512: at line 1 ORA-02449: unique/primary keys in table referenced by foreign keys
Resolution:
A modified version of "aa-common-procedure-alterprocedures-1.0.x-to-8.1.2.sql" exists at 9.x that resolves this issue without affecting the referential integrity.

The new script aa-common-procedure-alterprocedures-1.0.x-to-8.1.2.sql provided should be placed in the <AA-Upgrade-folder>/dbscripts\oracle\upgrade-scripts\629_227-81\common folder and then re-run the upgrade tool -  aa-upgrade-tool.jar..
Additional Information:
There is recommended version of Upgrade tool that should be requested for 6.2.x to 9.0 upgrade - AA-UPGRADE-6.2.X-7.X-2.2.6-ABOVE-3.X-TO-9.0-DE411869-DE407432.zip