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

Article Id: 87515

Status: Published

Updated On: 15-04-2018 08:04

Legacy Id: 000013699

Products:

CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION

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# = ""

Cause:

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

Environment:

OS Version: N/A

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