After upgrade from v11 to v12, executing SEC_SQLI variable results in error ‘No value found for variable '<SEC-SQLI-VARI>' with validity '3'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
No value found for variable '%' with validity '3'.

When executing a SEC_SQLI variable after upgrading from version 11 to 12, the following error may be experienced:

​U00020331 Runtime error in object '%', line '00097': U00003708 No value found for variable '%' with validity '3'. 

Investigation

Here's the section of code (NOTE: Line 97 in the Process tab of the Job object): 

: SET &KEY# = GET_VAR(&RESULTJOBVARS#,&JOBCNTR#,1) 
: IF &KEY# = "" 

 

Environment

OS Version: N/A

Cause

Cause type:
Configuration
Root Cause: Incorrect configuration in SQLI Variable may lead to this error.

Resolution

Update to a fix version listed below or a newer version if available.​

 

Fix Status: Released

Fix Version(s):
Automation Engine 12.1.0 - Available
Automation Engine 12.0.3 - Available

Additional Information

Workaround :
Change the option in the SQLI VARA object.  This can be modified by navigating as follows within the object:
 

Attributes > Key Not Found > Initial Values instead of Error