| Groups | Blog | Home |
sql server reporting services : Reports don't finish
We are experiencing an issue that leaves us confused. We have a variety of
reports that are run by a variety of people and for the most part, they run without any trouble. Every now and then we’ll get a report that we expect to complete within a matter of seconds (let’s say up to 20 seconds) and it never completes (we see ‘Report is being rendered’ and the spinning icon in Report Manager). Eventually, we’ll see an entry in the ExecutionLog table with a Status of rsReportTimeoutExpired or rsProcessingAborted and we’ll see column values of 0, some very big number, and 0 for TimeDataRetreival, TimeProcessing, and TimeRendering respectively. If we try to run the report again, it more often then not fails again. If I try to run the stored procedure behind the report it completes in a matter of seconds as expected. It’s as if the report tries to get the data and some how get’s hung up or gives up. As far as anything unique goes in our environment, we do have a DPE and I always suspect that my work (the DPE) is at fault; however, when this problem appears there are also a lot of other reports run in the same time proximity, both more complex and simple that run just fine. Are there any suggestions that someone can make that would allow me to further pinpoint this problem?
Hello,
Any solution for your problem. I am also facing same problem. But we do not have DPE. Thanks, Atul [quoted text, click to view] "Herman K" wrote:
> We are experiencing an issue that leaves us confused. We have a variety of > reports that are run by a variety of people and for the most part, they run > without any trouble. Every now and then we’ll get a report that we expect to > complete within a matter of seconds (let’s say up to 20 seconds) and it never > completes (we see ‘Report is being rendered’ and the spinning icon in Report > Manager). Eventually, we’ll see an entry in the ExecutionLog table with a > Status of rsReportTimeoutExpired or rsProcessingAborted and we’ll see column > values of 0, some very big number, and 0 for TimeDataRetreival, > TimeProcessing, and TimeRendering respectively. If we try to run the report > again, it more often then not fails again. If I try to run the stored > procedure behind the report it completes in a matter of seconds as expected. > > It’s as if the report tries to get the data and some how get’s hung up or > gives up. As far as anything unique goes in our environment, we do have a > DPE and I always suspect that my work (the DPE) is at fault; however, when > this problem appears there are also a lot of other reports run in the same > time proximity, both more complex and simple that run just fine. > > Are there any suggestions that someone can make that would allow me to > further pinpoint this problem?
Hi Herman,
We are also facing similar problem with the reports.We are generating reports asynchronously.The reports are getting timed out.We are calling the reporting services from our VB.Net code through Reportservicemanager class.We are getting a "System.Net.WebException: The operation has timed-out." messsage in our logs.We still could not solve the problem. We really apperciate your help if you have solved the problem in your side. [quoted text, click to view] "Herman K" wrote:
> We are experiencing an issue that leaves us confused. We have a variety of > reports that are run by a variety of people and for the most part, they run > without any trouble. Every now and then we’ll get a report that we expect to > complete within a matter of seconds (let’s say up to 20 seconds) and it never > completes (we see ‘Report is being rendered’ and the spinning icon in Report > Manager). Eventually, we’ll see an entry in the ExecutionLog table with a > Status of rsReportTimeoutExpired or rsProcessingAborted and we’ll see column > values of 0, some very big number, and 0 for TimeDataRetreival, > TimeProcessing, and TimeRendering respectively. If we try to run the report > again, it more often then not fails again. If I try to run the stored > procedure behind the report it completes in a matter of seconds as expected. > > It’s as if the report tries to get the data and some how get’s hung up or > gives up. As far as anything unique goes in our environment, we do have a > DPE and I always suspect that my work (the DPE) is at fault; however, when > this problem appears there are also a lot of other reports run in the same > time proximity, both more complex and simple that run just fine. > > Are there any suggestions that someone can make that would allow me to > further pinpoint this problem?
I am also having the same issue.
Has anyone solved this issue? Thanks. [quoted text, click to view] "Herman K" wrote:
> We are experiencing an issue that leaves us confused. We have a variety of > reports that are run by a variety of people and for the most part, they run > without any trouble. Every now and then we’ll get a report that we expect to > complete within a matter of seconds (let’s say up to 20 seconds) and it never > completes (we see ‘Report is being rendered’ and the spinning icon in Report > Manager). Eventually, we’ll see an entry in the ExecutionLog table with a > Status of rsReportTimeoutExpired or rsProcessingAborted and we’ll see column > values of 0, some very big number, and 0 for TimeDataRetreival, > TimeProcessing, and TimeRendering respectively. If we try to run the report > again, it more often then not fails again. If I try to run the stored > procedure behind the report it completes in a matter of seconds as expected. > > It’s as if the report tries to get the data and some how get’s hung up or > gives up. As far as anything unique goes in our environment, we do have a > DPE and I always suspect that my work (the DPE) is at fault; however, when > this problem appears there are also a lot of other reports run in the same > time proximity, both more complex and simple that run just fine. > > Are there any suggestions that someone can make that would allow me to > further pinpoint this problem?
[quoted text, click to view]
On Apr 30, 4:12 pm, Al <A...@discussions.microsoft.com> wrote: > I am also having the same issue. > Has anyone solved this issue? > Thanks. > > "Herman K" wrote: > > We are experiencing an issue that leaves us confused. We have a variety of > > reports that are run by a variety of people and for the most part, they run > > without any trouble. Every now and then we'll get a report that we expect to > > complete within a matter of seconds (let's say up to 20 seconds) and it never > > completes (we see 'Report is being rendered' and the spinning icon in Report > > Manager). Eventually, we'll see an entry in the ExecutionLog table with a > > Status of rsReportTimeoutExpired or rsProcessingAborted and we'll see column > > values of 0, some very big number, and 0 for TimeDataRetreival, > > TimeProcessing, and TimeRendering respectively. If we try to run the report > > again, it more often then not fails again. If I try to run the stored > > procedure behind the report it completes in a matter of seconds as expected. > > > It's as if the report tries to get the data and some how get's hung up or > > gives up. As far as anything unique goes in our environment, we do have a > > DPE and I always suspect that my work (the DPE) is at fault; however, when > > this problem appears there are also a lot of other reports run in the same > > time proximity, both more complex and simple that run just fine. > > > Are there any suggestions that someone can make that would allow me to > > further pinpoint this problem? You can try expanding the timeout value (individual report properties) for the report in the Report Server (which may temporarily resolve the problem). It sounds like the stored procedure/query needs to be tuned for performance improvement (via the Database Engine Tuning Advisor). Also, I would suggest being conservative w/multiple datasets in the same report. It seems to be related to query performance in my opinion. Hope this helps. Regards, Enrique Martinez Sr. Software Consultant
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |