Hi ,
I am trying to call a odi scenario from a package and i need to pass the variables dynamically. the code is
OdiStartScen "-SCEN_NAME=#v_ScenName" "-SCEN_VERSION=#v_ScenVersion" "-SYNC_MODE=1" #v_AddlVariables
#v_AddlVariables is holding values for multiple variables.
the code is throwing an error :
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)
i have tried to call the same command by replacing the variable (#v_AddlVariables) with its values and the code starts working.
the following starts to work when i am giving the variable values:
OdiStartScen "-SCEN_NAME=#v_ScenName" "-SCEN_VERSION=#v_ScenVersion" "-SYNC_MODE=1" "-<PROJ_CODE>.v_InterchangeId=750" "-<PROJ_CODE>.v_FileName=BTRAIL1TRX01Aug201531Aug2015.csv" "-<PROJ_CODE>.v_FilePath=/nfs/paldata/interfaces/EMDW_LANDING/MYCOST/TRAIN_BOOKING/INCOMING"
please help me resolve this issue as a similar code is already running in ODI 10G. Cant understand why this failing in 11G
ODI Version : 11.1.1.9.0