ODI 12C Upgrade Error "ORA-02292: integrity constraint (REPO.FK_MAPPING_FOLDER) violated - child record found"

(Doc ID 2420055.1)

Last updated on JULY 11, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to upgrade an Oracle Data Integrator (ODI) 12.2.1.0.0 environment to version 12.2.1.2.6, the following error occurs.

[2018-06-08T07:08:55.367+02:00] [odi] [NOTIFICATION:16] [ODI-14063] [oracle.odi.setup] [tid: 56] [ecid: ...] Applying DDL from file /opt/oracle/ora11/product/odi_12.2.1.2.6/odi/sdk/lib/scripts/ORACLE/patches/W_05.02.02.03_05.02.02.04.xml
[2018-06-08T07:08:55.419+02:00] [odi] [ERROR] [ODI-14066] [oracle.odi.setup] [tid: 56] [ecid: ...] upgrade error while executing DELETE FROM SNP_FOLDER WHERE I_PROJECT IS NUll params =
[2018-06-08T07:08:55.423+02:00] [ODI] [INCIDENT_ERROR] [ODIUPG-00011] [upgrade.ODI.ODI1] [tid: 56] [ecid: ...] Unknown error happened.
[2018-06-08T07:08:55.423+02:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [tid: 56] [ecid: ...] Cause: Unknown error happened.
[2018-06-08T07:08:55.423+02:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [tid: 56] [ecid: ...] Action: Restore Work Repository from Backup and try to upgrade again.
[2018-06-08T07:08:55.423+02:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [tid: 56] [ecid: ...] [[
oracle.odi.setup.RepositorySetupException: java.lang.RuntimeException: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (REPO.FK_MAPPING_FOLDER) violated - child record found
  at oracle.odi.setup.support.WorkRepositorySetupImpl$5.doAction(WorkRepositorySetupImpl.java:1138) 
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:173)
  at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:41)
  at oracle.odi.setup.support.WorkRepositorySetupImpl.upgradeWorkRepository(WorkRepositorySetupImpl.java:962)
  ...
Caused by: java.lang.RuntimeException: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (REPO.FK_MAPPING_FOLDER) violated - child record found
  at com.sunopsis.repository.manager.upgrade.V05_02_02_04To05_02_02_05Upgrade.preUpgradeWorkRepositoryCommonData(V05_02_02_04To05_02_02_05Upgrade.java:71)
  at com.sunopsis.repository.manager.upgrade.AbstractRepositoryUpgrade.upgradeDesignRepository(AbstractRepositoryUpgrade.java:170)
  at com.sunopsis.repository.manager.upgrade.RepositoryUpgradeRunner.upgradeDesignRepository(RepositoryUpgradeRunner.java:398)
  at com.sunopsis.repository.manager.RepositoryManager.workRepositoryPatch(RepositoryManager.java:6751)
  at oracle.odi.setup.support.WorkRepositorySetupImpl$5.doAction(WorkRepositorySetupImpl.java:1110)
  ... 15 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (REPO.FK_MAPPING_FOLDER) violated - child record found
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1006)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:5136)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1519)
  at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:353)
  at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:178)
  at com.sun.proxy.$Proxy31.executeUpdate(Unknown Source)
  at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java:689)
  at com.sunopsis.repository.manager.upgrade.AbstractRepositoryUpgrade.executeUpdate(AbstractRepositoryUpgrade.java:477)
  at com.sunopsis.repository.manager.upgrade.V05_02_02_04To05_02_02_05Upgrade.updateSnpFolder(V05_02_02_04To05_02_02_05Upgrade.java:192)
  at com.sunopsis.repository.manager.upgrade.V05_02_02_04To05_02_02_05Upgrade.preUpgradeWorkRepositoryCommonData(V05_02_02_04To05_02_02_05Upgrade.java:69)
  ... 19 more

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