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

  • Question

  • Dear Experts,

    We have completed PowerPivot16 configuration in our SP 2016 environment (APP server 1, App server 2,SQL 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.

    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...  

    Chandu Bheemuni

    Wednesday, May 17, 2017 2:37 PM

All replies