Showing posts with label repot. Show all posts
Showing posts with label repot. Show all posts

Wednesday, March 7, 2012

Repot Manager Hangs

This happens very frequently on our server and I can't determine the cause.
The basic issue is that SRs gets into a state where it hangs, you can't
render reports,you can't even vire proprties, navigate folder etc, so I know
its not extenal data sources.
One things I tried was disabling Script Blocking which was enabled on our
antivirus. This is mentioned in this Kb:
http://support.microsoft.com/kb/295375/en-us
I also set the IIS Idle rest to 8 hours. But that wasn't the initial issue.
I've been looking at perfmon (thread counts, pages\sec, disk queues, working
set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
I appreciate any addiional info on things to try.
Thanks,
-pWhat version?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peaboy" <Peaboy@.discussions.microsoft.com> wrote in message
news:96C28CF8-0A0B-4C75-9811-5884A172385E@.microsoft.com...
> This happens very frequently on our server and I can't determine the
> cause.
> The basic issue is that SRs gets into a state where it hangs, you can't
> render reports,you can't even vire proprties, navigate folder etc, so I
> know
> its not extenal data sources.
> One things I tried was disabling Script Blocking which was enabled on our
> antivirus. This is mentioned in this Kb:
> http://support.microsoft.com/kb/295375/en-us
> I also set the IIS Idle rest to 8 hours. But that wasn't the initial
> issue.
> I've been looking at perfmon (thread counts, pages\sec, disk queues,
> working
> set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
> I appreciate any addiional info on things to try.
> Thanks,
> -p|||SQL 2005 w/ latest SPs and fixes.
"Bruce L-C [MVP]" wrote:
> What version?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Peaboy" <Peaboy@.discussions.microsoft.com> wrote in message
> news:96C28CF8-0A0B-4C75-9811-5884A172385E@.microsoft.com...
> > This happens very frequently on our server and I can't determine the
> > cause.
> > The basic issue is that SRs gets into a state where it hangs, you can't
> > render reports,you can't even vire proprties, navigate folder etc, so I
> > know
> > its not extenal data sources.
> >
> > One things I tried was disabling Script Blocking which was enabled on our
> > antivirus. This is mentioned in this Kb:
> > http://support.microsoft.com/kb/295375/en-us
> >
> > I also set the IIS Idle rest to 8 hours. But that wasn't the initial
> > issue.
> >
> > I've been looking at perfmon (thread counts, pages\sec, disk queues,
> > working
> > set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
> >
> > I appreciate any addiional info on things to try.
> >
> > Thanks,
> > -p
>
>