Automation, generating an error in the variable activity (4264899)

Automation, generating an error in the variable activity.

After installing the upgrade: Toad Data Point 4.0.0.624,  it generates an error setting a variable in a script that has been running just fine previously.

The error message: mismatched input '00' expecting ')' line nnn

It is occurring on a variable that references a previously defined variable. 

For example, the first variable - p_start_dt - gets set as:

Round( add_days( last_day( add_months(  current_date(), -2 ) ), 1 ) )

The next variable generates the error, and is defined as:

Last_day(#p_start_dt#)

WORKAROUND

None

STATUS

Issue fixed in version 4.0..1. 

The latest version of Toad Data Point can be downloaded at the Support Portal.

Click here for the Support Portal.