Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Odi Load Plan - Refresh Variable reused even if the step was in error

I have a refresh variable used in a case step. The case check the variable in the When step and in the else raise an error.

My expected behaviour was that if I fix the calculated value on the DB when I restart the loadplan it will go on instead it reuse the first value calculated since the step is in error but not the status of the refreshed variable.

pastedImage_2.png

I know that in most cases is right that after a restart is better reuse the previous calculated values ( example a sequence number, a jobid etc... ) but in some cases I need to execute again the refresh variable sql.

My idea is that the refresh variables must be re executed:

- when the step serial/parallel is in error without check the inner status of the single refresh varialble

- when the single refresh variable is in error.

What do you think about?

Thanks in advance

Angelo

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2018
Added on Jul 27 2018
0 comments
79 views