SEC_SQL Variable with bind parameters error U02012033

Article Id: 87139

Status: Published

Updated On: 15-04-2018 08:07

Legacy Id: 000009149

Products:

CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction:

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:

select oh_client,
oh_name
from oh
where oh_client = ?

Without space before "from" it will produce an error:

select oh_client,
oh_name
from oh
where oh_client = ?

Cause:

Cause type:
Other
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.

Environment:

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Resolution:

N/A

Fix Status: No Fix

Additional Information:

Workaround :
Add a space before the "from" keyword.