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.

      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...  
    Wednesday, May 31, 2017 8:24 AM

All replies