My Oracle Support Banner

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 later
Information 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

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.