Report Timeout

I have designed a report that hits a large table of over a million rows. The report runs in the development environment as a preview. When deployed, the report runs about 1.5 hours and then returns an error. The report is set not to timeout. What could be causing this behavior?What error is being returned?
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"DJP" <DJP@.discussions.microsoft.com> wrote in message
news:D8468C56-4D72-47FB-AA76-9A82D8A9CDAC@.microsoft.com...
> I have designed a report that hits a large table of over a million rows.
The report runs in the development environment as a preview. When deployed,
the report runs about 1.5 hours and then returns an error. The report is
set not to timeout. What could be causing this behavior?|||The page displayed is: The page cannot be displayed
"Bruce Johnson [MSFT]" wrote:
> What error is being returned?
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "DJP" <DJP@.discussions.microsoft.com> wrote in message
> news:D8468C56-4D72-47FB-AA76-9A82D8A9CDAC@.microsoft.com...
> > I have designed a report that hits a large table of over a million rows.
> The report runs in the development environment as a preview. When deployed,
> the report runs about 1.5 hours and then returns an error. The report is
> set not to timeout. What could be causing this behavior?
>
>

Report Service Seems to Go to Sleep

Hi,
I have a report server that is working almost fine and dandy. The only
little snafu seems to be if no one hits the server for "a while" the
report server seems to "go to sleep". Bringing up a report after it
has done this can take a little time, but any subsequent reports come
up nice and fast as they should. I also notice on the first hit in a
long time that the following message in the event log shows up:
"The ReportServer service has been activated."
Occassionally I will even see a timeout error occur the first time I
try to go to a report. But if I try it a second time it comes up nice
and quick. Is there a way to tune report server so that it doesn't do
this? Has anyone else run into this?
Thanks,
BillThis is a property in ASP.Net and your website. You can change worker
process recycling on the Application Pool of IIS6.0 to be just about as
long as you like.
--
| From: "zinck74" <bkelly3@.gmail.com>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Subject: Report Service Seems to Go to Sleep
| Date: 5 Jul 2005 17:13:56 -0700
| Organization: http://groups.google.com
| Lines: 18
| Message-ID: <1120608836.572936.22790@.g43g2000cwa.googlegroups.com>
| NNTP-Posting-Host: 131.107.0.103
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1120608842 16730 127.0.0.1 (6 Jul 2005
00:14:02 GMT)
| X-Complaints-To: groups-abuse@.google.com
| NNTP-Posting-Date: Wed, 6 Jul 2005 00:14:02 +0000 (UTC)
| User-Agent: G2/0.2
| Complaints-To: groups-abuse@.google.com
| Injection-Info: g43g2000cwa.googlegroups.com; posting-host=131.107.0.103;
| posting-account=H4pdeQ0AAACXytwviGUvL2hDckWajAKB
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g4
3g2000cwa.googlegroups.com!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:47443
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
| I have a report server that is working almost fine and dandy. The only
| little snafu seems to be if no one hits the server for "a while" the
| report server seems to "go to sleep". Bringing up a report after it
| has done this can take a little time, but any subsequent reports come
| up nice and fast as they should. I also notice on the first hit in a
| long time that the following message in the event log shows up:
|
| "The ReportServer service has been activated."
|
| Occassionally I will even see a timeout error occur the first time I
| try to go to a report. But if I try it a second time it comes up nice
| and quick. Is there a way to tune report server so that it doesn't do
| this? Has anyone else run into this?
|
| Thanks,
| Bill
|
|