Symptom
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 monitor (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 ERROR: -1 in function StartSelect (execute)
C (50000) [42000] [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
Read more...
Environment
SAP Solution Manager
Monitored system is running on Microsoft SQL Server 2005 database with a Service Pack level < SP2
Keywords
Microsoft SQL Server 2005, SP2, Service Pack 2, Solution Manager, monitoring, DBACockpit, Could not find stored procedure, SAPMonitor.sap_get_freespace, sql error 50000
, KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , How To
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.