Home
%3CLINGO-SUB%20id%3D%22lingo-sub-307736%22%20slang%3D%22en-US%22%3EUnable%20to%20access%20Crawl%20History%20from%20SharePoint%20Central%20Admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307736%22%20slang%3D%22en-US%22%3E%3CH1%20id%3D%22toc-hId-1869939169%22%20id%3D%22toc-hId-1898419518%22%3ESummary%3C%2FH1%3E%0A%3CP%3EHave%20you%20experienced%20an%20issue%20where%20%22Crawl%20History%22%20is%20inaccessible%20in%20your%20Farm%20and%20throwing%20error%2C%20%22%3CSTRONG%3ECould%20not%20find%20stored%20procedure%20'Search_GetRepositoryTimePerCrawl'%3C%2FSTRONG%3E%22%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20so%2C%20you%20may%20have%20some%20across%20this%20blog%20%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsambetts%2F2014%2F12%2F10%2Fsharepoint-2013-crawl-history-error%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblogs.msdn.microsoft.com%2Fsambetts%2F2014%2F12%2F10%2Fsharepoint-2013-crawl-history-error%2F%3C%2FA%3E%20which%20details%20how%20the%20store%20procedure%20is%20created%20and%20the%20issue%20could%20be%20that%20the%20timer%20job%20to%20complete%20the%20provisioning%20is%20disabled.%20In%20these%20cases%2C%20just%20enabling%20and%20stating%20the%20%22%3CSTRONG%3ESearch%20Health%20Monitoring%20-%20Trace%20Events%3C%2FSTRONG%3E%22%20timer%20job%20does%20the%20trick.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%2C%20if%20this%20didn't%20work%20in%20your%20case%2C%20please%20keep%20reading%20for%20possible%20workaround...%3C%2FP%3E%0A%3CH1%20id%3D%22toc-hId--682217792%22%20id%3D%22toc-hId--653737443%22%3E%26nbsp%3B%3C%2FH1%3E%0A%3CH1%20id%3D%22toc-hId-1060592543%22%20id%3D%22toc-hId-1089072892%22%3EProblem%20Description%3C%2FH1%3E%0A%3CP%3EUnable%20to%20access%20%22Crawl%20History%22%20with%20error%2C%20%22%3CSTRONG%3ECould%20not%20find%20stored%20procedure%20'Search_GetRepositoryTimePerCrawl'%3C%2FSTRONG%3E%22%3CSTRONG%3E%3CBR%20%2F%3E%20%3C%2FSTRONG%3Eand%20the%20%22%3CSTRONG%3ESearch%20Health%20Monitoring%20-%20Trace%20Events%22%3C%2FSTRONG%3E%20timer%20job%20%3CSPAN%3Eis%3C%2FSPAN%3E%20enabled.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExample%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20886px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64436i4C1C5D724C2F9368%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22062818_1508_Unabletoacc1.png%22%20title%3D%22062818_1508_Unabletoacc1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EResult%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3E%3CFONT%20size%3D%222%22%3ESorry%2C%20something%20went%20wrong%3CBR%20%2F%3E%20Could%20not%20find%20stored%20procedure%20'Search_GetRepositoryTimePerCrawl'.%3CBR%20%2F%3E%20Technical%20Details%3CBR%20%2F%3E%20Correlation%20ID%3A%209f8f759e-2620-a083-a46d-e8b0cda512ca%3CBR%20%2F%3E%20%3C%2FFONT%3E%3C%2FEM%3E%3CSPAN%3E%3CEM%3E%3CFONT%20size%3D%222%22%3EDate%20and%20Time%3A%206%2F28%2F2018%2010%3A30%3A04%20AM%3C%2FFONT%3E%3C%2FEM%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH1%20id%3D%22toc-hId--1491564418%22%20id%3D%22toc-hId--1463084069%22%3E%26nbsp%3B%3C%2FH1%3E%0A%3CH1%20id%3D%22toc-hId-251245917%22%20id%3D%22toc-hId-279726266%22%3ECause%3C%2FH1%3E%0A%3CP%3EThe%20%22%3CSTRONG%3ESearch%20Health%20Monitoring%20-%20Trace%20Events%3C%2FSTRONG%3E%22%20timer%20job%20unexpectedly%20fails%20to%20execute%20the%20provisioning%20process%20and%20the%20SQL%20changes%20are%20rolled%20back.%3C%2FP%3E%0A%3CH1%20id%3D%22toc-hId-1994056252%22%20id%3D%22toc-hId-2022536601%22%3E%26nbsp%3B%3C%2FH1%3E%0A%3CH1%20id%3D%22toc-hId--558100709%22%20id%3D%22toc-hId--529620360%22%3EResolution%3C%2FH1%3E%0A%3CP%3ETo%20resolve%20this%2C%20force%20the%20provisioning%20process%20associated%20with%20the%20%22%3CSTRONG%3ESearch%20Health%20Monitoring%20-%20Trace%20Events%3C%2FSTRONG%3E%22%20Timer%20Job%2C%20by%20executring%20the%20following%20PowerShell%20commands.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CSPAN%3E%20Add-PSSnapin%20microsoft.sharepoint.powershell%20-EA%200%0A%20%3C%2FSPAN%3E%3CSPAN%3E%24diag%20%3D%20Get-SPDiagnosticsProvider%20-identity%20%22Search%20Health%20Monitoring%20-%20Trace%20Events%22%0A%20%3C%2FSPAN%3E%3CSPAN%3E%24diag.OnProvisioning()%0A%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThis%20process%20should%20force%20the%20initialization%20of%20the%20missing%20tables%20and%20stored%20procedures%20within%20the%20Search%20DB%20according%20to%20the%20definition%20of%20%22%3CSTRONG%3ESearch%20Health%20Monitoring%20-%20Trace%20Events%3C%2FSTRONG%3E%22%26nbsp%3B%20diagnostic%20provider.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH1%20id%3D%22toc-hId-1184709626%22%20id%3D%22toc-hId-1213189975%22%3E%26nbsp%3B%3C%2FH1%3E%0A%3CH1%20id%3D%22toc-hId--1367447335%22%20id%3D%22toc-hId--1338966986%22%3EMore%20Information%3C%2FH1%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGet-SPDiagnosticsProvider%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fsharepoint-server%2Fget-spdiagnosticsprovider%3Fview%3Dsharepoint-ps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fsharepoint-server%2Fget-spdiagnosticsprovider%3Fview%3Dsharepoint-ps%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESPDiagnosticsProvider.OnProvisioning%20method%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Foffice%2Fmicrosoft.sharepoint.diagnostics.spdiagnosticsprovider.onprovisioning.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Foffice%2Fmicrosoft.sharepoint.diagnostics.spdiagnosticsprovider.onprovisioning.aspx%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-307736%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ECrawl%20History%20fails%20with%20error%2C%20%3CSTRONG%3E%22%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSTRONG%3ECould%20not%20find%20stored%20procedure%20'Search_GetRepositoryTimePerCrawl'%22%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-307736%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20On-Prem%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Support%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-308523%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20access%20Crawl%20History%20from%20SharePoint%20Central%20Admin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-308523%22%20slang%3D%22en-US%22%3EMakinan%C4%B1za%20insert%20a%20recovery%20driver%20and%20restart%20it%20when%20you%20see%20the%20bios%20u%20f%20hold%20down%20f%20until%20the%2012%20key%20will%20not%20open%20with%2012%20f%20F%209%2F11%20will%20not%20again%20try%20try%20not%20again%20F%208.%20Sincerely%20yours%20Browsing%20history%20you%20can%20find%20the%20following%20SharePoint%20Central%20Administration.%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2F40345839668%2Fazure-docs%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2F40345839668%2Fazure-docs%3C%2FA%3E%3C%2FLINGO-BODY%3E

Summary

Have you experienced an issue where "Crawl History" is inaccessible in your Farm and throwing error, "Could not find stored procedure 'Search_GetRepositoryTimePerCrawl'"?

 

If so, you may have some across this blog https://blogs.msdn.microsoft.com/sambetts/2014/12/10/sharepoint-2013-crawl-history-error/ which details how the store procedure is created and the issue could be that the timer job to complete the provisioning is disabled. In these cases, just enabling and stating the "Search Health Monitoring - Trace Events" timer job does the trick.

 

However, if this didn't work in your case, please keep reading for possible workaround...

 

Problem Description

Unable to access "Crawl History" with error, "Could not find stored procedure 'Search_GetRepositoryTimePerCrawl'"
and the "Search Health Monitoring - Trace Events" timer job is enabled.

 

Example:

062818_1508_Unabletoacc1.png

 

 

Result:

 

Sorry, something went wrong
Could not find stored procedure 'Search_GetRepositoryTimePerCrawl'.
Technical Details
Correlation ID: 9f8f759e-2620-a083-a46d-e8b0cda512ca
Date and Time: 6/28/2018 10:30:04 AM

 

Cause

The "Search Health Monitoring - Trace Events" timer job unexpectedly fails to execute the provisioning process and the SQL changes are rolled back.

 

Resolution

To resolve this, force the provisioning process associated with the "Search Health Monitoring - Trace Events" Timer Job, by executring the following PowerShell commands.

 

 Add-PSSnapin microsoft.sharepoint.powershell -EA 0
 $diag = Get-SPDiagnosticsProvider -identity "Search Health Monitoring - Trace Events"
 $diag.OnProvisioning()

 

This process should force the initialization of the missing tables and stored procedures within the Search DB according to the definition of "Search Health Monitoring - Trace Events"  diagnostic provider.

 

More Information

 

Get-SPDiagnosticsProvider
https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/get-spdiagnosticsprovider?view=...

 

SPDiagnosticsProvider.OnProvisioning method
https://msdn.microsoft.com/en-us/library/office/microsoft.sharepoint.diagnostics.spdiagnosticsprovid...

1 Comment
Contributor
Makinanıza insert a recovery driver and restart it when you see the bios u f hold down f until the 12 key will not open with 12 f F 9/11 will not again try try not again F 8. Sincerely yours Browsing history you can find the following SharePoint Central Administration. https://github.com/40345839668/azure-docs