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 )

Oracle Community | 2693506 | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    W_04.02.02.01_04.02.03.01.xml error

    Oracle Community | 3 years ago | 2693506
    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 )
  2. 0

    Error when running Upgrade Assisitant

    Oracle Community | 4 years ago | AMSI
    oracle.odi.setup.RepositorySetupException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (EDW_TRAINING.PK_TXT_HEADER) violated
  3. 0

    Issue in UPgrade ODI 10 g to 11.1.1.6

    Oracle Community | 4 years ago | AMSI
    oracle.odi.setup.RepositorySetupException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (TRAINING_ODI.PK_TXT_HEADER) violated
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle Access Manager default installation issue: ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated

    Oracle Community | 2 years ago | Bram van Pelt
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated
  6. 0

    About Oracle Webcenter/Cloud/ADF/MAF

    wordpress.com | 9 months ago
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OAMAMU_OAM.PK_ENTITIES) violated Error Code: 1 Call: INSERT INTO ENTITIES (ID, CREATE_TIME_STAMP, CREATOR, DESCRIPTION, JOURNAL_ID, MODIFIER, MODIFY_TIME_STAMP, NAME, NAME_PATH, TAG, TRANSACTION_ID, TYPE_NAMES, UNIQUE_ID, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [14 parameters bound] Query: InsertObjectQuery(oracle.security.am.foundation.entity.admin.provider.db.beans.Entities@12db19fb)

  1. tomthomas 2 times, last 3 weeks ago
  2. jpvee 1 times, last 4 months ago
  3. balintn 17 times, last 4 months ago
  4. mellson 8 times, last 7 months ago
7 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLIntegrityConstraintViolationException

    ORA-02298: cannot validate (ODIREPWRK.FK_TXT) - parent keys not found

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
    12 frames
  3. com.sunopsis.sql
    SnpsQuery.executeUpdate
    1. com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java:712)
    1 frame
  4. com.sunopsis.dwg
    DwgXmlSession.execute
    1. com.sunopsis.dwg.xml.DwgXmlSession.execute(DwgXmlSession.java:86)
    1 frame