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’.
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’.
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:
Enable health data collection. go to “Central Administration >> Monitoring >> Configure usage and health data collection” and check “Enable health data collection” check box.
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.
when you say restart sharepoint timer job, you mean one specific timer job, or you mean something else? thanks.
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”.