In an SQL VARA, in field Connection, variables with curly brackets {} are not resolved. When the Preview button is clicked, an error is displayed:
<Please see attached file for image>
The STATIC VARA named VARA.ENV_INFO.SETTINGS contains one row:
<Please see attached file for image>
For example, as can be seen from the error message above, the {} variable is not resolved, but the whole expression from { to } is taken as name and searched in the DB as connection object.
In older versions of Automation Engine, the {} variable is resolved correctly and it works, see:
<Please see attached file for image>