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


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"



SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI


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.