Upgrade to ODI 12.2.1.4.0 Fails with "Error While Importing Technology Seed Data java.lang.NullPointerException" (Doc ID 2602526.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

Symptoms

When upgrading to Oracle Data Integrator (ODI) 12.2.1.4.0 from a lower ODI 12c or ODI 11g installation, the following error occurrs:

[2019-10-18T18:25:33.439+02:00] [odi] [NOTIFICATION:16] [ODI-14086] [oracle.odi.setup] Begin importing: for <ODI_HOME>/odi/sdk/lib/scripts/xml/TECH_Complex_File.xml
[2019-10-18T18:25:33.606+02:00] [odi] [ERROR] [ODI-14098] [oracle.odi.setup] Error While Importing Technology Seed Data java.lang.NullPointerException
[2019-10-18T18:25:33.617+02:00] [odi] [ERROR] [] [oracle.odi.core.persistence] java.lang.RuntimeException: oracle.odi.impexp.OdiImportGenericException: java.lang.NullPointerException[[
  at oracle.odi.setup.RepositoryUpgradeServiceImpl$1.doInTransaction(RepositoryUpgradeServiceImpl.java:476)
  at oracle.odi.core.persistence.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:100)
  at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:468)
  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)
  at oracle.ias.update.PhaseProcessor$UpgradeProcessor.runStepPhase(PhaseProcessor.java:775)
  at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:382)
  at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1178)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)
Caused by: oracle.odi.impexp.OdiImportGenericException: java.lang.NullPointerException
  at oracle.odi.impexp.support.ImportServiceImpl.reimportTopologyReferenceData(ImportServiceImpl.java:2205)
  at oracle.odi.setup.RepositoryUpgradeServiceImpl$1.doInTransaction(RepositoryUpgradeServiceImpl.java:473)
  ... 11 more
Caused by: java.lang.NullPointerException
  at com.sunopsis.dwg.DwgDuplicationTools.processGlobalIdBatchQuery(DwgDuplicationTools.java:2615)
  at com.sunopsis.dwg.DwgDuplicationTools.batchCheckGlobalIdsInRepository(DwgDuplicationTools.java:2705)
  at com.sunopsis.dwg.DwgDuplicationTools.importOtherObjects(DwgDuplicationTools.java:4690)
  at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(DwgDuplicationTools.java:4107)
  at com.sunopsis.dwg.DwgObject.importFromObjectLst(DwgObject.java:10108)
  at com.sunopsis.dwg.DwgObject.internalImportObjectList(DwgObject.java:8724)
  at com.sunopsis.dwg.DwgObject.doImport(DwgObject.java:9204)
  at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:7618)
  at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:7549)
  at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:7482)
  at com.sunopsis.repository.manager.RepositoryManager.importObjectsUsingImportFromXML(RepositoryManager.java:7845)
  at com.sunopsis.repository.manager.RepositoryManager.treatObjectList(RepositoryManager.java:5214)
  at com.sunopsis.repository.manager.RepositoryManager.reimportTopologyReferenceData(RepositoryManager.java:8189)
  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)
  ...

Changes

Cause