none
Power-pivot SharePoint Schedule data refresh error "The Operation has timed out" if the file above 3MB size RRS feed

  • Question

  • Dear Experts,

    We have completed PowerPivot16 configuration in our SP 2016 development environment (APP server 1, App server 2,SQL 2014 and OOS (Office online server)). Schedule data refresh is working fine for the file below 3MB, but when we are trying to schedule data refresh for the file above 5MB, we are seeing error as "The Operation has timed out”  (below image error 1) and SP logs showing as below, we have applied below (URL) work around, but no luck, showing error as "A schedule cannot...." (image error 2) and we revert back the work around. Can you please review this and let us know if there is other work around.  We have verified all settings of PowerPivot properties and all are fine.

    More over, we have also completed same configuration in QA environment and same issue repeated as above, not sure, but this is a known issue in SP 2016.

    Looking for your great support on this

    https://blogs.technet.microsoft.com/excel_services__powerpivot_for_sharepoint_support_blog/2017/04/14/powerpivot-for-sharepoint-2016-scheduled-data-refresh-error-the-operation-has-timed-out/

    We have  notice that the data source of which refresh failed on ran for exactly 1:40 (100 seconds) and getting below error

    

    05/17/2017 07:50:22.45 w3wp.exe (0x1888)                       0x315C
     PowerPivot Service            
    Data Refresh                  
    41
    High    
    The following exception occured during datarefresh on http://spbidev16/PV/PV-Above50MBNew.xlsx
     
    05/17/2017 07:50:22.46 w3wp.exe (0x1888)                       0x315C
     PowerPivot Service            
    Data Refresh                  
    99
    High    
    EXCEPTION: System.Net.WebException: The operation has timed out     at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)     at Microsoft.Office.Excel.Server.WebServices.ExcelServiceInternal.GetWebResponse(WebRequest request)     at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)     at Microsoft.Office.Excel.Server.WebServices.ExcelServiceInternal.RefreshEx(String sessionId, String connectionName, String targetApplicationId)     at Microsoft.Office.Excel.Server.WebServices.ExcelService.<>c__DisplayClass7e.<RefreshEx>b__7c(ExcelServiceInternal service, ProxyServiceResult`1 result)     at Microsoft.Office.Excel.Server.WebServices.ApiProxy.RunProxyAction[TResult](Action`2 proxyAction, ProxyServiceResult`1 re...


    Thursday, June 1, 2017 12:39 PM

All replies