SEC_SQL Variable with bind parameters error U02012033

book

Article ID: 87139

calendar_today

Updated On:

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.