MDM Upgrade for SMDF Databas Portion Fails with "ORA-00904: "IMD_CTRL_MC_ID": invalid identifier" (Doc ID 2261383.1)

Last updated on AUGUST 30, 2022

Applies to:

Symptoms

During thee database portion of the SMDF upgrade, the following issue occurs.

This can occur during any of the upgrades, e.g. 2.1.0.3 to 2.2 - or earlier upgrades for example 2.1.0.9 to 2.1.0.2, etc...

2017-04-26 22:21:31,755 [main] ERROR (oem.install.OraDBI) Error while executing SQL: StmtType-U, Stmt-INSERT INTO D1_IMD_CTRL
(INIT_MSRMT_DATA_ID ,
IMD_CTRL_DC_ID,
IMD_CTRL_MC_ID,
BUS_OBJ_CD,
BO_STATUS_CD,
D1_TO_DTTM,
CRE_DTTM)
(SELECT
INIT_MSRMT_DATA_ID ,
NVL(IMD_CTRL_DC_ID , ' '),
NVL(IMD_CTRL_MC_ID, ' '),
BUS_OBJ_CD,
BO_STATUS_CD,
D1_TO_DTTM,
CRE_DTTM
FROM D1_INIT_MSRMT_DATA WHERE IMD_CTRL_MC_ID > ' '
AND INIT_MSRMT_DATA_ID NOT IN (SELECT INIT_MSRMT_DATA_ID FROM D1_IMD_CTRL))
 

ERROR
-----------------------

 - 2017-04-26 22:21:31,755 [main] ERROR (oem.install.OraDBI)
java.sql.SQLSyntaxErrorException: ORA-00904: "IMD_CTRL_MC_ID": invalid identifier
 
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)
  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
  at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1707)
  at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1670)
  at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:310)
  at com.oracle.ouaf.oem.install.OraDBI.ExecuteSql(OraDBI.java:2412)
  at com.oracle.ouaf.oem.install.OraDBI.ProcessDRVFile(OraDBI.java:1609)
  at com.oracle.ouaf.oem.install.OraDBI.ExecUpgScripts(OraDBI.java:1315)
  at com.oracle.ouaf.oem.install.OraDBI.mymain(OraDB



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade from 2.1.0.3 to 2.2 or any other recent version combination since 2.1.0.4 release.
2. On SMDF DB STEP, attempt upgrade script.
3. Get the error as described.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot continue with the upgrade

Changes

Cause

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