Hi,
I have a variable which is getting its value from its refresh tab using one of my data store. That variable is then used as a default value in my ODI procedure option and in ODI procedure and I am retrieving the value of variable using getOption in my procedure task.
I have found an issue that when I change the value in my data store (which is XML) and run my code, variable value is refreshed correctly with new value and I can see that value in the history tab of the variable. However in my ODI procedure it still picks up the old value. But when I run the same code again without making any change in the data store, it then picks up the latest updated value.
In short, I have to run the code twice to get the new updated value of the data store. Why is it behaving like this?