Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ReportViewer timeouts in spite of timeout settings

Tags:

I have an ASP.NET app that exposes a Microsoft ReportViewer (actually an MVC3 app with one WebForm hosting the ReportViewer). When running large reports, a timeout occurs causing the request to stop and a blank page to show in place of a report. Yet the following timeout parameters are set programmatically:

Viewer.ServerReport.Timeout = Configuration.ReportViewerTimeout;
ScriptManager.AsyncPostBackTimeout = Configuration.ReportViewerAjaxTimeout;

The respective values are -1 and 0 which as per documentation are interpreted as no timeout. I also tried large values, it made no difference.

After about a minute or so waiting on the report to load ("Loading" message box), I get a blank report and I see this in my Firebug console window:

Aborted

Sys.WebForms.PageRequestManagerTimeoutException: The server request timed out.

[Break On This Error] this._endPostBack(this._cr...anagerTimeoutError(), sender, null);

I also tried adding this to my web.config:

<httpRuntime maxRequestLength="1024000" executionTimeout="999999" /> 

And in IIS > my site > Advanced Settings > Connection Limits I set "Connection Time-out (seconds)" to 1200. All this made no difference.

Does anyone know what I could be missing?

like image 372
Clafou Avatar asked Sep 01 '11 15:09

Clafou


2 Answers

set the AsyncPostBackTimeOut="" value in script manager

   <asp:ScriptManager ID="ScriptManager1" runat="server" AsyncPostBackTimeOut="56000" >
</asp:ScriptManager>

for more detail http://msdn.microsoft.com/en-us/library/system.web.ui.scriptmanager.asyncpostbacktimeout.aspx

like image 83
Mahesh Avatar answered Sep 19 '22 21:09

Mahesh


Turns out that the answer is: There is actually nothing missing!

As it happens, the ScriptManager's timeout value is not persisted in ViewState (unlike the ReportViewer's timeout value) and the code was only setting it once inside a if (!PostBack) block. Fixed by setting the ScriptManager's AsyncPostBackTimeout property at each request (even postbacks). An alternative is to set it to a fixed value using the Visual Studio WebForm designer.

like image 21
Clafou Avatar answered Sep 20 '22 21:09

Clafou