oracle.odi.setup.RepositorySetupException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • W_04.02.02.01_04.02.03.01.xml error
    via by 2693506,
  • About Oracle Webcenter/Cloud/ADF/MAF
    via by Unknown author,
  • ODI Agent Failed
    via by Kimi,
  • Active Directory Group Recon Error in OIM11gR2
    via by Srivatsa.kashyap,
  • ERROR: Exception occured while encrypting the configuration and database
    via by 0ee42ec1-f32b-4d8c-b500-fbe23327a2c1,
    • oracle.odi.setup.RepositorySetupException: java.lang.RuntimeException: Error while executing alter table SNP_TXT add constraint FK_TXT foreign key ( I_TXT_ORIG ) references SNP_ORIG_TXT ( I_TXT_ORIG ) at oracle.odi.setup.support.WorkRepositorySetupImpl$3.doAction(WorkRepositorySetupImpl.java:542) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:186) at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:41) at oracle.odi.setup.support.WorkRepositorySetupImpl.upgradeWorkRepository(WorkRepositorySetupImpl.java:443) at oracle.odi.setup.support.WorkRepositorySetupImpl.upgradeWorkRepository(WorkRepositorySetupImpl.java:153) at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeWork(RepositoryUpgradeServiceImpl.java:57) at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:136) at oracle.ias.mrua.plugin.odi.ODIPlugin.doUpgrade(ODIPlugin.java:466) 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.lang.RuntimeException: Error while executing alter table SNP_TXT add constraint FK_TXT foreign key ( I_TXT_ORIG ) references SNP_ORIG_TXT ( I_TXT_ORIG ) at com.sunopsis.dwg.xml.DwgXmlSession.execute(DwgXmlSession.java:92) at com.sunopsis.repository.manager.DDLSessionExecutor.executeDDL(DDLSessionExecutor.java:97) at com.sunopsis.repository.manager.oldupgrade.Pre04_03_03_02Upgrader.executeXmlAbsoluteFile(Pre04_03_03_02Upgrader.java:232) at com.sunopsis.repository.manager.oldupgrade.Pre04_03_03_02Upgrader.workUpgradePre04_03_03_02(Pre04_03_03_02Upgrader.java:333) at com.sunopsis.repository.manager.RepositoryManager.workRepositoryPatch(RepositoryManager.java:5072) at oracle.odi.setup.support.WorkRepositorySetupImpl$3.doAction(WorkRepositorySetupImpl.java:527) ... 11 more Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (ODIREPWRK.FK_TXT) - parent keys not 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.xml.DwgXmlSession.execute(DwgXmlSession.java:86)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    26 more bugmates