Event 6398 Could not find stored procedure ‘dbo.Search_GetRecentStats’

Problem

You get the following errors in the event log on your SharePoint server.

Event ID: 6398

The Execute method of job definition Microsoft.Office.Server.Search.Monitoring.HealthStatUpdateJobDefinition (ID 9cb6be54-0384-4c6e-abfc-c2f25621a3ed) threw an exception. More information is included below.

Could not find stored procedure ‘dbo.Search_GetRecentStats’.

Event ID: 5586

Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below.

Could not find stored procedure ‘dbo.Search_GetRecentStats’.

Solution

The first thing to check would be whether Usage and Health data collection is enabled on your farm. To enable it:

  • Open Central Administration -> Monitoring -> Configure Usage and Health Data Collection
  • Ensure that Enable usage data collection and Enable Health data collection is ticked.
  • Select the events you wish to log.
  • Configure the Health Logging and Log Collection schedules.
  • Set the name of the database server and database name.

Give it some time and see if the problem is resolved, otherwise try restarting the SharePoint Timer Service on the server(s).

If this still does not work and you have already enabled the Usage and Health Data Collection service application. Try the following:

  • Turn off the Usage and Health Data Collection, unchecking both ‘Enable usage data collection and ‘Enable health data collection’.
  • Restart the SharePoint 2010 Timer service on all your SharePoint servers.
  • Turn the Usage and Health Data Collection back on.

Tags: ,

No comments yet.

Leave a Reply

%d bloggers like this: