Sharepoint 2013/SSRS error long reports
Posted on 2014-03-11
We are upgrading our Sharepoint to 2013. I have several reports that take about 3minutes to run because of a slow ODBC connection used by a linked server.
They ran fine in Sharepoint 2007. They run fine in Visual Studio 2013. However they return this error after about 1.5 minutes.
Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 503
Some reports run fine, it is only the ones that take longer than 1.5 minutes. I have tried adjusting every timeout option I can find. I have tried adding a connection timeout to the dataset. I have updated the report processing options to not timeout. I have added this to the web config file.
<httpRuntime maxRequestLength="51200" requestValidationMode="2.0" executionTimeout="1000"/>
No luck. Please help!!