Error Message :
Error: U02012033 Query could not be executed:
'com.microsoft.sqlserver.jdbc.SQLServerException: Unable to identify the table
select oh_client, oh_name from oh where oh_client = ? for the metadata.
When defining a SQL Secure (SEC_SQL) variable using bind parameters, there is an issue in the concatenation of the SQL Statement lines. There should be a space before the line containing the "FROM" keyword.
This statement will work:
Root Cause: Bug with MSSQL JDBC driver, which deals with newline characters in the prepare statement method on the connection which is called when using bind parameters.
The JDBC driver can't handle a missing blank in front of the FROM keyword.
Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Fix Status: No Fix
Add a space before the "from" keyword.