Variables with {} are not resolved in Connection field of SQL-vara

Document ID : KB000084389
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
U00052002 Object '{VARA.ENV_INFO.SETTINGS,DB_CONNECTION,1}' with type 'CONN' does not exist in client '08000'.

In an SQL VARA, in field Connection, variables with curly brackets {} are not resolved.  When the Preview button is clicked, an error is displayed:

0EMb0000001FdBX.png

The STATIC VARA named VARA.ENV_INFO.SETTINGS contains one row:

0EMb0000001FdBc.png

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:

0EMb0000001FdBh.png

Cause:
Cause type:
Defect
Root Cause: N/A
Resolution:
Update to a fix version listed below or a newer version if available.

Fix Status: In Progress

Fix Version(s):
Component(s): AE Server and Initialdata
Automation Engine 12.2.0 - Planned release date: 2018-06-19
Automation Engine 12.1.1 - Available
Additional Information:
Workaround :
N/A