'ODI-1274: Agent Exception Caused by: null' Message Is Received when ODI J2EE Agent Is Starting Any Session (Doc ID 1409823.1)

Last updated on MAY 29, 2020

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: <TID>] [userId: <APP_AUTH_USER>] [ecid: <ECID>] [APP: oraclediagent] [URI: /oraclediagent/invoke.do] Agent <AGENTNAME> 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: <TID>] [userId: <APP_AUTH_USER>] [ecid: <ECID>] [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: <TID>] [userId: <APP_AUTH_USER>] [ecid: <ECID>] [APP: oraclediagent] [URI: /oraclediagent/invoke.do]  <AGENTNAME> encountered 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.