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 NOVEMBER 03, 2017

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information 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: 45] [ecid: acb7938c-8035-4048-83b1-141ac1baf1a9-00000002,0] [[
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms