ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
SEC_SQL Variable with bind parameters error U02012033
Article ID: 87139
Updated On:
Products
CA Automic Workload Automation - Automation Engine
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:
Without space before "from" it will produce an error:
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 = ?
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 = ?
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.
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:
Component:
Resolution
N/A
Fix Status: No Fix
Fix Status: No Fix
Additional Information
Workaround :
Add a space before the "from" keyword.
Add a space before the "from" keyword.
Feedback
Yes
No
Powered by
