My Oracle Support Banner

Cannot Perform Reverse Engineering of Salesforce in ODI (Doc ID 2615725.1)

Last updated on APRIL 21, 2023

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version 2.0.2 to
Information in this document applies to any platform.


When attempting to reverse engineer tables for a Salesforce model in Oracle Data Integrator (ODI), 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(
  ... 35 more


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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