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:

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.

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

2 thoughts on “Event ID 6398 and 5586 in SharePoint – Resolution

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

    Reply
    • 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”.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *