SQL Variable with Parameter values not resolved

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
N/A

SQL variable in not being resolved.

If a VARA.SQL has a variable, the variable does not get resolved during runtime. 

Investigation

Example:
 

SELECT NVL(MAX(FAILURE_EMAIL),'NO_EMAIL') EMAIL FROM ( 
SELECT FAILURE_EMAIL 
FROM PRXL_INF.ETL_SCHEDULE_NOTIFICATION 
WHERE UPPER (ETL_FOLDER_NAME) = UPPER ('&FOLDER_NAME#') 
AND UPPER (ETL_WORKFLOW_NAME) = UPPER ('&WORKFLOW_NAME#')) 

Result:

All variables in the example will not be resolved as shown below:

SELECT NVL(MAX(FAILURE_EMAIL),'NO_EMAIL') EMAIL FROM ( 
SELECT FAILURE_EMAIL 
FROM PRXL_INF.ETL_SCHEDULE_NOTIFICATION 
WHERE UPPER (ETL_FOLDER_NAME) = UPPER ('') 
AND UPPER (ETL_WORKFLOW_NAME) = UPPER ('')) 

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Cause

Cause type:
Defect
Root Cause: N/A

Resolution

This is a defect on version 9 and has been fixed in version 10.

Fix Status: Released

Fix Version(s):
Automation Engine 10.0.0 - Available

Additional Information

Workaround :
N/A