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

Document ID : KB000087515
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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