OPA Upgrade From 23c To 24A Fails with ORA-02429: cannot drop index used for enforcement of unique/primary key
(Doc ID 3027816.1)
Last updated on JUNE 10, 2024
Applies to:
Oracle Policy Automation - Version 12.2.32 and laterInformation in this document applies to any platform.
Symptoms
The customer is trying to upgrade OPA 23(12.2.32.485) to 24A (12.2.3) following the document:
When we apply the redeploy command, It shows news Error:
Executing sql update script...
com.oracle.determinations.hub.exception.HubRuntimeException: error updating db schema for deployment 'opahub'
at com.oracle.determinations.hub.exec.UpgradeDatabaseCommand.exec(UpgradeDatabaseCommand.java:160)
at com.oracle.determinations.hub.exec.customer.BuildInstallAndRedeployCommand.exec(BuildInstallAndRedeployCommand.java:65)
at com.oracle.determinations.hub.exec.HubExecCmdLineCustomer.main(HubExecCmdLineCustomer.java:177)
Caused by: java.sql.SQLException: ORA-02429: cannot drop index used for enforcement of unique/primary key
ORA-06512: at "OPAHUB.OPA_DROP_INDEX_IF_EXISTS", line 9
com.oracle.determinations.hub.exec.UpgradeDatabaseCommand.exec(UpgradeDatabaseCommand.java:150)
... 2 more
Caused by: Error : 2429, Position : 5, Sql = CALL opa_drop_index_if_exists('test_suite_unique_names'), OriginalSql = CALL opa_drop_index_if_exists('test_suite_unique_names'), Error Msg = ORA-02429: cannot drop index used for enforcement of unique/primary key
ORA-06512: at "OPAHUB.OPA_DROP_INDEX_IF_EXISTS", line 9
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
... 17 more
com.oracle.determinations.hub.exception.HubRuntimeException: error updating db schema for deployment 'opahub'
at com.oracle.determinations.hub.exec.UpgradeDatabaseCommand.exec(UpgradeDatabaseCommand.java:160)
at com.oracle.determinations.hub.exec.customer.BuildInstallAndRedeployCommand.exec(BuildInstallAndRedeployCommand.java:65)
at com.oracle.determinations.hub.exec.HubExecCmdLineCustomer.main(HubExecCmdLineCustomer.java:177)
Caused by: java.sql.SQLException: ORA-02429: cannot drop index used for enforcement of unique/primary key
ORA-06512: at "OPAHUB.OPA_DROP_INDEX_IF_EXISTS", line 9
com.oracle.determinations.hub.exec.UpgradeDatabaseCommand.exec(UpgradeDatabaseCommand.java:150)
... 2 more
Caused by: Error : 2429, Position : 5, Sql = CALL opa_drop_index_if_exists('test_suite_unique_names'), OriginalSql = CALL opa_drop_index_if_exists('test_suite_unique_names'), Error Msg = ORA-02429: cannot drop index used for enforcement of unique/primary key
ORA-06512: at "OPAHUB.OPA_DROP_INDEX_IF_EXISTS", line 9
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
... 17 more
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |