Power-pivot SharePoint Schedule data refresh error "The Operation has timed out" if the file above 3MB size
Category: sql server powerpivotsp
Chandu Bheemuni on Tue, 30 May 2017 13:31:34
05/17/2017 07:50:22.45 w3wp.exe (0x1888) 0x315C PowerPivot Service Data Refresh 41High 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 99High 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...
willson yuan on Wed, 31 May 2017 02:07:03
Thanks for your question.
According to the error messages, it seems like an issue related to sharepoint 2016 when a .NET based Windows Service makes a call to ASP.NET Webservice to upload the file.
For more detailed information, please refer to below blog:
The operation has timed out. System.Net.WebResponse GetWebResponse(System.Net.WebRequest) at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
Increasing the timeout setting of the web service proxy class before making the call to the web service should help.
If this still not the case, I would recommend to submit it to the Microsoft Connect at this link https://connect.microsoft.com. This connect site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft Connect.