Cannot Perform Reverse Engineering of Salesforce in ODI 12.2.1.4.0
(Doc ID 2615725.1)
Last updated on APRIL 21, 2023
Applies to:
Oracle Data Integrator - Version 12.2.1.4.0 and laterOracle Data Integrator on Marketplace - Version 2.0.2 to 12.2.1.4.210321
Information in this document applies to any platform.
Symptoms
When attempting to reverse engineer tables for a Salesforce model in Oracle Data Integrator (ODI) 12.2.1.4, the following error occurs:
com.sunopsis.dwg.SQLWorkReposException: ORA-00001: unique constraint (<REPOSITORY_SCHEMA>.AK_REV_JOIN) violated
...
Caused by: Error : 1, Position : 0, Sql = insert into SNP_REV_JOIN (CHECK_FLOW,CHECK_STAT,DEFER,DEL_RULE,FK_NAME,FK_TYPE,IND_ACTIVE,I_MOD,MOD_GUID,PK_CATALOG,PK_SCHEMA,PK_TABLE_NAME,TABLE_NAME,UPD_RULE) values (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ), OriginalSql = insert into SNP_REV_JOIN (CHECK_FLOW,CHECK_STAT,DEFER,DEL_RULE,FK_NAME,FK_TYPE,IND_ACTIVE,I_MOD,MOD_GUID,PK_CATALOG,PK_SCHEMA,PK_TABLE_NAME,TABLE_NAME,UPD_RULE) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?), Error Msg = ORA-00001: unique constraint (<REPOSITORY_SCHEMA>.AK_REV_JOIN) violated
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)
... 35 more
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |