ODI 12.2.1 Child Sessions Intermittently Fail With "HTTP/1.1 413 Request Entity Too Large" Error Message (Doc ID 2192988.1)

Last updated on DECEMBER 22, 2016

Applies to:

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

Symptoms

Having an Oracle Data Integrator (ODI) 12.2.1 Scenario MYSCEN that recursively calls itself in an infinite loop, using the OdiStartScen command:

OdiStartScen "-SCEN_NAME=MYSCEN" "-SCEN_VERSION=001" "-LOG_LEVEL=5" "-SYNC_MODE=2"

The child Session intermittently fails, and following message is received in the ODI Agent log file:

[2016-09-21T10:01:22.646+02:00] [odi] [WARNING] [] [oracle.odi.agent] [tid: 10614] [ecid: 0000LTBkrBMCWrA5VbK6yc1Nr5Pt0000w0,0] <jetty> Header is too large >8192

[2016-09-21T10:01:22.647+02:00] [odi] [WARNING] [] [oracle.odi.agent] [tid: 10614] [ecid: 0000LTBkrBMCWrA5VbK6yc1Nr5Pt0000w0,0] <jetty> badMessage: 413 for HttpChannelOverHttp@6be839e4{r=0,a=IDLE,uri=-}

[2016-09-21T10:01:22.675+02:00] [odi] [ERROR] [ODI-1217] [oracle.odi.agent] [tid: 2684] ...
[oracle.odi.runtime.MrepExtId: 1473787798341] [oracle.odi.runtime.AgentName: OracleDIAgent1] [oracle.odi.runtime.ExecPhase: ExecuteTask] [oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.WrepName: WORKREP] [oracle.odi.runtime.ScenarioName: MYSCEN] [oracle.odi.runtime.ScenarioVer: 001] [oracle.odi.runtime.EntityGuid: 65a44178-7a4b-4f09-96ea-ef49457d36d5] [oracle.odi.runtime.ParentSess: 11008] [oracle.odi.runtime.SessName: MYSCEN] [oracle.odi.runtime.SessId: 11010] [oracle.odi.runtime.SessStep: 11/OdiStartScen 2/1] [oracle.odi.runtime.SessTask: 11.9/Oracle Data Integrator Command,Oracle Data Integrator Command,null] [oracle.odi.runtime.ExecHierarchy: 5981/.../11008/11010] Session MYSCEN(11010) fails with return code 7000.[[

ODI-1217: Session MYSCEN(11010) fails with return code 7000.
ODI-1226: Step OdiStartScen 2 fails after YYY attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: oracle.odi.runtime.agent.invocation.InvocationException: HTTP/1.1 413 Request Entity Too Large
  at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:405)
  at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)
  at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:274)
  at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:222)
  at com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:366)
  at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:231)
  at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:902)
  at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:583)
  at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)
  at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:18)
  at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
  at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)
  at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)
  at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
  at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2231)
  at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:612)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:719)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:801)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(StartScenRequestProcessor.java:85)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:917)
  at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:522)
  at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
  at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
  at java.util.concurrent.FutureTask.run(FutureTask.java:277)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
  at java.lang.Thread.run(Thread.java:785)

]]

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