Showing posts with label restart. Show all posts
Showing posts with label restart. Show all posts

Friday, March 23, 2012

ReportServerService running at 99% CPU and using 1 GB of memory

The ReportServerService is running at 99% CPU and using 1 GB of memory on
Windows Server 2003. When we restart the service or the server,
ReportServerService starts running away again. This server was working OK in
the past - this problem just recently started.
Does anyone have any idea what might cause this?
Thanks,
--
RickWhat version are you running? If you don't have SP2 installed I suggest
trying that. Otherwise, I haven't seen this reported here before. I've seen
something similar but restarting the service would clear it up but in your
case this doesn't help.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rick" <Rick@.discussions.microsoft.com> wrote in message
news:3B5BBD8B-0683-409E-87AE-195454B66CD3@.microsoft.com...
> The ReportServerService is running at 99% CPU and using 1 GB of memory on
> Windows Server 2003. When we restart the service or the server,
> ReportServerService starts running away again. This server was working OK
> in
> the past - this problem just recently started.
> Does anyone have any idea what might cause this?
> Thanks,
> --
> Rick|||Found the problem - a subscription was trying to render a large report to
Excel, but it failed and then retried continually. I had to delete the
subscription.
--
Rick
"Rick" wrote:
> The ReportServerService is running at 99% CPU and using 1 GB of memory on
> Windows Server 2003. When we restart the service or the server,
> ReportServerService starts running away again. This server was working OK in
> the past - this problem just recently started.
> Does anyone have any idea what might cause this?
> Thanks,
> --
> Ricksql

Wednesday, March 21, 2012

Reports using OLAP fail after 30 minutes without reboot or IIS restart

We are having problems with Reports that Access MSAS. After about
15-30 minutes the reports no longer work and we have to stop and
restart IIS and make one visit to the report manager page. We have to
continue to visit reports or the report manager page every 15 minutes
of we get rsProcessingAborted errors related to a MSAS data source
connection. The environment looks like the following:
Windows Server 2003 SP1
Reports Services SP2
SQL Server SP3
Analysis Services SP3
(everything is on the same box)
The Problem:
After about 30 minutes reports fail with the following error:
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'VIS_DATAMART'.
(rsErrorOpeningConnection) Get Online Help
The 'MSOLAP.2' provider is not registered on the local machine.
No error information available: REGDB_E_CLASSNOTREG(0x80040154).
We can prevent the above problem with the following hack:
Created an application that visits the report manager url every 15
minutes. So far near as we can tell, that approach prevents the
rsprocessingaborted error. We've also noticed that if our testers
continue to test without 15-30 minutes of in-active time, the site will
continue to work.
I'd like to eliminate this problem and the hack we are relying on. The
problem seems like it is related to caching. Anyone have any thought
or suggestions?Finally found a solution!
I had to create an additional application pool in IIS and move our custom
ASP.NET application to that pool and leave reporting services in the default
pool. After that change the problem went away.

Tuesday, March 20, 2012

Reports Stop Responding

Does anyone ever have an issue where reports stop responding and you
have to restart IIS and the Report Services to get the reports to
respond again? I notice that this happens when a report runs too long.
Does anyone know of a fix? I am still on SP1 waiting for our QA
department to allow us to put SP2 on our production evironment.Check the logs and see if you are getting an error... We have been seeing
some timeouts which look like what you are talking about.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Luke" <lukeguerrant@.gmail.com> wrote in message
news:1118855826.058063.221120@.g47g2000cwa.googlegroups.com...
> Does anyone ever have an issue where reports stop responding and you
> have to restart IIS and the Report Services to get the reports to
> respond again? I notice that this happens when a report runs too long.
> Does anyone know of a fix? I am still on SP1 waiting for our QA
> department to allow us to put SP2 on our production evironment.
>|||I don't see any errors in any of the logs.