Report Manager Hanging when executing reports

We are experiencing an ongoing problem with our reports. Executing reports
in Report Manager intermittently hangs. The issue is 100% consistent with a
failure of embedded bitmaps to show up in the report - that is, when the
bitmaps don't show up, you know the report will be in a hung state. Clicking
plus sign to expand node does nothing, nor do embedded hyperlinks work. The
only solution is to exit to the parent folder node and regenerate the entire
report. Report server logs show no errors (though there is an INFO log trace
about the show/hide toggle - INFO: Item not cacheable: - ShowHideToggle
/TestReport). The report is executing against a join of complicated database
views, but is generally returning a low volume of data (couple hundred rows
or so). The reports work fine, except for this intermittent condition.
Obviously the obvious question is why does this occur? And why only
intermittently? Any suggestions on how to perhaps troubleshoot this would be
greatly appreciated. This installation is on SQL SP3a and Windows 2000 SP4.
I can easily provide other supporting details if needed.What is the size of the parameters (query string) -in bytes. If it is above
4K, HTML4.0 rendering will fail, event if you POST to the report server.-
Microsoft's bug.
"BootieNH" <BootieNH@.discussions.microsoft.com> wrote in message
news:217B64CC-04B9-4039-8401-4FB49D73D205@.microsoft.com...
> We are experiencing an ongoing problem with our reports. Executing
> reports
> in Report Manager intermittently hangs. The issue is 100% consistent with
> a
> failure of embedded bitmaps to show up in the report - that is, when the
> bitmaps don't show up, you know the report will be in a hung state.
> Clicking
> plus sign to expand node does nothing, nor do embedded hyperlinks work.
> The
> only solution is to exit to the parent folder node and regenerate the
> entire
> report. Report server logs show no errors (though there is an INFO log
> trace
> about the show/hide toggle - INFO: Item not cacheable: - ShowHideToggle
> /TestReport). The report is executing against a join of complicated
> database
> views, but is generally returning a low volume of data (couple hundred
> rows
> or so). The reports work fine, except for this intermittent condition.
> Obviously the obvious question is why does this occur? And why only
> intermittently? Any suggestions on how to perhaps troubleshoot this would
> be
> greatly appreciated. This installation is on SQL SP3a and Windows 2000
> SP4.
> I can easily provide other supporting details if needed.
>|||How do I tell? I'm pretty sure I'm well under that, I'm passing only 6
parameters, simple short strings.
"Oleg Yevteyev" wrote:
> What is the size of the parameters (query string) -in bytes. If it is above
> 4K, HTML4.0 rendering will fail, event if you POST to the report server.-
> Microsoft's bug.
> "BootieNH" <BootieNH@.discussions.microsoft.com> wrote in message
> news:217B64CC-04B9-4039-8401-4FB49D73D205@.microsoft.com...
> > We are experiencing an ongoing problem with our reports. Executing
> > reports
> > in Report Manager intermittently hangs. The issue is 100% consistent with
> > a
> > failure of embedded bitmaps to show up in the report - that is, when the
> > bitmaps don't show up, you know the report will be in a hung state.
> > Clicking
> > plus sign to expand node does nothing, nor do embedded hyperlinks work.
> > The
> > only solution is to exit to the parent folder node and regenerate the
> > entire
> > report. Report server logs show no errors (though there is an INFO log
> > trace
> > about the show/hide toggle - INFO: Item not cacheable: - ShowHideToggle
> > /TestReport). The report is executing against a join of complicated
> > database
> > views, but is generally returning a low volume of data (couple hundred
> > rows
> > or so). The reports work fine, except for this intermittent condition.
> > Obviously the obvious question is why does this occur? And why only
> > intermittently? Any suggestions on how to perhaps troubleshoot this would
> > be
> > greatly appreciated. This installation is on SQL SP3a and Windows 2000
> > SP4.
> > I can easily provide other supporting details if needed.
> >
>
>