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

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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:

<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>

Cause

Cause type:
Defect
Root Cause: N/A

Environment

Release: AUTWAB99000-12.0-Automic Workload Automation-Base Edition
Component:

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