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
Updated On:
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# = ""
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.
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
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:
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
Feedback
Powered by
