Showing posts with label cpu. Show all posts
Showing posts with label cpu. Show all posts

Monday, March 26, 2012

IE v7 SP3 - Crashes on SSRS Reports

I installed IE 7 beta 3 on two of my systems, now when I try to run any of
my SSRS reports IE starts using 100% of the CPU and never stops. Has anyone
else seen this issue?
I know this is an IE issue, just thought I would check with other SSRS
users.Yes. This is a known problem. In my conversation with MS I was told that the
IE team knows this and has promised to fix the problem. IE7 beta 2 did not
have trouble but beta 3 does.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Michael Morisoli" <michael@.removeme.vieon.net> wrote in message
news:%23LrQvBtxGHA.3440@.TK2MSFTNGP06.phx.gbl...
>I installed IE 7 beta 3 on two of my systems, now when I try to run any of
>my SSRS reports IE starts using 100% of the CPU and never stops. Has
>anyone else seen this issue?
> I know this is an IE issue, just thought I would check with other SSRS
> users.
>

Friday, March 23, 2012

IE 7 B3 Not Compatible With RS2005

Lon posted a message on the RS UseNet newsgroup about IE 7 B3 being unresponsive and using 100% of the cpu when trying to view RS reports.

I tried it on a test system, and indeed the problem showed up for me as well. Both the IE 7 B3 32 bit and 64 bit version where stuck in a loop when attempting to view RS 2005 reports. I tried both parameter and non-parameterized reports with the same results. The only way to stop it is via Task Manager.

A warning to all, do not install IE 7 B3 if you want to run RS reports.

Hey MS, you may want to pass this on to IE 7 development team. This
isn't good when MS products aren't compatible with each other.

I have IE Beta 3 and work fine with RS 2005.

May be a special report.

|||I experienced the same problem, the screen starts flickering and IE won′t come back. If you open up a BUG on connect.microsoft.com I will vote on it.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Yes, please open a bug so we can take a look. Do you also see the problem using URL Access? ie:

http://<server>/reportserver?/Folder/Report&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=false

Thanks, Donovan.

|||

So I just tried that, if called directly via the Webservice and the path string, the problem is not occuring. Unfortunaly if you use this method you would have to pass the parameters via URL string, so I opened up a bug targeting this problem. Thats even not a problem of complexity, I just used a blank report with one textbox and deployed that to the server, which will also cause IE to hang.

I filed the BUG under https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=157905

Please vote on it, if you also experienced the problem.

Danovan, could you share this feedback along with the IE 7 group, I don′t know who is responsible for that, I filed the bug under SQL Server not IE.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Filing it under SQL is the right place to put this issue. We have a lot of script that executes when viewing the report through the report manager that doesn't execute when using URL Access. We'll take a look at what's going on and let the IE team know what we find, if necessary.

I just upgraded my laptop to IE7 B3 and see the same behavior before a report is even present (ie, just blank parameters are showing). Thanks for pointing this out.

Thanks, Donovan.

|||

We've identified the problem and are discussing the fix with the IE team. Thanks for reporting this.

Donovan

|||

If there is a hotfix etc available please post. I am flipping between two machines to view my reports.

Thanks

|||

A fix has gone into IE7 so B2 and RTM should work fine. Unfortunately, in the meantime, there is no work-around for B3.

Thanks, Donovan.

|||http://sqlserver2005.de/SQLServer2005/MyBlog/tabid/56/EntryID/17/Default.aspx

FYI

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

IE 7 B3 Not Compatible With RS2005

Lon posted a message on the RS UseNet newsgroup about IE 7 B3 being unresponsive and using 100% of the cpu when trying to view RS reports.

I tried it on a test system, and indeed the problem showed up for me as well. Both the IE 7 B3 32 bit and 64 bit version where stuck in a loop when attempting to view RS 2005 reports. I tried both parameter and non-parameterized reports with the same results. The only way to stop it is via Task Manager.

A warning to all, do not install IE 7 B3 if you want to run RS reports.

Hey MS, you may want to pass this on to IE 7 development team. This
isn't good when MS products aren't compatible with each other.

I have IE Beta 3 and work fine with RS 2005.

May be a special report.

|||I experienced the same problem, the screen starts flickering and IE won′t come back. If you open up a BUG on connect.microsoft.com I will vote on it.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Yes, please open a bug so we can take a look. Do you also see the problem using URL Access? ie:

http://<server>/reportserver?/Folder/Report&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=false

Thanks, Donovan.

|||

So I just tried that, if called directly via the Webservice and the path string, the problem is not occuring. Unfortunaly if you use this method you would have to pass the parameters via URL string, so I opened up a bug targeting this problem. Thats even not a problem of complexity, I just used a blank report with one textbox and deployed that to the server, which will also cause IE to hang.

I filed the BUG under https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=157905

Please vote on it, if you also experienced the problem.

Danovan, could you share this feedback along with the IE 7 group, I don′t know who is responsible for that, I filed the bug under SQL Server not IE.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Filing it under SQL is the right place to put this issue. We have a lot of script that executes when viewing the report through the report manager that doesn't execute when using URL Access. We'll take a look at what's going on and let the IE team know what we find, if necessary.

I just upgraded my laptop to IE7 B3 and see the same behavior before a report is even present (ie, just blank parameters are showing). Thanks for pointing this out.

Thanks, Donovan.

|||

We've identified the problem and are discussing the fix with the IE team. Thanks for reporting this.

Donovan

|||

If there is a hotfix etc available please post. I am flipping between two machines to view my reports.

Thanks

|||

A fix has gone into IE7 so B2 and RTM should work fine. Unfortunately, in the meantime, there is no work-around for B3.

Thanks, Donovan.

|||http://sqlserver2005.de/SQLServer2005/MyBlog/tabid/56/EntryID/17/Default.aspx

FYI

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Idle Sql Agent consumes CPU

The performance monitor on our Win 2003 server often shows CPU at 25%, due
entirely to Sql Server Agent at a time when the agent shows no jobs running.
We stop and restart the agent, and CPU consumption drops to zero. A day or
two later and we're back to 25% again because of the agent. We're running
Sql Server 2000.
What is the problem?
Thanks,
Randy NeallDid you also watch with Profiler to see what's going on?
If you aren't using alerts, you could try deleting the demo
alerts that are installed by default. You can script out the
alerts first and then drop them.
-Sue
On Tue, 14 Mar 2006 21:33:25 -0500, "Randolph Neall"
<randolphneall@.veracitycomputing.com> wrote:
>The performance monitor on our Win 2003 server often shows CPU at 25%, due
>entirely to Sql Server Agent at a time when the agent shows no jobs running.
>We stop and restart the agent, and CPU consumption drops to zero. A day or
>two later and we're back to 25% again because of the agent. We're running
>Sql Server 2000.
>What is the problem?
>Thanks,
>Randy Neall
>|||Thank you, Sue. We'll try to follow your advice.
Randy
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:8f9f12dc24sqedodsd954e24flcs22tfat@.4ax.com...
> Did you also watch with Profiler to see what's going on?
> If you aren't using alerts, you could try deleting the demo
> alerts that are installed by default. You can script out the
> alerts first and then drop them.
> -Sue
> On Tue, 14 Mar 2006 21:33:25 -0500, "Randolph Neall"
> <randolphneall@.veracitycomputing.com> wrote:
> >The performance monitor on our Win 2003 server often shows CPU at 25%,
due
> >entirely to Sql Server Agent at a time when the agent shows no jobs
running.
> >We stop and restart the agent, and CPU consumption drops to zero. A day
or
> >two later and we're back to 25% again because of the agent. We're running
> >Sql Server 2000.
> >
> >What is the problem?
> >
> >Thanks,
> >
> >Randy Neall
> >
> >
>

Idle Sql Agent consumes CPU

The performance monitor on our Win 2003 server often shows CPU at 25%, due
entirely to Sql Server Agent at a time when the agent shows no jobs running.
We stop and restart the agent, and CPU consumption drops to zero. A day or
two later and we're back to 25% again because of the agent. We're running
Sql Server 2000.
What is the problem?
Thanks,
Randy Neall
Did you also watch with Profiler to see what's going on?
If you aren't using alerts, you could try deleting the demo
alerts that are installed by default. You can script out the
alerts first and then drop them.
-Sue
On Tue, 14 Mar 2006 21:33:25 -0500, "Randolph Neall"
<randolphneall@.veracitycomputing.com> wrote:

>The performance monitor on our Win 2003 server often shows CPU at 25%, due
>entirely to Sql Server Agent at a time when the agent shows no jobs running.
>We stop and restart the agent, and CPU consumption drops to zero. A day or
>two later and we're back to 25% again because of the agent. We're running
>Sql Server 2000.
>What is the problem?
>Thanks,
>Randy Neall
>
|||Thank you, Sue. We'll try to follow your advice.
Randy
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:8f9f12dc24sqedodsd954e24flcs22tfat@.4ax.com... [vbcol=seagreen]
> Did you also watch with Profiler to see what's going on?
> If you aren't using alerts, you could try deleting the demo
> alerts that are installed by default. You can script out the
> alerts first and then drop them.
> -Sue
> On Tue, 14 Mar 2006 21:33:25 -0500, "Randolph Neall"
> <randolphneall@.veracitycomputing.com> wrote:
due[vbcol=seagreen]
running.[vbcol=seagreen]
or
>
sql

Idle Sql Agent consumes CPU

The performance monitor on our Win 2003 server often shows CPU at 25%, due
entirely to Sql Server Agent at a time when the agent shows no jobs running.
We stop and restart the agent, and CPU consumption drops to zero. A day or
two later and we're back to 25% again because of the agent. We're running
Sql Server 2000.
What is the problem?
Thanks,
Randy NeallDid you also watch with Profiler to see what's going on?
If you aren't using alerts, you could try deleting the demo
alerts that are installed by default. You can script out the
alerts first and then drop them.
-Sue
On Tue, 14 Mar 2006 21:33:25 -0500, "Randolph Neall"
<randolphneall@.veracitycomputing.com> wrote:

>The performance monitor on our Win 2003 server often shows CPU at 25%, due
>entirely to Sql Server Agent at a time when the agent shows no jobs running
.
>We stop and restart the agent, and CPU consumption drops to zero. A day or
>two later and we're back to 25% again because of the agent. We're running
>Sql Server 2000.
>What is the problem?
>Thanks,
>Randy Neall
>|||Thank you, Sue. We'll try to follow your advice.
Randy
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:8f9f12dc24sqedodsd954e24flcs22tfat@.
4ax.com...
> Did you also watch with Profiler to see what's going on?
> If you aren't using alerts, you could try deleting the demo
> alerts that are installed by default. You can script out the
> alerts first and then drop them.
> -Sue
> On Tue, 14 Mar 2006 21:33:25 -0500, "Randolph Neall"
> <randolphneall@.veracitycomputing.com> wrote:
>
due[vbcol=seagreen]
running.[vbcol=seagreen]
or[vbcol=seagreen]
>