SAP Knowledge Base Article - Preview

1201206 - SQL Server error: "42000" when refreshing metrics in Enterprise Performance Management


When attempting to refresh a metric in Enterprise Performance Management, the following SQL Server error message appears:


Also, the following message appears in the log:

"szSqlState = "42000", *pfNativeError = 170, *pcbErrorMsg = 81 MessageText = "[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '?'."



SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI


MDAC 42000 SQL Server 2000 ODBC stored procedure Performance Management , 5404774 , KBA , BI-BIP-PM , Obsolete - Performance Manager, metrics , 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.