SQL Variable with Parameter values not resolved

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