Showing posts with label Central Administration. Show all posts
Showing posts with label Central Administration. Show all posts

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