Report page hanging in browser

Hi all,
using SQL2000 sp4
How can I see why a report is not loading in browser.
Just hangs with hour glass. not even the paremeter input fields are loading?
I haven't even clicked view report?
other reports are fine.
thanks,
gvOn Apr 26, 1:37 pm, "gv" <viator.ge...@.gmail.com> wrote:
> Hi all,
> using SQL2000 sp4
> How can I see why a report is not loading in browser.
> Just hangs with hour glass. not even the paremeter input fields are loading?
> I haven't even clicked view report?
> other reports are fine.
> thanks,
> gv
Do you have default(s) on your report parameter(s) set to query? It
sounds like the report parameter'(s) dataset/query is hanging. How
complex is the query for the report parameters? Also, make sure that
you do not have Auto-refresh set on the report (via Layout tab ->
Report drop-down -> Report Properties... -> General tab) or set too
frequently. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks! I will look at what you suggested.
gv
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1177639744.633440.121190@.n35g2000prd.googlegroups.com...
> On Apr 26, 1:37 pm, "gv" <viator.ge...@.gmail.com> wrote:
>> Hi all,
>> using SQL2000 sp4
>> How can I see why a report is not loading in browser.
>> Just hangs with hour glass. not even the paremeter input fields are
>> loading?
>> I haven't even clicked view report?
>> other reports are fine.
>> thanks,
>> gv
>
> Do you have default(s) on your report parameter(s) set to query? It
> sounds like the report parameter'(s) dataset/query is hanging. How
> complex is the query for the report parameters? Also, make sure that
> you do not have Auto-refresh set on the report (via Layout tab ->
> Report drop-down -> Report Properties... -> General tab) or set too
> frequently. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

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.
> >
>
>