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

Report hangs on "Report is being generated" screen

I am having issues trying to use a deployed report on our live server.
The report works fine in the development environment - yet when posted to
the live server it seems to work fine but hangs on the "Report is being
generated" screen.
We are still in an evaluation stage of Reporting Services and such are using
the trial version, this is installed on Windows 2003 Server. The report was
developed using Visual Studio 2003 and will be instantiated by an ASP.Net
application. The report is being fired using a
Response.redirect("/ReportServer?%2fReport+Project1%2fReportName&session=" +
Session.SessionID.ToString() + "&rs%3aCommand=Render");
Any suggestions would be greatly appreciated.
Regards
StevenA few questions for you.
- Are you going against the same database when you deploy or a different
one. I.e. could it be a difference is the size of the data you are reporting
against.
- Does this happen when you run the report from Report Manager? If so then
we can disregard the fact it is coming from your app. If it works fine from
the report manager then that tells us a lot too.
- Is your asp.net application on the same server and is it in the same
domain?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"StvPl" <StvPl@.discussions.microsoft.com> wrote in message
news:6290C7CB-C600-41F6-ACE4-ED20D8AD7E45@.microsoft.com...
> I am having issues trying to use a deployed report on our live server.
> The report works fine in the development environment - yet when posted to
> the live server it seems to work fine but hangs on the "Report is being
> generated" screen.
> We are still in an evaluation stage of Reporting Services and such are
using
> the trial version, this is installed on Windows 2003 Server. The report
was
> developed using Visual Studio 2003 and will be instantiated by an ASP.Net
> application. The report is being fired using a
> Response.redirect("/ReportServer?%2fReport+Project1%2fReportName&session="
+
> Session.SessionID.ToString() + "&rs%3aCommand=Render");
> Any suggestions would be greatly appreciated.
> Regards
> Steven
>|||Thanks for your response Bruce.
I've answered your questions below...
> - Are you going against the same database when you deploy or a different
> one. I.e. could it be a difference is the size of the data you are reporting
> against.
It is against the same database and the subset of data retrieved is very
small - perhaps 50 rows.
> - Does this happen when you run the report from Report Manager? If so then
> we can disregard the fact it is coming from your app. If it works fine from
> the report manager then that tells us a lot too.
Works fine from Report Manager.
> - Is your asp.net application on the same server and is it in the same
> domain?
yes.
Thanks for your help
Steven
"Bruce L-C [MVP]" wrote:
> A few questions for you.
> - Are you going against the same database when you deploy or a different
> one. I.e. could it be a difference is the size of the data you are reporting
> against.
> - Does this happen when you run the report from Report Manager? If so then
> we can disregard the fact it is coming from your app. If it works fine from
> the report manager then that tells us a lot too.
> - Is your asp.net application on the same server and is it in the same
> domain?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "StvPl" <StvPl@.discussions.microsoft.com> wrote in message
> news:6290C7CB-C600-41F6-ACE4-ED20D8AD7E45@.microsoft.com...
> > I am having issues trying to use a deployed report on our live server.
> >
> > The report works fine in the development environment - yet when posted to
> > the live server it seems to work fine but hangs on the "Report is being
> > generated" screen.
> >
> > We are still in an evaluation stage of Reporting Services and such are
> using
> > the trial version, this is installed on Windows 2003 Server. The report
> was
> > developed using Visual Studio 2003 and will be instantiated by an ASP.Net
> > application. The report is being fired using a
> > Response.redirect("/ReportServer?%2fReport+Project1%2fReportName&session="
> +
> > Session.SessionID.ToString() + "&rs%3aCommand=Render");
> >
> > Any suggestions would be greatly appreciated.
> >
> > Regards
> > Steven
> >
> >
>
>|||This may be a dumb question, but are you sure that the login you are using
has read permission from the database?
I had a similar symptom when I was testing a deployment. I was using
different login info and forgot to provide access to the database. The
Reporting Services page would come up and I could select a report to run,
but the report would just hang at the generating report stage. Dumb, I know!
Ken
"StvPl" <StvPl@.discussions.microsoft.com> wrote in message
news:6290C7CB-C600-41F6-ACE4-ED20D8AD7E45@.microsoft.com...
> I am having issues trying to use a deployed report on our live server.
> The report works fine in the development environment - yet when posted to
> the live server it seems to work fine but hangs on the "Report is being
> generated" screen.
> We are still in an evaluation stage of Reporting Services and such are
using
> the trial version, this is installed on Windows 2003 Server. The report
was
> developed using Visual Studio 2003 and will be instantiated by an ASP.Net
> application. The report is being fired using a
> Response.redirect("/ReportServer?%2fReport+Project1%2fReportName&session="
+
> Session.SessionID.ToString() + "&rs%3aCommand=Render");
> Any suggestions would be greatly appreciated.
> Regards
> Steven
>|||Thanks for the suggestion Ken.
I've checked the database access and the account specified in the
credentials of the shared data component of the report has full access.
Regards
Steven
"Ken" wrote:
> This may be a dumb question, but are you sure that the login you are using
> has read permission from the database?
> I had a similar symptom when I was testing a deployment. I was using
> different login info and forgot to provide access to the database. The
> Reporting Services page would come up and I could select a report to run,
> but the report would just hang at the generating report stage. Dumb, I know!
> Ken
> "StvPl" <StvPl@.discussions.microsoft.com> wrote in message
> news:6290C7CB-C600-41F6-ACE4-ED20D8AD7E45@.microsoft.com...
> > I am having issues trying to use a deployed report on our live server.
> >
> > The report works fine in the development environment - yet when posted to
> > the live server it seems to work fine but hangs on the "Report is being
> > generated" screen.
> >
> > We are still in an evaluation stage of Reporting Services and such are
> using
> > the trial version, this is installed on Windows 2003 Server. The report
> was
> > developed using Visual Studio 2003 and will be instantiated by an ASP.Net
> > application. The report is being fired using a
> > Response.redirect("/ReportServer?%2fReport+Project1%2fReportName&session="
> +
> > Session.SessionID.ToString() + "&rs%3aCommand=Render");
> >
> > Any suggestions would be greatly appreciated.
> >
> > Regards
> > Steven
> >
> >
>
>

Report hangs 4 CPU server

Forgive my lack of knowledge on SQL here...

We have a SQL server, version 7, that has 4 CPU's. Some of our staff have reports that must be run at random times before cutting checks etc. and these reports bog down the servers CPU's big time, enough so that we can not access the server via Enterprise Manager and at times not even through Query Analyzer. During this time of course other users can not do standard work of saving or accessing the database. Our Processor queue length never seems to go over 1 now. (We recently went from 2 to 4 CPU's do to a 1.4 average queue length).

I have heard that is is possible to limit the number of CPU's that certain query's or events can use. What is the proper terminology for this and can a person do this with limited knowledge? If this can be done during "working hours" so that during off hours query's can use all CPU's, even better.

Thanks,
Mike GilbertYou probably want to think HARD before you do this, but you can set the Max Degree of Parallelism (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_7h9q.asp).

-PatP|||How much ram does this machine have? Is upgrading to SQL2000 an option? What are the processor speeds?|||This is a typical situation, where everyone looks at the DBA for the solution. My gutt feeling would be to run the SQL Profilier, capture the query and do an analysis of the Query. Before thinking about changing the SQL Server HW set up, make sure that you do the following:
1. Test the Query running for the report
2. Run update Stats
3. Recompile the Query
4. Check for the Locks

Also how Big is your databases?

Report Hangs - Security Issue?

Iâ'm running SQL Server 2005 with Reporting Services. I have developed a
number of reports that use data from a fairly obscure financial package that
we use. The data sits on a Unix server and is pulled into SRSS using an ODBC
driver. When the connection to the data is made PowerTCP launches
(www.dart.com). I had deployed a number of these reports and they were
working but no longer work from the Report Manager either on a remote
computer or on the server logged on as the Administrator. The reports still
function in the preview window of the Visual Studio environment. I initially
thought that it could have something to do with the enhanced DCOM security
with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I guess it
may be worth a try. I canâ't definitively pin down a time frame as to when
the reports stopped working (i.e. pre or post SP1). I have combed all the
log files I can think of, but havenâ't discovered anything. One interesting
note is that when I launch the report the server beeps once and then the
report never comes up, it just sits there. I am at my witâ's end so if
someone can shed some light on this I would appreciate it.
Thanks in advance.I don't quite understand but one thing you could try is to add the site to
the safe list in 2003 Server. SP1 locks down accessing other servers unless
they are part of the safe list.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
> I'm running SQL Server 2005 with Reporting Services. I have developed a
> number of reports that use data from a fairly obscure financial package
> that
> we use. The data sits on a Unix server and is pulled into SRSS using an
> ODBC
> driver. When the connection to the data is made PowerTCP launches
> (www.dart.com). I had deployed a number of these reports and they were
> working but no longer work from the Report Manager either on a remote
> computer or on the server logged on as the Administrator. The reports
> still
> function in the preview window of the Visual Studio environment. I
> initially
> thought that it could have something to do with the enhanced DCOM security
> with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I guess
> it
> may be worth a try. I can't definitively pin down a time frame as to when
> the reports stopped working (i.e. pre or post SP1). I have combed all the
> log files I can think of, but haven't discovered anything. One
> interesting
> note is that when I launch the report the server beeps once and then the
> report never comes up, it just sits there. I am at my wit's end so if
> someone can shed some light on this I would appreciate it.
> Thanks in advance.
>|||To clarify, I think the way it works is that when the ODBC driver goes out to
grab data it lauches PowerTCP which establishes a connection to the Unix
server and allows for the data transfer.
Is the safe list you are talking about in Internet Explorer sites? Where do
I configure the safe list you are talking about?
"Bruce L-C [MVP]" wrote:
> I don't quite understand but one thing you could try is to add the site to
> the safe list in 2003 Server. SP1 locks down accessing other servers unless
> they are part of the safe list.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
> > I'm running SQL Server 2005 with Reporting Services. I have developed a
> > number of reports that use data from a fairly obscure financial package
> > that
> > we use. The data sits on a Unix server and is pulled into SRSS using an
> > ODBC
> > driver. When the connection to the data is made PowerTCP launches
> > (www.dart.com). I had deployed a number of these reports and they were
> > working but no longer work from the Report Manager either on a remote
> > computer or on the server logged on as the Administrator. The reports
> > still
> > function in the preview window of the Visual Studio environment. I
> > initially
> > thought that it could have something to do with the enhanced DCOM security
> > with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I guess
> > it
> > may be worth a try. I can't definitively pin down a time frame as to when
> > the reports stopped working (i.e. pre or post SP1). I have combed all the
> > log files I can think of, but haven't discovered anything. One
> > interesting
> > note is that when I launch the report the server beeps once and then the
> > report never comes up, it just sits there. I am at my wit's end so if
> > someone can shed some light on this I would appreciate it.
> >
> > Thanks in advance.
> >
>
>|||Yes, it is in IE, Tools, Security tab, Safe Sites
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:396E5C0F-470A-4A7C-A73A-894C4C57164E@.microsoft.com...
> To clarify, I think the way it works is that when the ODBC driver goes out
> to
> grab data it lauches PowerTCP which establishes a connection to the Unix
> server and allows for the data transfer.
> Is the safe list you are talking about in Internet Explorer sites? Where
> do
> I configure the safe list you are talking about?
> "Bruce L-C [MVP]" wrote:
>> I don't quite understand but one thing you could try is to add the site
>> to
>> the safe list in 2003 Server. SP1 locks down accessing other servers
>> unless
>> they are part of the safe list.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rob" <Rob@.discussions.microsoft.com> wrote in message
>> news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
>> > I'm running SQL Server 2005 with Reporting Services. I have developed
>> > a
>> > number of reports that use data from a fairly obscure financial package
>> > that
>> > we use. The data sits on a Unix server and is pulled into SRSS using
>> > an
>> > ODBC
>> > driver. When the connection to the data is made PowerTCP launches
>> > (www.dart.com). I had deployed a number of these reports and they were
>> > working but no longer work from the Report Manager either on a remote
>> > computer or on the server logged on as the Administrator. The reports
>> > still
>> > function in the preview window of the Visual Studio environment. I
>> > initially
>> > thought that it could have something to do with the enhanced DCOM
>> > security
>> > with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I
>> > guess
>> > it
>> > may be worth a try. I can't definitively pin down a time frame as to
>> > when
>> > the reports stopped working (i.e. pre or post SP1). I have combed all
>> > the
>> > log files I can think of, but haven't discovered anything. One
>> > interesting
>> > note is that when I launch the report the server beeps once and then
>> > the
>> > report never comes up, it just sits there. I am at my wit's end so if
>> > someone can shed some light on this I would appreciate it.
>> >
>> > Thanks in advance.
>> >
>>|||Thanks for your efforts, but I still can't get it working. I'll have to find
a work around.
"Bruce L-C [MVP]" wrote:
> Yes, it is in IE, Tools, Security tab, Safe Sites
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:396E5C0F-470A-4A7C-A73A-894C4C57164E@.microsoft.com...
> > To clarify, I think the way it works is that when the ODBC driver goes out
> > to
> > grab data it lauches PowerTCP which establishes a connection to the Unix
> > server and allows for the data transfer.
> >
> > Is the safe list you are talking about in Internet Explorer sites? Where
> > do
> > I configure the safe list you are talking about?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> I don't quite understand but one thing you could try is to add the site
> >> to
> >> the safe list in 2003 Server. SP1 locks down accessing other servers
> >> unless
> >> they are part of the safe list.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> >> news:8B537B1B-D382-44FD-928B-FD525BB0C920@.microsoft.com...
> >> > I'm running SQL Server 2005 with Reporting Services. I have developed
> >> > a
> >> > number of reports that use data from a fairly obscure financial package
> >> > that
> >> > we use. The data sits on a Unix server and is pulled into SRSS using
> >> > an
> >> > ODBC
> >> > driver. When the connection to the data is made PowerTCP launches
> >> > (www.dart.com). I had deployed a number of these reports and they were
> >> > working but no longer work from the Report Manager either on a remote
> >> > computer or on the server logged on as the Administrator. The reports
> >> > still
> >> > function in the preview window of the Visual Studio environment. I
> >> > initially
> >> > thought that it could have something to do with the enhanced DCOM
> >> > security
> >> > with Window Server 2003 SP1. I am hesitant to uninstall SP1, but I
> >> > guess
> >> > it
> >> > may be worth a try. I can't definitively pin down a time frame as to
> >> > when
> >> > the reports stopped working (i.e. pre or post SP1). I have combed all
> >> > the
> >> > log files I can think of, but haven't discovered anything. One
> >> > interesting
> >> > note is that when I launch the report the server beeps once and then
> >> > the
> >> > report never comes up, it just sits there. I am at my wit's end so if
> >> > someone can shed some light on this I would appreciate it.
> >> >
> >> > Thanks in advance.
> >> >
> >>
> >>
> >>
>
>

Report Hangs

I am running SQL Server 2005 Reporting Services. I have a report that runs
with an Access database as the data source. Occasionally the report will
hang at the "Report is being generated" screen. The screen never times out
even if left for hours. Once one job fails any other attempts to run this
report hang too. I can't find anything useful in any of the logs. FYI,
this report runs successfully most of the time.
How can I purge pending or running jobs from the queue? Does anyone have
any suggestions on what the problem may be? Is there anyway for me to force
a timeout on a report run?
Thanks in advance for any help you can provide.On Jun 6, 11:04 am, Rob <R...@.discussions.microsoft.com> wrote:
> I am running SQL Server 2005 Reporting Services. I have a report that runs
> with an Access database as the data source. Occasionally the report will
> hang at the "Report is being generated" screen. The screen never times out
> even if left for hours. Once one job fails any other attempts to run this
> report hang too. I can't find anything useful in any of the logs. FYI,
> this report runs successfully most of the time.
> How can I purge pending or running jobs from the queue? Does anyone have
> any suggestions on what the problem may be? Is there anyway for me to force
> a timeout on a report run?
> Thanks in advance for any help you can provide.
The only things I can think of are to either kill the rs.exe process
in the task mgr -or- to reset IIS (via: 'iisreset' at the command
prompt). As far as why this happens, I am not sure; though I would
think that it could be related to high demand on the database or
possibly IIS or rs.exe choking up. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant