GET_VAR doesn't find value from SEC_SQLI variable using result format {2}

book

Article ID: 125367

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

On a SEC_SQLI variable, when you define the result format as column 2({2}), 
in a script object, the GET_VAR script function will not find any of the results from your SQL statement. 

Environment

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

Resolution

This issue has been corrected and is currently planned for release in the following versions: 
Automation Engine 12.1.4 - available. 
Automation Engine 12.2.2 - planned for the end of February 2019. 
Automation Engine 12.3.0 - planned for the end of June 2019.

Please download and install one of the above mentioned or higher versions to obtain the correction.