oracle.odi.oditools.OdiToolInvalidParameterException: Error while setting parameters on tool

Oracle Community | 1056330 | 2 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    ODI Scenario Failure when passing variables as Parameters in Child Scenarios

    Oracle Community | 2 years ago | 1056330
    oracle.odi.oditools.OdiToolInvalidParameterException: Error while setting parameters on tool

    Root Cause Analysis

    1. java.lang.Exception

      Unmatching quotes .... !

      at com.sunopsis.core.SnpsObject.extractParametersLine()
    2. com.sunopsis.core
      SnpsObject.extractParametersLine
      1. com.sunopsis.core.SnpsObject.extractParametersLine(SnpsObject.java:174)
      1 frame
    3. com.sunopsis.dwg
      SnpSessTaskSql.executeOdiCommand
      1. com.sunopsis.dwg.function.SnpsFunctionBase.getCoreOdiTool(SnpsFunctionBase.java:580)
      2. com.sunopsis.dwg.function.SnpsFunctionBase.getSunopsisApi(SnpsFunctionBase.java:494)
      3. com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1431)
      3 frames
    4. oracle.odi.runtime
      TaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)
      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
    5. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
      2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
      3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
      4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
      5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
      6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889)
      6 frames
    6. oracle.odi.runtime
      StartScenRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
      1 frame
    7. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    8. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
      2. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)
      3. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
      4. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
      4 frames
    9. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame