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 DECEMBER 04, 2023
Applies to:
Oracle Exalytics Software - Version 1.0.0.2.0 and laterBusiness 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'.."
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |