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

book

Article ID: 128529

calendar_today

Updated On:

Products

CA Rapid App Security CA Advanced Authentication CA API Gateway

Issue/Introduction

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

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

Environment

CA Strong Authentication 6.2.11 to 9.x running with an Oracle dB

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