Page expired after report execution
Hi. I have created a complex SSRS 2005 report that queries a large dwh and a SSAS 2005 cube. Now, when I launch the report, the rendering takes more two hours and when I click to navigate on a drill-down report I have an error about the page is expired. Any idea to solve this issue? Thanks
October 19th, 2010 10:00am

Hi, any suggests to me, please? I have a look inside the ReportServerWebApp_xxx.log and I have this detailed message (in Italian language): w3wp!ui!9!20/10/2010-13:25:07:: e ERROR: La pagina è scaduta. Per riaprirla, è necessario accedere alla pagina originale. w3wp!ui!9!20/10/2010-13:25:07:: e ERROR: HTTP status code --> 500 -------Details-------- System.Exception: La pagina è scaduta. Per riaprirla, è necessario accedere alla pagina originale. in Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Load(Object sender, EventArgs e) in System.Web.UI.Control.OnLoad(EventArgs e) in System.Web.UI.Control.LoadRecursive() in System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) w3wp!ui!9!20/10/2010-13:25:07:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread interrotto. in System.Threading.Thread.AbortInternal() in System.Threading.Thread.Abort(Object stateInfo) in System.Web.HttpResponse.End() in Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at in System.Threading.Thread.AbortInternal() in System.Threading.Thread.Abort(Object stateInfo) in System.Web.HttpResponse.End() in Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) Thus, the page has expired. To re-open it, it is need to access to the original page. Any helps to me, please?
Free Windows Admin Tool Kit Click here and download it now
October 20th, 2010 4:31pm

Hi pscorca, Based on your description, it is timeout issue because the report takes so much time to run. Try to solve this issue, for RS2005, find 'RSWebApplication.config' and add the following line under the 'UI' section: <PostbackTimeout>720</PostbackTimeout> so the full section, on mine at least looks like: <UI> <ReportServerUrl></ReportServerUrl> <ReportServerVirtualDirectory>ReportServer2005</ReportServerVirtualDirectory> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel> <PostbackTimeout>720</PostbackTimeout> <!-- Minutes, so this is 12 hours --> </UI> this is common solution, and mentioned at the last reply of http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/d84a7e4e-ec3e-4988-bfc8-6240f4f1457c . If the issue persists, see more info below about timeout of IE and reporting services. Increase ReceiveTimeout of IE to http://support.microsoft.com/kb/181050 Increase SystemSupportTimeout to 7200 http://msdn.microsoft.com/en-us/library/ms155025.aspx General informations about SSRS Timeouts you will find here http://blogs.msdn.com/mariae/archive/2009/09/24/troubleshooting-timeout-errors-in-reporting-services.aspx thanks, Jerry
October 21st, 2010 5:18am

Hi Jerry, just yesterday I have founded an article about the PostbackTimeout (http://blogs.msdn.com/b/selvar/archive/2009/12/02/leaving-a-report-idle-in-report-manager-and-acessing-it-again-throws-system-exception-the-page-has-expired-to-re-open-it-you-must-access-the-original-page.aspx) and I have set 180 minutes for this element and I have solved the issue. Already, I have adjusted the SSRS Timeout. Many thanks
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 10:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics