The Upgrade Of ODI Repositories Fails With "Java.lang.NullPointerException" and "inactive connection timeout timer scheduled" (Doc ID 2210775.1)

Last updated on DECEMBER 13, 2016

Applies to:

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

Symptoms

The upgrade of Oracle Data Integrator (ODI) 11g or 12c Repositories fails, and following messages are shown in the Upgrade Assistant (UA) log file:

[2016-12-02T18:39:11.134+00:00] [odi] [NOTIFICATION] [] [oracle.odi.setup] [tid: 12] [ecid: ...] ==== ODI Upgrade: BEGIN - Upgrade Master Repository
[2016-12-02T18:39:11.134+00:00] [ODI] [NOTIFICATION] [] [upgrade.ODI.ODI1] [tid: 12] [ecid: ...] Upgrading ODI Master Repository.
[2016-12-02T18:39:11.164+00:00] [springframework] [NOTIFICATION] [] [org.springframework.jdbc.datasource.DriverManagerDataSource] [tid: 12] [ecid: ...] Loaded JDBC driver: oracle.jdbc.OracleDriver
[2016-12-02T18:39:11.164+00:00] [springframework] [NOTIFICATION] [] [org.springframework.jdbc.datasource.DriverManagerDataSource] [tid: 12] [ecid: ...] Loaded JDBC driver: oracle.jdbc.OracleDriver
[2016-12-02T18:39:11.167+00:00] [odi] [NOTIFICATION:16] [ODI-14092] [oracle.odi.setup] [tid: 12] [ecid: ...] Loading Master Repository Info
[2016-12-02T18:39:11.300+00:00] [] [NOTIFICATION] [] [] [tid: 12] [ecid: ...] New data source: [DEV1213_ODI_REPO_BCDM_1732/*******@jdbc:oracle:thin:@172.1.2.3:1521:orcl]
[2016-12-02T18:39:11.487+00:00] [ucp] [NOTIFICATION] [] [oracle.ucp.common.UniversalConnectionPoolBase] [tid: 13] [ecid: ...] inactive connection timeout timer scheduled
[2016-12-02T18:39:12.007+00:00] [] [NOTIFICATION] [] [] [tid: 12] [ecid: ...] New data source: [DEV1213_ODI_REPO_BCDM_1732/*******@jdbc:oracle:thin:@172.1.2.3:1521:orcl]
[2016-12-02T18:39:12.105+00:00] [ucp] [NOTIFICATION] [] [oracle.ucp.common.UniversalConnectionPoolBase] [tid: 13] [ecid: ...] inactive connection timeout timer scheduled
[2016-12-02T18:39:12.581+00:00] [] [NOTIFICATION] [] [] [tid: 12] [ecid: ...] New data source: [DEV1213_ODI_REPO_BCDM_1732/*******@jdbc:oracle:thin:@myhostname:1521:orcl]
[2016-12-02T18:39:12.589+00:00] [ucp] [NOTIFICATION] [] [oracle.ucp.common.UniversalConnectionPoolBase] [tid: 13] [ecid: ...] inactive connection timeout timer scheduled
[2016-12-02T18:39:12.649+00:00] [ODI] [INCIDENT_ERROR] [ODIUPG-00008] [upgrade.ODI.ODI1] [tid: 12] [ecid: ...] Unknown error happened.
[2016-12-02T18:39:12.649+00:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [tid: 12] [ecid: ...] Cause: Unknown error happened.
[2016-12-02T18:39:12.650+00:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [tid: 12] [ecid: ...] Action: Restore Master Repository from Backup and try to upgrade again.
[2016-12-02T18:39:12.650+00:00] [ODI] [INCIDENT_ERROR] [] [upgrade.ODI.ODI1] [tid: 12] [ecid: ...] [[
java.lang.NullPointerException
  at oracle.odi.setup.RepositoryUpgradeServiceImpl.validateWorkRepositories
(RepositoryUpgradeServiceImpl.java:310)
  at oracle.odi.setup.RepositoryUpgradeServiceImpl.validateRepositories(RepositoryUpgradeServiceImpl.java:223)
  at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:387)
  at oracle.ias.update.plugin.odi.ODIPlugin.upgrade(ODIPlugin.java:429)
  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)

]]

 

 

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