My Oracle Support Banner

ODI 12c Upgrade Assistant Fails with "Unknown error happened" and "NullPointerException" when Manually Created Datatype or Technology in 11g Collides with Out-of-Box Object (Doc ID 2360870.1)

Last updated on APRIL 07, 2020

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 technology and/or datatype is provided as standard in Oracle Data Integrator (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: <TID>] [ecid: <ECID>] Error While Upgrading Master Repository null
[2018-02-01T13:20:30.435+13:00] [ODI] [INCIDENT_ERROR] [ODIUPG-00008] [upgrade.ODI.ODI1] [tid: <TID>] [ecid: <ECID>] Unknown error happened.
[2018-02-01T13:20:30.435+13:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [tid: <TID>] [ecid: <ECID>] Cause: Unknown error happened.
[2018-02-01T13:20:30.436+13:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [tid: <TID>] [ecid: <ECID>] 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: <TID>] [ecid: <ECID>] [[
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: <TID>] [ecid: <ECID>] Error While Upgrading Master Repository java.lang.NullPointerException
[2018-02-01T13:20:30.438+13:00] [odi] [NOTIFICATION] [] [oracle.odi.setup] [tid: <TID>] [ecid: <ECID>] ==== ODI Upgrade: END - Upgrade Master Repository
[2018-02-01T13:20:30.463+13:00] [ODI] [NOTIFICATION] [] [upgrade.ODI.ODI1] [tid: <TID>] [ecid: <ECID>]
[2018-02-01T13:20:30.463+13:00] [ODI] [NOTIFICATION] [] [upgrade.ODI.ODI1] [tid: <TID>] [ecid: <ECID>] [[
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)

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.