My Oracle Support Banner

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 MARCH 13, 2018

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:

 

 

Additionally, when trying to update rowcount in the OBIEE Admin tool, an error dialog ("Oracle BI AdministrationTool has stopped working...") is raised and the tool shuts down as shown below.

 



Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.