Return
-
Title
Issue when opening TDP v3.2 automation script in v4.2.1 -
Description
Issue when opening and running Toad Data Point v3.2 automation scripts in v4.2.1 that contain "If Condition" actions:"Activity 'Execute_File_script' validation failed: Toad has detected some symbols within the SQL indicating you might be using bind variables. Please define the following variable(s):DATE_VARIABLE"
Example of script:
-
Cause
This issue is caused by some variables and "If conditions" not being handled the same way between Toad Data Point v4.2.1 and v3.2 -
Resolution
SOLUTION
For the provided example, the solution is to split the activities into two groups as per below.
Please contact Technical Support if you require further assistance.