1 person found this helpful
Which version of ODI are you using?
Could you execute it with log level 6 (if you are using 188.8.131.52+) and check if the variable appears for the failing step in the operator?
Could you also check that the name of your variable has the correct case?
Odi version : 184.108.40.206
i tried at log 6 but same issue is coming .
this is my refresh query
select file_name from (select file_name, rownum rn from file_loop_variable) where rn=#Test_Project.count
when i change value of #Test_Project.count with 1 or 3 or any number it is executing .
select file_name from (select file_name, rownum rn from file_loop_variable) where rn=1
Check in the variable history what value it is getting. Double click on your variable and from the definition change the Keep History to All Values if it is set to No History for at least testing purposes.
Besides the variable name as JeromeFr said, make sure that the project code (not the project name) be prefixed by your variable name:
It should have this format:
To find out the project code double click on the project and on the Definition tab copy the Code (not the Name).
The log level 6 should show you the value of the variables in the logs.
In the operator, open the task which fails and expand the Variable and Sequence Values section by clicking the plus sign as highlighted in the picture below.
Check if #Test_Project.count has been assigned a value.
 Better when I put the picture...
I have placed project_name instead of PROJECT_CODE.
thank both for helping .
and don't forget to enjoy BEAUTIFUL LIFE :-)