ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 87515

calendar_today

Updated On:

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

 

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
Powered by Wolken Software