Wednesday, November 26, 2014

“Could not find Stored Procedure Search_GetRepositoryTimePerCrawl” error in SharePoint 2013

In Crawl Log page of Search Service Application, when I clicked on Content Source “Local SharePoint Sites”, I got an error which said “"Could not find Stored Procedure Search_GetRepositoryTimePerCrawl”.

Search Servie Log

This was how Something went wrong screen look like.


After searching on different sites, I found a solutions which suggests to check “Search Health Monitoring - Trace Events” Timer Job. When I checked it in Jobs Definitions page, I found it was disabled.


After enabling and running the timer job, issue was resolved.


This is how Search Crawl Log page looks like


Reference :

1 comment:

  1. Thank you for the explanation! I looked for this information hours and I tried to do a lot of things but nothing worked. On your blog I can always find what I need. Thank you so much !