SAP Knowledge Base Article - Preview

1344291 - Error: "You have an error in your SQL syntax" when refreshing various Web Intelligence auditing reports reporting off MySQL in Business Objects XI Release 2

Symptom

- Cannot view/refresh Web Intelligence auditing reports.

-  Error messages when trying to access Web Intelligence auditing reports such as:

"[MySQL][ODBC 3.51 Driver][mysqld-4.1.13a-pro]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ..." or "Invalid datatype ..." and then various parts of the SQL syntax.


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2

Keywords

syntax error, auditing reports, invalid data type, sql expression wrong , KBA , BI , Business intelligence solutions , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.