'ODI-1274: Agent Exception Caused by: null' Message Is Received When ODI J2EE Agent Is Starting Any Session

Last updated on NOVEMBER 28, 2017

Applies to:

Symptoms

An Oracle Data Integrator (ODI) J2EE Agent promptly responds when tested from the ODI Topology Manager but is unable to execute any jobs.

The corresponding Session does not even start, and following message is received when executing any Session (Scenario, WebService, Package, etc) on the above Agent:

ODI-20028: Cannot start execution

oracle.odi.runtime.agent.invocation.InvocationException: ODI-1274: Agent Exception Caused by: null
   at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:260)
   at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartSession(InternalRemoteRuntimeAgentInvoker.java:171)
   at com.sunopsis.graphical.dialog.SnpsDialogExecution.runStartSession(SnpsDialogExecution.java:1967)
   at com.sunopsis.graphical.dialog.SnpsDialogExecution.doPackageExecuter(SnpsDialogExecution.java:897)

[...]

On WebLogic Server (WLS) side, the J2EE Agent trace indicates one of the following alternative messages:

[2012-02-01T06:06:23.093-06:00] [odi_server1] [ERROR] [ODI-1131] [] [tid: 13] [userId: anonymous] [ecid: 004hyNcWQ_E1rYRquWq2UH0002BA000Rvu,0:1] [APP: oraclediagent] [URI: /oraclediagent/invoke.do] Agent MyOdiAgent encountered an error: ODI-1274: Agent Exception Caused by: null

[2012-02-01T06:06:23.093-06:00] [odi_server1] [ERROR] [] [oracle.odi.agent] [tid: 13] [userId: anonymous] [ecid: 004hyNcWQ_E1rYRquWq2UH0002BA000Rvu,0:1] [APP: oraclediagent] [URI: /oraclediagent/invoke.do] java.lang.NullPointerException[[
   at oracle.odi.runtime.agent.coherence.OdiAgentInstanceList.getAgentInstances(OdiAgentInstanceList.java:43)
   at oracle.odi.runtime.agent.mbeans.SessionInformationBean.getAgentInstances(SessionInformationBean.java:711)
   at oracle.odi.runtime.agent.processor.impl.GetJMXServiceInfoRequestProcessor.doProcessRequest(GetJMXServiceInfoRequestProcessor.java:35)
   at oracle.odi.runtime.agent.processor.SimpleAgentRequestProcessor.process(SimpleAgentRequestProcessor.java:49)
   at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
   at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:445)
   at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:394)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

[...]

  or:

[2012-05-02T19:50:56.928-05:00] [odi_server1] [ERROR] [ODI-1131] [] [tid: 29] [userId: anonymous] [ecid: 004jlSmMpaH4UsVRy2i8T00000Wt0006uy,0:1] [APP: oraclediagent] [URI: /oraclediagent/invoke.do] AgentMyOdiAgentencountered an error: ODI-1220: Session preparation failure: an unexpected exception occurred.[[
Caused By: java.lang.NullPointerException
   at oracle.odi.runtime.agent.coherence.OdiDisconnectedRepositoryList.isRepositoryDown(OdiDisconnectedRepositoryList.java:78)
   at oracle.odi.runtime.agent.mbeans.SessionInformationBean.isWorkRepositoryDown(SessionInformationBean.java:568)
   at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$1.doAction(StartScenRequestProcessor.java:297)
   at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:214)
   at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.goPrepareOrDelegatePrepare(StartScenRequestProcessor.java:287)
   at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doPrepareAgentTask(StartScenRequestProcessor.java:216)
   at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:81)
   at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
   at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:445)
   at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:394)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

[...]

Cause