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