My Oracle Support Banner

Migrated Connectors Publish fails with error 'java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ODI_REPO_NAME.AK_TABLE) violated' using same EDD (Doc ID 2453791.1)

Last updated on OCTOBER 01, 2018

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.3 to 8.0.3 [Release 8]
Information in this document applies to any platform.

Symptoms

 1) Publish fails for saved connectors throwing below error in  DIHWebServices.log:

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.1.v20150916-55dc7c3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DIH_ODI_REPO.AK_TABLE) violated
Error Code: 1
Call: INSERT INTO SNP_TABLE (I_TABLE, IND_JRN, JRN_ORDER, WS_NAME, WS_ENTITY_NAME, TABLE_TYPE, TABLE_ALIAS, IND_WS, IND_SHOW, FIRST_DATE, FIRST_USER, GLOBAL_ID, INT_VERSION, LAST_DATE, LAST_USER, PARTITION_METH, TABLE_NAME, OLAP_TYPE, RES_NAME, R_COUNT, SC_ORIG_TABLE_TAG, SUB_PARTITION_METH, FILE_DEC_SEP, FILE_SEP_FIELD, FILE_FORMAT, FILE_SEP_ROW, FILE_FIRST_ROW, FILE_ENC_FIELD, I_TXT_DESC, I_SC_BASE_TABLE, I_SC_ORIG_TABLE, I_SC_TABLE, I_SUB_MODEL, I_MOD) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [34 parameters bound]
Query: InsertObjectQuery(oracle.odi.domain.model.OdiDataStore I_EXPOR_SUNGARDISSUER_REF)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:902)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:964)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:633)
at com.ofs.reveleus.DIH.model.OdiUtility.persistEntity(OdiUtility.java:141)
at com.ofs.reveleus.DIH.model.ODIMapping.buildDataStores(ODIMapping.java:513)

2) On attempt of Publish of a Connector in Unpublished status throws error in UI as 'All mapped EDDs must be joined' . In the Connector definition, source column showing blank in view and edit mode.

3) The EDD for which publish fails is duplicated. All the connectors reported are on the same EDD. Duplicate EDD found with same name , one in saved and other in Published status. There are no dependencies for saved EDD's whereas Published EDD has dependencies.  

 Log shows migration of same dump was invoked twice. It caused duplication of EDD which was shared across the  connectors which could not get published. As this was shared metadata, duplicate migration of this specific EDD while being in transient state during migration created duplicate EDD.

Changes

 All Connectors Migrated from lower environment to higher environment using Command Line Object Migration Utility. 

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!


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