Fix “Could not find stored procedure ‘Search_GetRepositoryTimePerCrawl'” Error

Problem:
When trying to navigate to a content source or crawl history in SharePoint 2013 search service application, I received this error message “Could not find stored procedure ‘Search_GetRepositoryTimePerCrawl'”

Could not find stored procedure 'Search_GetRepositoryTimePerCrawl'

Solution: Enable and run the timer job “Search Health Monitoring – Trace Events”!

Here is the step-by-step solution:

  • Navigate to SharePoint 2013 Central Administration
  • Click on “Monitoring” >> Review Timer job definitions
  • Pick the “Search Health Monitoring – Trace Events” timer job by navigating to the next page in the list.
  • Click on the “Enable” button if it’s not enabled already. Once enabled, click on the “Run Now” button for the same timer job.
    sharepoint search health monitoring - trace events timer job
  • Give it a minute to run. Once Ran, This issue should be gone away!

Salaudeen Rajack

Salaudeen Rajack - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

One thought on “Fix “Could not find stored procedure ‘Search_GetRepositoryTimePerCrawl'” Error

  • I also had to recreate the usage application and after that run this timer job in order to get it to work.

    Reply

Leave a Reply

Your email address will not be published.