Error "ORA-02292: integrity constraint (WORKREP_NAME.FK_MTXT_PART) violated" when Upgrading ODI 11.1.1.5 (Doc ID 2675642.1)

Last updated on AUGUST 09, 2021

Applies to:

Symptoms

When attempting to upgrade Oracle Data Integrator (ODI) from 11.1.1.5 to 11.1.1.6, the following error occurs:

[2020-05-25T22:49:36.194+01:00] [ODI] [ERROR] [UPGCMP-00333] [upgrade.ODI] [tid: <TID>] [ecid: <ECID>] Unknown error happened.
[2020-05-25T22:49:36.194+01:00] [ODI] [ERROR] [] [upgrade.ODI] [tid: <TID>] [ecid: <ECID>] Cause: Unknown error happened. Action: Restore Master Repository from Backup and try to upgrade again.
[2020-05-25T22:49:36.194+01:00] [ODI] [ERROR] [] [upgrade.ODI] [tid: <TID>] [ecid: <ECID>] [[
oracle.odi.setup.RepositorySetupException: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (<ODI_REPOSITORY_NAME>.FK_MTXT_PART) violated - child record found
at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:192)
at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:206)
at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:101)
at oracle.ias.mrua.plugin.odi.ODIPlugin.doUpgrade(ODIPlugin.java:462)
at oracle.ias.mrua.MRUA.executePlugins(MRUA.java:3576)
at oracle.ias.mrua.MRUA.internal_driver(MRUA.java:2357)
at oracle.ias.mrua.MRUA.driver(MRUA.java:1621)
at oracle.ias.upgrade.gui.UAUpgradeThread.run(UAUpgradeThread.java:390)
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (<ODI_REPOSITORY_NAME>.FK_MTXT_PART) violated - child record found
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java:712)
at com.sunopsis.dwg.DwgObject.deleteAction(DwgObject.java:1212)
at com.sunopsis.dwg.DwgObject.deleteGlobal(DwgObject.java:1321)
at com.sunopsis.dwg.DwgObject.deleteGlobal(DwgObject.java:1328)
at com.sunopsis.dwg.DwgObject.delete(DwgObject.java:951)
at com.sunopsis.dwg.DwgObject.delete(DwgObject.java:930)
at com.sunopsis.dwg.dbobj.SnpMtxt.saveText(SnpMtxt.java:332)
at com.sunopsis.repository.manager.RepositoryManager.updateSecurityConnection(RepositoryManager.java:3777)
at com.sunopsis.repository.manager.RepositoryManager.masterRepositoryPatch(RepositoryManager.java:3173)
at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:185)
... 7 more

Cause

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