ODI 12c Upgrade Assistant Throws "Unknown error happened" with "NullPointerException" when Manually Created Datatype in 11g Collides with Same Provided by ODI 12c

(Doc ID 2360870.1)

Last updated on FEBRUARY 19, 2018

Applies to:

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

Symptoms

The following error is thrown when upgrading from 11g to 12c where a datatype/technology has been previously manually created in the repository and the same technologies and/or datatypes are provided as standard in ODI 12c.

The error itself is ambiguous and does not indicate the source of the issue:

[2018-02-01T13:20:30.429+13:00] [odi] [ERROR] [ODI-14096] [oracle.odi.setup] [tid: 50] [ecid: 75dd0c85-d06a-464e-a266-cb3e2e264347-00000002,0] Error While Upgrading Master Repository null
[2018-02-01T13:20:30.435+13:00] [ODI] [INCIDENT_ERROR] [ODIUPG-00008] [upgrade.ODI.ODI1] [tid: 50] [ecid: 75dd0c85-d06a-464e-a266-cb3e2e264347-00000002,0] Unknown error happened.
[2018-02-01T13:20:30.435+13:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [tid: 50] [ecid: 75dd0c85-d06a-464e-a266-cb3e2e264347-00000002,0] Cause: Unknown error happened.
[2018-02-01T13:20:30.436+13:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [tid: 50] [ecid: 75dd0c85-d06a-464e-a266-cb3e2e264347-00000002,0] Action: Restore Master Repository from Backup and try to upgrade again.
[2018-02-01T13:20:30.436+13:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [tid: 50] [ecid: 75dd0c85-d06a-464e-a266-cb3e2e264347-00000002,0] [[
oracle.odi.setup.RepositorySetupException: java.lang.NullPointerException
  at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:797)
  at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:687)
  at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:868)
  at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:421)
  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:726)
  at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:369)
  at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1058)
  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: java.lang.NullPointerException
  at com.sunopsis.repository.manager.RepositoryManager.updateSecurityConnection(RepositoryManager.java:5496)
  at com.sunopsis.repository.manager.RepositoryManager.masterRepositoryPatch(RepositoryManager.java:4857)
  at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:782)
  ... 12 more
]]
[2018-02-01T13:20:30.438+13:00] [odi] [ERROR] [ODI-14096] [oracle.odi.setup] [tid: 50] [ecid: 75dd0c85-d06a-464e-a266-cb3e2e264347-00000002,0] Error While Upgrading Master Repository java.lang.NullPointerException
[2018-02-01T13:20:30.438+13:00] [odi] [NOTIFICATION] [] [oracle.odi.setup] [tid: 50] [ecid: 75dd0c85-d06a-464e-a266-cb3e2e264347-00000002,0] ==== ODI Upgrade: END - Upgrade Master Repository
[2018-02-01T13:20:30.463+13:00] [ODI] [NOTIFICATION] [] [upgrade.ODI.ODI1] [tid: 50] [ecid: 75dd0c85-d06a-464e-a266-cb3e2e264347-00000002,0]
[2018-02-01T13:20:30.463+13:00] [ODI] [NOTIFICATION] [] [upgrade.ODI.ODI1] [tid: 50] [ecid: 75dd0c85-d06a-464e-a266-cb3e2e264347-00000002,0] [[
oracle.ias.update.plugin.odi.exception.UpgradeFailedException
  at oracle.ias.update.plugin.odi.ODIPlugin.upgrade(ODIPlugin.java:470)
  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:726)
  at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:369)
  at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1058)
  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)

Changes

 

Cause

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 hundreds of Community platforms