Connector Publish Fails With ORA-00001: Unique Constraint Violated
(Doc ID 2907243.1)
Last updated on NOVEMBER 26, 2022
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.0.7 and laterInformation in this document applies to any platform.
Symptoms
On DIH :8072
ODI: 12c (12.2.1)
DB: 19c (19.0.0.0.0)
Connector Type: Insert
Connector publish fails with unique constraint (<ODI_REPO>.AK_TABLE) violated
Steps to Reproduce Problem
--------------------------
Unable to publish multiple connectors using the EDD names as mentioned below:
EDD 1: <28 CHARACTERS>_1
EDD 2:<Same 28 Characters as of EDD 1>_2
EDD 3: <SAME 28 CHARACTERS as of EDD 1>_3
Note : as highlighted the first 28 characters of all the EDD names should be same.
Connector 1 which used EDD1 gets published successfully but when trying to publish the connector 2 which uses EDD 2, publish fails.
[ERROR] [ConnectorUtils][publishConnector]Datastore creation in ODI failed java.lang.Exception: Datastore creation in ODI failed at
com.ofs.reveleus.DIH.model.ODIMapping.buildDataStores(ODIMapping.java:555)~[dih.jar:8.0.7.2.0_10177188939600]
…
…
Caused by: oracle.odi.core.repository.RepositoryIntegrityViolationException: ODI-10143: Error while accessing the ODI repository.
ORA-00001: unique constraint (?<ODI_REPO>.AK_TABLE) violated
Changes
Created multiple EDD's where in the first 28 characters are same.
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |