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.

SearchError

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.

SearchTimerJobDisabled

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

TimerJob

This is how Search Crawl Log page looks like

SearchLogs

Reference : http://www.wictorwilen.se/sharepoint-2013-fix-to-the-could-not-find-stored-procedure-search_getrepositorytimepercrawl-error

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 !

    ReplyDelete