OBIEE 11g Dashboards Fail With Error: "[DataDirect][ODBC SQL Server ...Incorrect syntax near the keyword 'with'... previous statement must be terminated with a semicolon..." (Doc ID 1592399.1)

Last updated on OCTOBER 13, 2016

Applies to:

Oracle Exalytics Software - Version 1.0.0.2.0 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Business Intelligence Answers Option - Version 11.1.1.7.0 and later
Business Intelligence Interactive Dashboard - Version 11.1.1.7.0 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

When running Oracle Business Intelligence Enterprise Edition (OBIEE) 11g on Exalytics, certain dashboards are based on a SQL server 2008 data source.  These dashboards fail with errors:

"[nQSError: 16001] ODBC error state: 10320 code: 319 message: [DataDirect][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon..
[nQSError: 16001] ODBC error state: 10103 code: 102 message: [DataDirect][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'OTHER_LOC_AMT'.."


Other errors are shown as below:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms