x

Internet Explorer errors out while running a SSRS 2005 report for long time(more than an hour).

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

more ▼

asked Jan 07, 2013 at 03:55 PM in Default

avatar image

praful_ssrs
0 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jan 07, 2013 at 04:10 PM

avatar image

Fatherjack ♦♦
43.8k 79 99 118

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x691
x102
x33
x23

asked: Jan 07, 2013 at 03:55 PM

Seen: 1363 times

Last Updated: Jan 07, 2013 at 04:10 PM

Copyright 2017 Redgate Software. Privacy Policy