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 ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.