Question

Chandu Bheemuni on Tue, 30 May 2017 13:31:34


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/

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



Replies

willson yuan on Wed, 31 May 2017 02:07:03


Hi Chandu,

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.