SharePoint 2013 Crawl History Error

  • Article

Just a quick one; if you’ve ever seen the error “Could not find Stored Procedure Search_GetRepositoryTimePerCrawl” when you click on “crawl history” in the SharePoint Search app then this fix could be for you.

clip_image002

The Fix

In short, you need to run the “Search Health Monitoring - Trace Events” timer-job which is likely disabled.

clip_image004

This’ll fire on all servers:

clip_image006

Running this job will create this stored procedure missing and giving the error.

Now when you go-to crawl history it should all be working again!

clip_image008

That’s it – I told you it would be quick!

Cheers,

Sam Betts