Error Message :
U02012033 Query could not be executed: 'com.microsoft.sqlserver.jdbc.SQLServerException: The multi-part identifier 'a.AH_Client' could not be bound. (Client: '0022', PREVIEW, Variable: 'INC00214003.SEC_SQL.WITH_PARA.VARA')'
Using an alias in SEC_SQL Variable objects causes the above error.
The SQL statement causes the error when the preview button is clicked:
Root Cause: Since the SEC_SQL statements are being processed through Microsoft's JDBC driver you may see this type of issue with older JDBC versions.
Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Update your system to use the latest Microsoft (MS) SQL JDBC driver.
For additional information about Microsoft products, including the SQL JDBC drivers, contact Microsoft.
Fix Status: No Fix
Do not use an alias in SQL statement.