U00054533 Error using The :RESOLVE function
Article ID: 262942
Updated On:
Products
Issue/Introduction
The :RESOLVE function does not work in v21.x when it is used with SQL Variable. The job will fail with the error message below.
U00054533 Error inside construct/variable '<Name_Of_SQL_Variable>,AH,2': invalid column ' 2'
For Example:
The command below is supposed to filter on the column 2 of the variable VARA.SQL.TABLE_NAMES.
:RESOLVE &NUM_ROWS# = "{VARA.SQL.TABLE_NAMES,JOBS.WIN,2}"
However, it Results into an error below:
U00054533 Error inside construct/variable 'VARA.SQL.TABLE_NAMES,JOBS.WIN,2': invalid column ' 2'
Environment
Release : 21.0.x
CA Automic Workload Automation
Cause
Product defect
Resolution
Fix:
The issue is fixed from AE v21.0.5 HF2.
Workaround: The workaround is to use the function GET_VAR as shown below.
:SET &NUM_ROWS# = GET_VAR(VARA.SQL.TABLE_NAMES,JOBS.WIN,2)
Feedback
