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 | 2 years ago
  1. 0

    W_04.02.02.01_04.02.03.01.xml error

    Oracle Community | 2 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 | 5 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. balintn 4 times, last 2 weeks ago
  2. mellson 8 times, last 3 months ago
  3. mellson 2 times, last 3 months ago
  4. balintn 2 times, last 3 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