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

book

Article ID: 84389

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

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>

0EMb0000001FdBX.png

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

<Please see attached file for image>

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:

<Please see attached file for image>

0EMb0000001FdBh.png

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

Attachments

1558704307877000084389_sktwi1f5rjvs16ljh.png get_app
1558704306148000084389_sktwi1f5rjvs16ljg.png get_app
1558704304066000084389_sktwi1f5rjvs16ljf.png get_app