Wednesday, May 18, 2011

Event ID 6398 and 5586 in SharePoint - Resolution

In a SharePoint Implementation, after provisioning Search Service application, Event log gets filled by these two events every minute: 6398 and 5586.

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 for Event ID 5586 in Sharepoint

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’.
Could not find stored procedure ‘dbo.Search_GetRecentStats’

This is because you have the Usage and Health Data Collection Service Application installed. Intern this service application creates a database for logging and Search Service will try to make entries in that database and it couldn’t :-)

The solution is:  Enable health data collection. go to "Central Administration >> Monitoring >> Configure usage and health data collection" and check "Enable health data collection" check box.
SharePoint 2010 Event ID 6398 and 5586 Resolution
Don't forget to Restart IIS and SharePoint Timer job!

If its enabled already and still these IDs are logged into event viewer, then disable that first. Restart IIS and SharePoint Timer service. Enable them and then Restart IIS and SharePoint Timer service again.

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.

Check out these SharePoint products:


  1. when you say restart sharepoint timer job, you mean one specific timer job, or you mean something else? thanks.

    1. I mean the SharePoint Timer Job from Services console! Type: services.msc in Run dialog box, Find the "SharePoint 2010 Timer" service, Right click on the service and choose "Restart".


Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...