Tuesday, February 21, 2012

Report get time out.

Hi all,
I am facing a problem of report time out for some of the my reports.The
report seems to be taking too long and then times out.But when the new
browser is opened immediately after the report comes in minutes. And the if
I close the browser before it's get timed out and open the new browser for
the same report it again comes out quickly. Can anybody tell me why it is
so.
SandeepSounds like your report query is taking a long time, and is timing out
on the database side. Running the report a second time may be taking
advantage of the fact that your data was loaded into memory the first
time your database query ran. This would make it run much faster the
second time, but wouldn't actually have anything to do with Reporting
Services.
Might I suggest you try manually running your query with sample
parameters? If you see the same behavior in Query Analyzer, then
double-check what your query is doing because it isn't Reporting
Services. (If the query is always very fast in Query Analyzer, then
you've got a much more interesting problem!)
Ted

No comments:

Post a Comment