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.
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)
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.
All Connectors Migrated from lower environment to higher environment using Command Line Object Migration Utility.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!