Skip to Content
0
Former Member
Sep 09, 2008 at 02:12 PM

CCMS Cleanup Saplocks - Missing stored procedure

449 Views

Hi,

I'm getting an error on this Job on the SQL Server Agent

"Executed as user: <SID>adm. Could not find stored procedure 'sap_cleanup_blockstats'. [SQLSTATE 42000] (Error 2812). The step failed."

I've searched on service marketplace and in SDN and the only referenece is in SAP Note Number: 547911 - SAP CCMS Blocking Lockstats where it says that the job is set running report MSSPROCS, but if you only have the java part of Netweaver installed how can set this job or how can get the stored procedure.

Rgds,