1874931 - Error 'Could not find stored procedure sap_get_freespace' in Solution Manager | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1874931 - Error 'Could not find stored procedure sap_get_freespace' in Solution Manager

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 (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) [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 a SQL Server 2005 database with a service pack level < SP2

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.