Upgrade to ODI 12.2.1.3.0 Fails "while executing DDL Patch E_05.02.02.03_05.02.02.04.xml" and ORA-02298 Error
(Doc ID 2313300.1)
Last updated on JUNE 16, 2022
Applies to:
Oracle Data Integrator - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
The following error occurs when attempting to run the Oracle Data integrator (ODI) 12.2.1.3.0 Upgrade Assistant (UA):
[2017-09-30T08:36:23.313+05:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [tid: <TID>] [ecid: <ECID>] [[
oracle.odi.setup.RepositorySetupException: com.sunopsis.repository.manager.upgrade.RepositoryUpgradeException: Error while executing DDL Patch E_05.02.02.03_05.02.02.04.xml
at oracle.odi.setup.support.WorkRepositorySetupImpl$5.doAction(WorkRepositorySetupImpl.java:1329)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:173)
at ...
Caused by: com.sunopsis.repository.manager.upgrade.RepositoryUpgradeException: Error while executing DDL Patch E_05.02.02.03_05.02.02.04.xml
at com.sunopsis.repository.manager.upgrade.AbstractRepositoryUpgrade.executeUpgradeDDL(AbstractRepositoryUpgrade.java:157)
at com.sunopsis.repository.manager.upgrade.AbstractRepositoryUpgrade.upgradeDesignRepository(AbstractRepositoryUpgrade.java:174)
at com.sunopsis.repository.manager.upgrade.RepositoryUpgradeRunner.upgradeDesignRepository(RepositoryUpgradeRunner.java:410)
at com.sunopsis.repository.manager.RepositoryManager.workRepositoryPatch(RepositoryManager.java:6848)
at oracle.odi.setup.support.WorkRepositorySetupImpl$5.doAction(WorkRepositorySetupImpl.java:1301)
... 15 more
Caused by: java.lang.RuntimeException: Error while executing alter table SNP_STEP_LOG add constraint FK_STEP_LOG foreign key ( SESS_NO ) references SNP_SESSION ( SESS_NO )
at com.sunopsis.dwg.xml.DwgXmlSession.execute(DwgXmlSession.java:101)
at com.sunopsis.repository.manager.DDLSessionExecutor.executeDDL(DDLSessionExecutor.java:124)
at com.sunopsis.repository.manager.upgrade.AbstractRepositoryUpgrade.executeUpgradeDDL(AbstractRepositoryUpgrade.java:155)
... 19 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (DEV_ODI_REPO.FK_STEP_LOG) - parent keys not found
Changes
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 |
Changes |
Cause |
Solution |
References |