ODI Upgrade Assistant Fails With "ODI-10049: Missing parameter: REP_TIMESTAMP" While Upgrading From 11g to 12c
(Doc ID 2230208.1)
Last updated on JUNE 10, 2021
Applies to:
Oracle Data Integrator - Version 12.1.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
While upgrading from Oracle Data Integrator (ODI) 11g to 12c, the upgrade assistant fails with the following error:
... [odi] [ERROR] [ODI-14096] [oracle.odi.setup] ... Error While Upgrading Master Repository java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: com.sunopsis.sql.SnpsMissingParametersException: ODI-10049: Missing parameter: REP_TIMESTAMP[[
SQL: insert into SNP_M_IMPORT_REP (REP_SHORT_ID, REP_TIMESTAMP, REP_GUID, GLOBAL_ID) values (:REP_SHORT_ID, :REP_TIMESTAMP, :REP_GUID, :GLOBAL_ID)
]]
... [odi] [NOTIFICATION] [] [oracle.odi.setup] ... ==== ODI Upgrade: END - Upgrade Master Repository
... [ODI] [NOTIFICATION] [] [upgrade.ODI.ODI1] ...
... [ODI] [NOTIFICATION] [] [upgrade.ODI.ODI1] ... [[
oracle.ias.update.plugin.odi.exception.UpgradeFailedException
at oracle.ias.update.plugin.odi.ODIPlugin.upgrade(ODIPlugin.java:466)
at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:710)
at ...
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 |