none
Unable access Crawl latency from Health Reports

    Question

  • Hi,

    We are unable to access Crawl latency from health reports of SharePoint search. When we Click on Crawl --> Health reports and then click on “Crawl Latency” seeing below message. We have tried to get the information from the SP logs but no luck. Here are the logs with high importance.

    Your help will be much appreciated !!

    Logging Correlation Data     

    Medium 

    Name=Request _admin/search/crawllatency.aspx?appid=%7B08d2f83c-0278-43fd-bcb1-35cd74ae0b64%7D&dtstart=10%2f6%2f2015+2%3a53%3a47+AM&dtend=10%2f6%2f2015+2%3a53%3a47+PM)

    Asp Runtime                  

    High   

    [Forced due to logging gap, cached @ 10/06/2015 10:54:42.36, Original Level: Verbose] SPRequestModule.PostResolveRequestCacheHandler

    Asp Runtime                  

    High   

    [Forced due to logging gap, Original Level: Verbose] SPRequestModule.AcquireRequestStateHandler

    Database                     

    High   

    [Forced due to logging gap, cached @ 10/06/2015 10:54:44.09, Original Level: Verbose] SQL connection time: 0.0506349270647526 for Data Source=;Initial Catalog=;Integrated Security=True;Enlist=False;Pooling=True;Min Pool Size=0;Max Pool Size=100;Connect Timeout=15

    General                      

    High   

    [Forced due to logging gap, Original Level: Verbose] Looking up {0} site {1} in the farm {2}

    Monitoring                   

    High   

    Leaving Monitored Scope (ExecuteWcfOperation:http://tempuri.org/ISearchApplicationAdminWebService/GetContentSources). Execution Time=559.237207522185

    General                      

    High   

    SPRequest.GetFileAndMetaInfo: UserPrincipalName=, AppPrincipalName= ,bstrUrl=_admin/search/crawllatency.aspx?appid={08d2f83c-0278-43fd-bcb1-35cd74ae0b64}&dtstart=10/6/2015+2:53:47+AM&dtend=10/6/2015+2:53:47+PM ,bPageView=1 ,bPageMode=0 ,bGetBuildDependencySet=0 ,bstrCurrentFolderUrl=<null> ,iRequestVersion=0 ,bMainFileRequest=0

    General                      

    High   

    SPRequest.GetFileAndMetaInfo: UserPrincipalName=, AppPrincipalName= ,bstrUrl _admin/search/crawllatency.aspx?appid={08d2f83c-0278-43fd-bcb1-35cd74ae0b64}&dtstart=10/6/2015+2:53:47+AM&dtend=10/6/2015+2:53:47+PM ,bPageView=1 ,bPageMode=0 ,bGetBuildDependencySet=0 ,bstrCurrentFolderUrl=<null> ,iRequestVersion=0 ,bMainFileRequest=0

    General                      

    High   

    SPRequest.GetFileAndMetaInfo: UserPrincipalName=, AppPrincipalName= ,bstrUrl=_admin/search/crawllatency.aspx?appid={08d2f83c-0278-43fd-bcb1-35cd74ae0b64}&dtstart=10/6/2015+2:53:47+AM&dtend=10/6/2015+2:53:47+PM ,bPageView=1 ,bPageMode=0 ,bGetBuildDependencySet=0 ,bstrCurrentFolderUrl=<null> ,iRequestVersion=0 ,bMainFileRequest=0

    General                      

    High   

    SPRequest.GetFileAndMetaInfo: UserPrincipalName=, AppPrincipalName= ,bstrUrl=_/admin/search/crawllatency.aspx?appid={08d2f83c-0278-43fd-bcb1-35cd74ae0b64}&dtstart=10/6/2015+2:53:47+AM&dtend=10/6/2015+2:53:47+PM ,bPageView=1 ,bPageMode=0 ,bGetBuildDependencySet=0 ,bstrCurrentFolderUrl=<null> ,iRequestVersion=0 ,bMainFileRequest=0

    0x6FB7003                    

    High   

    [Forced due to logging gap, cached @ 10/06/2015 10:54:44.77, Original Level: Verbose] SQL connection time: 0.0462349265060224 for Data Source=;Initial Catalog=;Integrated Security=True;Enlist=False;Pooling=True;Min Pool Size=0;Max Pool Size=100;Connect Timeout=15

    General                      

    High   

    Getting Error Message for Exception System.ArgumentException: Column with name 'HybridParserTimeAvg' was not found.     at Microsoft.Office.Server.Search.Internal.UI.SearchCentralAdminPageBase.ErrorHandler(Object sender, EventArgs e)     at Microsoft.Office.Server.Search.Internal.UI.SearchCentralAdminPageBase.OnError(EventArgs e)     at System.Web.UI.Page.HandleError(Exception e)     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest()     at System.Web.UI.Page.ProcessRequest(HttpContext context)     at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.Ht...

    General                      

    High   

    ...tpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Upgrade                      

    High   

    [Forced due to logging gap, Original Level: Verbose] desiredVersion: {0}



    • Edited by NisanthM Thursday, October 15, 2015 2:19 PM Re added
    Thursday, October 15, 2015 2:08 PM

Answers

  • Hi,

    Microsoft confirmed this as a bug, hope this will fix in coming CU updates.

    Thanks for all your help!!


    Nisanth.M

    • Marked as answer by NisanthM Monday, October 26, 2015 9:04 AM
    Monday, October 26, 2015 9:04 AM

All replies

  • Hi,

    As I understand, you cannot access crawl latency from health reports in search service application in SharePoint 2013.

    You could check things below:

    1. Check if the account has the permission to access the crawl latency.

    2. Reset IIS to check if it can work.

    3. Run the SharePoint products configuration wizard to check if it can work.

    4. Check if the column is exist by the C# code. For more detailed information, you could refer to the article below.

    The article below is about Field with name … was not found – SPFieldCollection.

    http://johanolivier.blogspot.com/2013/02/field-with-name-was-not-found.html

    Best regards,

    Sara Fan


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Tuesday, October 20, 2015 9:03 AM
    Moderator
  • Hi,

    Thanks for your response !!


    1. Account having enough permissions to access crawl latency.

    2 & 3. Recently we applied Aug'15 CU in production environment at that time we did IISRESET and ran Products and config wizard also.

    4. The article explaining about library/list column but this is search column. How can i modify the script.

    Your help will be appreciated.



    Nisanth.M

    Tuesday, October 20, 2015 1:26 PM
  • Hi,

    Microsoft confirmed this as a bug, hope this will fix in coming CU updates.

    Thanks for all your help!!


    Nisanth.M

    • Marked as answer by NisanthM Monday, October 26, 2015 9:04 AM
    Monday, October 26, 2015 9:04 AM
  • This issue appeared after installing the October 2015 CU.  We skipped the August CU; and there was no CU for September.  Thus, it appears that this issue has persisted over several update cycles.
    Monday, October 26, 2015 5:57 PM
  • Can confirm this, same here.

    And it seems not to be the only bug in this CU. Accessing Central Admin --> Configure hybrid OneDrive and Sites features gives an error with resource files being missing or in the wrong place.


    // Tried and true method for weather forecasting - random numbers. String weather = (new Random()).Next(2)==0?"rainy":"sunny";

    Wednesday, November 11, 2015 8:46 AM
  • Still seeing this on two farms after installing November 2015 CU for SharePoint Server 2013.
    Am able to access the Configure hybrid OneDrive and Site features.  I also tried these remedies, but without affect:

    1. Reset IIS
    2. Logged in as different farm administrator account
    3. ensured that setup user administrator account was mapped as db_owner to all databases
    Monday, November 23, 2015 5:34 PM
  • We found the problem behind this error. Some changes were made to Logging Database Stored Procedures, but the CUs don't recreate them with the new fields.

    Our qick fix is to delete the following Stored Procedures from the Usage Logging database (this may not be supported by MS, so be careful!):

    • Search_GetCrawlLatency
    • Search_GetCrawlLoad
    • Search_GetCrawlLatencySummary

    and execute the following PowerShell script to let the provider recreate them:

    $dp = Get-SPDiagnosticsProvider | ?{$_.Name -like "Search Health Monitoring - Trace Events*"}
    $dp.OnProvisioning()




    // Tried and true method for weather forecasting - random numbers. String weather = (new Random()).Next(2)==0?"rainy":"sunny";

    Wednesday, November 25, 2015 2:36 PM
  • Yes, it works for me !

    Thanks

    Tuesday, January 19, 2016 10:22 PM
  • I am on the January 2016 CU for SharePoint 2013 SP1 Enterprise Edition and I have the error below looking for search latency.  When will this be fixed and or what can be done to resolve this w/o affecting production / recreating search?

    Sorry,
    something went wrong

    Column with name
    'HybridParserTimeAvg' was not found.


    Correlation ID:
    ebb9609d-4904-8059-2f4a-0754ced5f0ad

    Date
    and Time: 2/19/2016 7:12:16 AM

    15.0.4787.1000

    ​January 2016 CU

    Friday, February 19, 2016 12:14 PM
  • I just updated to SharePoint 2013 SP1 Enterprise Edition February 2016 CU

    15.0.4797.1000 ​| February 2016 CU

    I am logged in as the farm admin and am system admin on the SQL 2012 SP2 database.

    https://CENTRAL-ADMIN/_admin/search/crawllatency.aspx?appid={01cd735f-f2bb-4f7b-9eff-23e3c329cec4}&csid=2&dtstart=12%2f2%2f2015+1%3a21%3a29+PM&dtend=12%2f2%2f2015+4%3a07%3a14+PM

    Sorry, something went wrong
    Column with name 'HybridParserTimeAvg' was not found.
    Technical Details


    Troubleshoot issues with Microsoft SharePoint Foundation.

    Correlation ID: 98d3609d-143b-707f-44b9-5312659e2021

    Date and Time: 2/19/2016 2:41:01 PM

    Friday, February 19, 2016 7:52 PM
  • Still seeing this after installing SharePoint Server 2013 January 2016 CU (KB3114726).
    Monday, February 22, 2016 3:29 PM
  • Hi Nisanth,

    Did you get any hotfix from Microsoft for this issue. ?  We too have similar issue after updating with Feb2016CU.

    Thanks.

    Ashok

    Wednesday, March 30, 2016 12:24 PM
  • Hi Ashok,

    We are still waiting for the hot fix/CU.

    Thanks


    Nisanth.M

    Thursday, March 31, 2016 11:11 AM
  • We found the problem behind this error. Some changes were made to Logging Database Stored Procedures, but the CUs don't recreate them with the new fields.

    Our qick fix is to delete the following Stored Procedures from the Usage Logging database (this may not be supported by MS, so be careful!):

    • Search_GetCrawlLatency
    • Search_GetCrawlLoad
    • Search_GetCrawlLatencySummary

    and execute the following PowerShell script to let the provider recreate them:

    $dp = Get-SPDiagnosticsProvider | ?{$_.Name -like "Search Health Monitoring - Trace Events*"}
    $dp.OnProvisioning()

    This worked for me too. Thank you! 

    I'm on CU July 2016. How hard can it be for MS to fix this? Can't believe it...

    Tuesday, October 11, 2016 8:54 AM
  • Still no solve in november 2016 CU :(
    Friday, January 06, 2017 10:43 AM

  • The issue still here after January 2017 CU. It seems that they will never fix this bug. Therefore, we are left either to accept the inaccessibility of this health report, or to use the solution proposed by NisanthM.
    Tuesday, March 14, 2017 10:09 AM
  • I just updated our 2013 farm patch level from July 2015 to March 2017.  Now I get the Column with name 'HybridParserTimeAvg' was not found error too when accessing the Crawl Latency report.  My Hybrid OneDrive page seems to come up fine.

    I'm not a big fan of running unsanctioned fixes.  It doesn't seem worth the risk just for 1 report.  It would be great if there was an official fix from MS.


    Tuesday, April 25, 2017 2:41 PM
  • On the surface, this issue seems caused by Microsoft per NisanthM's October 2015 posting.  I would suggest if you can to submit a web-based Microsoft ticket on this issue.  This may help motivate more timely response.  To date, Microsoft may not have deemed this priority and so hasn't given it attention yet.  Submitting tickets can help move this.
    Tuesday, April 25, 2017 2:46 PM