My Oracle Support Banner

Error Observed In Installation Of Oracle Utilities Application Framework Database Component Component While Upgrading From MDM 2.2.0.2 To 2.2.0.3 (Doc ID 2866048.1)

Last updated on MAY 02, 2022

Applies to:

Oracle Utilities Meter Data Management - Version 2.2.0.3.0 and later
Information in this document applies to any platform.

Goal

Issue - Error Observed In Installation Of  Oracle Utilities Application Framework Database Component Component While Upgrading From MDM 2.2.0.2 To 2.2.0.3


Error -

Below error observed while Installing the Oracle Utilities Application Framework Database Component using OraDBI.jar as part of MDM upgrade from v2.2.0.2 to 2.2.0.3

 - 2022-03-24 13:14:15,391 [main] DEBUG (oem.install.OraSchUpg)
DROP INDEX XT039P0_ILM;

 - 2022-03-24 13:14:15,437 [main] DEBUG (oem.install.OraSchUpg) Ignorable error occurred while executing SQL: StmtType-DR, Stmt-DROP INDEX XT039P0_ILM
 - 2022-03-24 13:14:15,438 [main] DEBUG (oem.install.OraSchUpg) Ingoring: ORA-02429. Will try again after dropping primary key

 - 2022-03-24 13:14:15,438 [main] DEBUG (oem.install.OraSchUpg)
ALTER TABLE CI_TD_ENTRY DROP PRIMARY KEY CASCADE;

 - 2022-03-24 13:14:15,486 [main] ERROR (oem.install.OraSchUpg) Error while executing SQL: StmtType-A, Stmt-ALTER TABLE CI_TD_ENTRY DROP PRIMARY KEY CASCADE

 - 2022-03-24 13:14:15,488 [main] ERROR (oem.install.OraSchUpg)
java.sql.SQLException: ORA-14668: Cannot drop a unique or primary key referenced by the partitioning constraint of a reference-partitioned table.
 

Solution

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
Goal
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.