SAP Knowledge Base Article - Preview

1182023 - Error: "You have an error in your SQL syntax" refreshing metrics when using MySQL 5.0 as the data source

Symptom

In Performance Management (PM) XI Release 2, a metric is based on a universe that is connected to a MySQL 5.0 database. When refreshing the metric, the following error message appears:

"[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 'AND )' at line 1"


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI

Keywords

Metric refresh MySQL , 1084655 , KBA , BI-BIP-PM , Obsolete - Performance Manager, metrics , Bug Filed

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.