"oracle.odi.core.exception.OdiRuntimeException: Unable to create TaskScheduleDefinitionList" Signalled While Starting the ODI 12c Agent

(Doc ID 2233152.1)

Last updated on OCTOBER 31, 2017

Applies to:

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

Symptoms

The following errors occur when starting an Oracle Data Integrator (ODI) 12c Agent:

2016-10-13 13:12:37.980:INFO:oejsh.ContextHandler:main: Started o.o.@3f12676{/oraclediagent,file:/D:/Oracle/ODI12c/user_projects/domains/odi_domain/system_components/ODI/OracleDIAgentPhys1/work/webapp/,AVAILABLE}{file:/D:/Oracle/ODI12c/odi/agent/lib/./oraclediagent.war}
2016-10-13 13:12:38.418:INFO:oejs.ServerConnector:main: Started ServerConnector@6434d49e{HTTP/1.1}{agent_server_name:20910}
2016-10-13 13:12:38.418:INFO:oejs.Server:main: Started @8801ms
2016-10-13 13:12:38.433 NOTIFICATION Successfully set the current thread authentication
2016-10-13 13:12:38.590 NOTIFICATION Successfully set the current thread authentication
2016-10-13 13:12:38.715 NOTIFICATION Successfully set the current thread authentication
Exception in thread "AgentScheduler-WORKREP" oracle.odi.core.exception.OdiRuntimeException: Unable to create TaskScheduleDefinitionList
  at oracle.odi.runtime.agent.scheduler.OdiAgentScheduler.createTaskScheduleDefinitionList(OdiAgentScheduler.java:296)
  at com.sunopsis.timer.SnpsAbstractScheduler.run(SnpsAbstractScheduler.java:126)
  at oracle.odi.runtime.agent.scheduler.OdiAgentScheduler.run(OdiAgentScheduler.java:146)
  at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
  at oracle.odi.runtime.agent.scheduler.OdiAgentScheduler.createFailOverRecurrenceScheduleDefList(OdiAgentScheduler.java:416)
  at oracle.odi.runtime.agent.scheduler.OdiAgentScheduler.createTaskScheduleDefinitionList(OdiAgentScheduler.java:283)
  ... 3 more
2016-10-13 13:19:03.606 NOTIFICATION Successfully set the current thread authentication
2016-10-13 13:19:03.684 NOTIFICATION Successfully set the current thread authentication

or

ERROR ODI-1131 Agent EXA_Agent encountered an error: ODI-1503: Load Plan logs dor instance 89303041, run 1 are corrupted: Could not session '947870041' (for step '84041')

As a result, schedules are not executed.

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