I defined a scenario in such a way that variables in this scenario will pull data from some configuration table and pass these values as parameters to another scenario present in first parent scenario. I have tested this in DEV and DEV testing environments which are shared with same topology with different work repositories. It worked fine. But when i moved the code to QA environment, then i am getting the following error message. while attemption to execute the scenario with following command,
Code Executed:
OdiStartScen "-SCEN_NAME=XXXXX" "-SCEN_VERSION=-1" "-LOG_LEVEL=5" "-PROJECT_NAME.PASS=#PROJECT_NAME.V_PASS" "-PROJECT_NAME.DB_URL=#PROJECT_NAME.V_DB_URL" "-PROJECT_NAME.DB_SCHEMA=#PROJECT_NAME.V_DB_SCHEMA" "-PROJECT_NAME.DB_LINK=#PROJECT_NAME.V_DB_LINK" "-PROJECT_NAME.DB_USER=#PROJECT_NAME.V_DB_USER"
Error Message:
oracle.odi.oditools.OdiToolInvalidParameterException: Error while setting parameters on tool
at com.sunopsis.dwg.function.SnpsFunctionBase.getCoreOdiTool(SnpsFunctionBase.java:618)
at com.sunopsis.dwg.function.SnpsFunctionBase.getSunopsisApi(SnpsFunctionBase.java:494)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1431)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: Unmatching quotes .... !
at com.sunopsis.core.SnpsObject.extractParametersLine(SnpsObject.java:174)
at com.sunopsis.dwg.function.SnpsFunctionBase.getCoreOdiTool(SnpsFunctionBase.java:580)
... 18 more