My Oracle Support Banner

"ORA-00001: unique constraint (<SCHEMA>.AK_LE_TECHNO_GUID) violated" when Running the Upgrade Assistance for ODI 12.2.1.3.190708 Bundle Patch (Doc ID 2634867.1)

Last updated on MAY 28, 2021

Applies to:

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

Symptoms

While running the Upgrade Assistance as part of the Oracle Data Integrator (ODI) Bundle <Patch 29778645> 12.2.1.3.190708 post-installations steps, the following error may occur:

[2020-01-08T02:40:34.674+00:00] [ODI] [INCIDENT_ERROR] [upgrade.ODI.ODI1] java.lang.RuntimeException: oracle.odi.impexp.OdiImportGenericException: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10245: Cannot import SNP_LETECHNO null (with global id: <TECH_GLOBAL_ID> and internal id: <INTERNAL_ID> | <INTERNAL_ID>) belonging to SNP_LANG SQL (with global id: <LANG_GLOBAL_ID> and internal id: <INTERNAL_ID>) because its referenced object is not found in the target repository.
[2020-01-08T02:40:34.674+00:00] [ODI] [INCIDENT_ERROR] [upgrade.ODI.ODI1]
java.lang.RuntimeException: java.lang.RuntimeException: oracle.odi.impexp.OdiImportGenericException: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10245: Cannot import SNP_LETECHNO null (with global id: <TECH_GLOBAL_ID> and internal id: <INTERNAL_ID> | <INTERNAL_ID>) belonging to SNP_LANG SQL (with global id: <LANG_GLOBAL_ID> and internal id: <INTERNAL_ID>) because its referenced object is not found in the target repository.
  at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:485)
  at oracle.ias.update.plugin.odi.ODIPlugin.upgrade(ODIPlugin.java:432)
  at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:730)
  at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:736)
  ...
Caused by: java.lang.RuntimeException: oracle.odi.impexp.OdiImportGenericException: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10245: Cannot import SNP_LETECHNO null (with global id: <TECH_GLOBAL_ID> and internal id: <INTERNAL_ID> | <INTERNAL_ID>) belonging to SNP_LANG SQL (with global id: <LANG_GLOBAL_ID> and internal id: <INTERNAL_ID>) because its referenced object is not found in the target repository.
  at oracle.odi.setup.RepositoryUpgradeServiceImpl$1.doInTransaction(RepositoryUpgradeServiceImpl.java:474)
  at oracle.odi.core.persistence.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:100)
  at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:466)
  ... 9 more
Caused by: oracle.odi.impexp.OdiImportGenericException: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10245: Cannot import SNP_LETECHNO null (with global id: <TECH_GLOBAL_ID> and internal id: <INTERNAL_ID> | <INTERNAL_ID>) belonging to SNP_LANG SQL (with global id: <LANG_GLOBAL_ID> and internal id: <INTERNAL_ID>) because its referenced object is not found in the target repository.
  at oracle.odi.impexp.support.ImportServiceImpl.reimportTopologyReferenceData(ImportServiceImpl.java:2205)
  at oracle.odi.setup.RepositoryUpgradeServiceImpl$1.doInTransaction(RepositoryUpgradeServiceImpl.java:471)
  ... 11 more
Caused by: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10245: Cannot import SNP_LETECHNO null (with global id: <TECH_GLOBAL_ID> and internal id: <INTERNAL_ID> | <INTERNAL_ID>) belonging to SNP_LANG SQL (with global id: <LANG_GLOBAL_ID> and internal id: <INTERNAL_ID>) because its referenced object is not found in the target repository.
  at com.sunopsis.dwg.DwgDuplicationTools.importOtherObjects(DwgDuplicationTools.java:5031)
  at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(DwgDuplicationTools.java:4068)
  at com.sunopsis.dwg.DwgObject.importFromObjectLst(DwgObject.java:10159)
  at com.sunopsis.dwg.DwgObject.internalImportObjectList(DwgObject.java:8775)
  at com.sunopsis.dwg.DwgObject.doImport(DwgObject.java:9255)
  at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:7674)
  at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:7605)
  at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:7538)
  at com.sunopsis.repository.manager.RepositoryManager.importObjectsUsingImportFromXML(RepositoryManager.java:7842)
  at com.sunopsis.repository.manager.RepositoryManager.treatObjectList(RepositoryManager.java:5213)
  at com.sunopsis.repository.manager.RepositoryManager.reimportTopologyReferenceData(RepositoryManager.java:8211)
  at oracle.odi.impexp.support.ImportServiceImpl.internalReimportTopologyReferenceData(ImportServiceImpl.java:2122)
  at oracle.odi.impexp.support.ImportServiceImpl$19.doAction(ImportServiceImpl.java:2191)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:173)
  at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:41)
  at oracle.odi.impexp.support.ImportServiceImpl.reimportTopologyReferenceData(ImportServiceImpl.java:2184)
  ... 12 more
Caused by: com.sunopsis.dwg.SQLMasterReposException: ORA-00001: unique constraint (<DATABAVSE_SCHEMA_NAME>.AK_LE_TECHNO_GUID) violated
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:227)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:60)
  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:911)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1194)
  ...
Caused by: Error : 1, Position : 0, Sql = insert into SNP_LE_TECHNO (GLOBAL_ID,I_LANG_ELT,I_TECHNO,I_TXT_LT_HELP,LT_EXCEPTION,LT_NAME,LT_TXT) values (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ), OriginalSql = insert into SNP_LE_TECHNO (GLOBAL_ID,I_LANG_ELT,I_TECHNO,I_TXT_LT_HELP,LT_EXCEPTION,LT_NAME,LT_TXT) values (?,?,?,?,?,?,?), Error Msg = ORA-00001: unique constraint (<DATABSE_SCHEMA_NAME>.AK_LE_TECHNO_GUID) violated
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
  ... 53 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!


In this Document
Symptoms
Cause
Solution
References


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