Error during export of large SSRS report via ReportViewer

Question

I have an MVC3 application that delivers SQL Server 2008 reports using the Microsoft ReportViewer web control. Generally everything is working fine, except when exporting large reports to PDF.

At exactly 2 minutes into the export I get the following Server Error:

Exception Details: System.Web.HttpException: Request timed out

Digging deeper into the error, the SQL Report Server Log is pretty helpful:

Error: "RsException: A client has disconnected from Report Server"
Error Code: 800708CA: No connection available

So, my guess is that the ReportViewer connection timeout is a config setting somewhere, but I don't know where. We've already looked at all the configuration settings mentioned here but nothing is working - the timout always occurs at 2 minutes into the export!

Unfortunately I don't have a lot of SSRS configuration knowledge and neither do the company who actually host the the servers (the client's IT dept). So any help would be much appreciated.

Maybe look into the `executionTimeout` setting [here](http://msdn.microsoft.com/en-us/library/e1f13641(v=vs.100).aspx). Default is 110 seconds. — merekel, Feb 14 '13 at 21:50
It's good practice to mark answer which was help you as "Best answer" ;) — Roman Badiornyi, Feb 18 '13 at 14:06

score 0 · Answer 1 · answered Feb 14 '13 at 23:26

0

Submitting this an answer since it worked.

Maybe look into the executionTimeout setting here for the web.config file. Default is 110 seconds.

answered Feb 14 '13 at 23:26

merekel

443
5
15

Error during export of large SSRS report via ReportViewer

1 Answers1