SYMPTOM:
When running a report in Strategy 9.x, the SQL errors with the following message:
Error: SQL Generation Complete
QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Syntax error: expected something between ',' and the end of the request.
Error in Process method of Component: QueryEngineServer, Project Strategy Tutorial, Job 189, Error Code= -2147212544.
Running the report SQL in DB Query Tool does not result in an error.
STEPS TO REPRODUCE:
In this situation, the user desires to include the report name in the report SQL and is accomplishing this through the use of the VLDB setting SQL Hint and SQL Wildcard !o with the following syntax:
/* !o */
Refer to the following Strategy Knowledge Base technical note for additional information on SQL Wildcards:
KB10940: What SQL generation wildcards are implemented in Strategy Engine 9.x?
With only the Region attribute on the grid, and the report named "My ' Report" the Report SQL is as follows:
select /* My ' Report */ a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME
from LU_REGION a11
Note that a single apostrophe appears within the SQL comments and therefore should be ignored.
When running the report, it errors out:
Error: SQL Generation Complete
QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Syntax error: expected something between ',' and the end of the request.
Error in Process method of Component: QueryEngineServer, Project Strategy Tutorial, Job 189, Error Code= -2147212544.
CAUSE:
The error, SQL-3706 is a generic error message relating to the syntax of the SQL. In this example, the issue is caused by having an odd number of apostrophes in the report SQL and is specific to Teradata.
ACTION:
This issue may be resolved by modifying the following Teradata driver setting 'Disable Parsing':
