com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30059: The number of child sessions in error state is greater or equal to the MAX_CHILD_ERROR parameter

Oracle Community | ma*447418*55 | 5 months ago
  1. 0

    How to Capture ODI Error message in ODI Email component

    Oracle Community | 5 months ago | ma*447418*55
    com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30059: The number of child sessions in error state is greater or equal to the MAX_CHILD_ERROR parameter
  2. 0

    ODI-30059 The number of child sessions in error state is greater or equal to the MAX_CHILD_ERROR parameter

    Oracle Community | 4 months ago | 2752590
    com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30059: The number of child sessions in error state is greater or equal to the MAX_CHILD_ERROR parameter
  3. 0

    db:: 4.47::ODI -1228 - Error while writing data into Integration Tool zs

    hivmr.com | 11 months ago
    com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30005: One or more child sessions has failed
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ODIWaitForCHildSession Error

    Oracle Community | 8 years ago | cleme1a
    com.sunopsis.dwg.function.SnpsFunctionBaseException: One or more child sessions has failed
  6. 0

    db:: 5.31::ODI-1228: Task emp(Integration) fails on the target ORACLE connection Target zj

    hivmr.com | 8 months ago
    com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30005: One or more child sessions has failed

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.sunopsis.dwg.function.SnpsFunctionBaseException

      ODI-30059: The number of child sessions in error state is greater or equal to the MAX_CHILD_ERROR parameter

      at com.sunopsis.dwg.tools.WaitForChildSession.actionExecute()
    2. com.sunopsis.dwg
      SnpsFunctionBaseRepositoryConnected.execute
      1. com.sunopsis.dwg.tools.WaitForChildSession.actionExecute(WaitForChildSession.java:251)
      2. com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:219)
      2 frames
    3. oracle.odi.runtime
      TaskExecutorAgentRequestProcessor$1.doAction
      1. oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:901)
      2. oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:582)
      3. oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)
      4. oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:18)
      5. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
      6. oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)
      7. oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)
      8. oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
      9. oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2227)
      10. oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:607)
      11. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
      12. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
      12 frames
    4. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
      1 frame
    5. oracle.odi.runtime
      DefaultAgentTaskExecutor$1.run
      1. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
      2. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(StartScenRequestProcessor.java:85)
      3. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:917)
      4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
      5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:66)
      5 frames
    6. Spring Core
      SyncTaskExecutor.execute
      1. org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:48)
      1 frame
    7. oracle.odi.runtime
      InternalRemoteRuntimeAgentInvoker.invokeStartScenario
      1. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:76)
      2. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:146)
      3. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:137)
      4. oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)
      5. oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:44)
      6. oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:274)
      7. oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:222)
      7 frames
    8. com.sunopsis.dwg
      SnpsFunctionBaseRepositoryConnected.execute
      1. com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:337)
      2. com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:219)
      2 frames
    9. oracle.odi.runtime
      TaskExecutorAgentRequestProcessor$1.doAction
      1. oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:901)
      2. oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:582)
      3. oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)
      4. oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:18)
      5. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
      6. oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)
      7. oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)
      8. oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
      9. oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2227)
      10. oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:607)
      11. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
      12. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
      12 frames
    10. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
      1 frame
    11. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
      2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
      3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
      4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
      5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
      5 frames
    12. Java RT
      Executors$RunnableAdapter.call
      1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      1 frame
    13. oracle.odi.runtime
      OdiJob.call
      1. oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
      2. oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
      2 frames
    14. Java RT
      Thread.run
      1. java.util.concurrent.FutureTask.run(FutureTask.java:266)
      2. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      3. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      4. java.lang.Thread.run(Thread.java:745)
      4 frames