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 | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

    Oracle Community | 8 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 | 4 years ago | Papai
    com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30038: OS command returned 2.
  3. 0

    Open Discussion - DW TeamDW Team

    dwteam.in | 9 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 | 1 year ago | HimanshuP
    com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30038: OS command returned 7.
  6. 0

    Loading data from MS Sql to Oracle.

    Oracle Community | 6 years ago | 881812
    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