ODI Upgrade From 12.2.1.0.0 To 12.2.1.2.6 - "unique constraint (<SCHEMA>.PK_LINE_TRT) violated" (Doc ID 2442759.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

When attempting to upgrade Oracle Data Integrator (ODI) from 12.2.1.0.0 to 12.2.1.2.6, the upgrade log contains the following error:

[2018-07-02T13:52:32.005+02:00] [odi] [WARNING] [] [oracle.odi.mapping] [tid: 55] [ecid: <ECID>] Refresh seeded objects failed.
[2018-07-02T13:52:32.006+02:00] [odi] [ERROR] [] [oracle.odi.mapping] [tid: 55] [ecid: <ECID>] oracle.odi.domain.adapter.AdapterException[[
  at oracle.odi.adapter.OdiAdapter.refreshRepositorySeededObjects(OdiAdapter.java:582)
  at oracle.odi.adapter.OdiAdapter$OdiAdapterInstanceListener.afterOpen(OdiAdapter.java:253)
  at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:726)
  at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:667)
  at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:646)
  at oracle.ias.update.plugin.odi.ODIPlugin.upgrade(ODIPlugin.java:507)
  at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:710)
  at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:720)
  at oracle.ias.update.PhaseProcessor$UpgradeProcessor.runStepPhase(PhaseProcessor.java:720)
  at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:363)
  at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1044)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  at java.lang.Thread.run(Thread.java:745)
Caused by: oracle.odi.core.repository.RepositoryIntegrityViolationException: ODI-10143: Error while accessing the ODI repository.
ORA-00001: unique constraint (<SCHEMA>.PK_LINE_TRT) violated
  at oracle.odi.core.repository.RepositoryAccessExceptionTranslator.translateSpringException(RepositoryAccessExceptionTranslator.java:231)
  at oracle.odi.core.repository.RepositoryAccessExceptionTranslator.translateExceptionIfPossible(RepositoryAccessExceptionTranslator.java:105)
  at oracle.odi.core.persistence.transaction.support.TransactionManagerSpringAdapter.translateSpringDataAccessException(TransactionManagerSpringAdapter.java:108)
  at oracle.odi.core.persistence.transaction.support.TransactionManagerSpringAdapter.commit(TransactionManagerSpringAdapter.java:76)
  at oracle.odi.scripting.MultiCallTransactionTemplate.executeAll(MultiCallTransactionTemplate.java:126)
  at oracle.odi.scripting.odixml.OdiXMLParser.endElement(OdiXMLParser.java:2459)
  at oracle.odi.scripting.odixml.MappingBuilderXMLParser.endElement(MappingBuilderXMLParser.java:2495)
  at oracle.odi.scripting.odibuilder.JOdiBuilder.end(JOdiBuilder.java:260)
  at oracle.odi.scripting.odibuilder.JOdiBuilder.endTransaction(JOdiBuilder.java:364)
  at oracle.odi.adapter.GlobalObjectHelper.loadXMLFileInNewTxn(GlobalObjectHelper.java:264)
  at oracle.odi.adapter.GlobalObjectHelper.loadSeededKMs(GlobalObjectHelper.java:223)
  at oracle.odi.adapter.GlobalObjectHelper.loadAllKMs(GlobalObjectHelper.java:445)
  at oracle.odi.adapter.OdiAdapter.refreshRepositorySeededObjects(OdiAdapter.java:558)
...

Cause

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