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 | 2752590 | 4 months ago
  1. 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
  2. 0

    OdiOsCommand Failure

    Oracle Community | 3 years ago | Papai
    com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30038: OS command returned 2.
  3. 0

    Open Discussion - DW TeamDW Team

    dwteam.in | 4 months ago
    com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30038: OS command returned 127.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    OS command returned 7

    Oracle Community | 8 months ago | HimanshuP
    com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30038: OS command returned 7.
  6. 0

    com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30038: OS command returned 1. - Data Integrator

    developer-works.com | 1 year ago
    com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30038: OS command returned 1.

    7 unregistered visitors
    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
      SnpSessTaskSql.executeOdiCommand
      1. com.sunopsis.dwg.tools.WaitForChildSession.actionExecute(WaitForChildSession.java:246)
      2. com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)
      3. com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3449)
      4. com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1510)
      4 frames
    3. oracle.odi.runtime
      TaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)
      2. oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)
      3. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
      3 frames
    4. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925)
      2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637)
      3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
      4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
      5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
      6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898)
      6 frames
    5. oracle.odi.runtime
      StartScenRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583)
      1 frame
    6. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    7. oracle.odi.runtime
      DefaultAgentTaskExecutor$1.run
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:514)
      2. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1074)
      3. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)
      4. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:50)
      4 frames
    8. Spring Core
      SyncTaskExecutor.execute
      1. org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
      1 frame
    9. oracle.odi.runtime
      InternalRuntimeAgent.startScenario
      1. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:42)
      2. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:95)
      3. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:86)
      4. oracle.odi.runtime.agent.RuntimeAgent.startScenario(RuntimeAgent.java:863)
      5. oracle.odi.runtime.agent.InternalRuntimeAgent.startScenario(InternalRuntimeAgent.java:52)
      5 frames
    10. com.sunopsis.dwg
      SnpSessTaskSql.executeOdiCommand
      1. com.sunopsis.dwg.tools.StartScen.startScenOnLocalAgent(StartScen.java:1039)
      2. com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:250)
      3. com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)
      4. com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3449)
      5. com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1510)
      5 frames
    11. oracle.odi.runtime
      TaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)
      2. oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)
      3. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
      3 frames
    12. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925)
      2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637)
      3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
      4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
      5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
      6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898)
      6 frames
    13. oracle.odi.runtime
      StartScenRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583)
      1 frame
    14. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    15. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:514)
      2. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1074)
      3. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)
      4. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84)
      4 frames
    16. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame