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 SEPTEMBER 11, 2023
Applies to:
Oracle Utilities Meter Data Management - Version 2.2.0.3.0 and laterInformation 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 |