You are monitoring SAP systems based on SQL Server 2005 < service pack 2 with a Solution Manager system and see the following error messages in system log (transaction SM21) of the Solution Manager system:
SM_EFWK BY 2 Database error 50000 at OPC
SM_EFWK BY 0 > Could not find stored procedure
SM_EFWK BY 0 > 'SAPMonitor.sap_get_freespace'.
SM_EFWK BY 1 Database error 50000
The developer traces reveal that the error occurs while being connected to the database of one of the monitored systems and contains:
C Fri Jun 07 14:22:40 2013
C ERROR: -1 in function StartSelect (execute)
C (50000)  [Microsoft][SQL Server Native Client 10.0]
[SQL Server]Could not find stored procedure 'SAPMonitor.sap_get_freespace
C dbdsmss: DBSL99 SQL50000
C Could not find stored procedure 'SAPMonitor.sap_get_freespace'.
B ***LOG BY2=> sql error 50000 performing OPC
B ***LOG BY0=> Could not find stored procedure 'SAPMonitor.sap_get_freespace'.
B ***LOG BY1=> sql error 50000
An attempt to create stored procedure sap_get_freespace in the remote database fails with:
SQL error 195: 'OBJECT_SCHEMA_NAME' is not a recognized built-in function
SAP Solution Manager
Monitored system is running on a SQL Server 2005 database with a service pack level < SP2
KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , How To
About this pageThis 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.