I have developed a report using SSRS 2005. This is embedded in a web application, which is built on C#/ASP.Net (3.5 framework/VS 2008).
The report is deployed in a report/db server, which is a part of two tier architecture ie. app and db. This report takes more than an hour for execution and producing the output, as it calls a stored procedure which processes large volume of data.
When the report is being run and the elapsed time is close to an hour, then an error message is displayed as: "Internet Explorer can not display the webpage".Version of Internet explorer and IIS is 6.0.
Event viewer log has following message: Event Type: Warning Event Source: ASP.NET 2.0.50727.0 Event Category: Web Event Event ID: 1309 Date: 1/7/2013 Time: 10:58:04 AM User: N/A Computer: -------------------- Description: Event code: 3005 Event message: An unhandled exception has occurred. Process ID: 7456 Process name: w3wp.exe Account name: NT AUTHORITY\NETWORK SERVICE Exception type: AspNetSessionExpiredException Exception message: ASP.NET session has expired Request URL:http://------/ABC/Reserved.ReportViewerWebControl.axd?ReportSession=1ki0jo3ouutixi555breaja4&ControlID=9ab46efcbab44cb987c5b9967fea54c3 &Culture=1033&UICulture=1033ℜportStack=1&OpType=SessionKeepAlive&TimerMethod =KeepAliveMethodctl00_ContentPlaceHolder1_ReportViewer1TouchSession0
asked Jan 07, 2013 at 03:55 PM in Default
I'd seriously start work on reducing the time that the procedure takes to execute.
If it cant be reduced significantly then I'd recommend running it on a schedule (every day, twice a day, ever 3 hours ????) and have the results in a table that the SSRS report references. This way noone opening the report will accidentally start the procedure - potentially an unlimited number of times.
answered Jan 07, 2013 at 04:10 PM