SSRS Report times out
I have a SSRS 2008 report. Unfortunately the stored preceduure on which the report is based takes about 3 minutes to execute. Sometimes, the report will run, other times it will time out. I have even manually adjusted the report settings on Report Manager to 'Do not timeout report execution' and it still times out. Thanks in advance for any asssistance:
October 21st, 2010 2:53pm

This could be mostly because of the time taken by the stored procedure and also the rendereing time of the report. Sometimes the report takes lot of time to render. But there is not much you can do about rendering. So I would suggest you to fix the stored procedure first as 3 minutes is realy huge time. Try to tune it and increase its performance.Dinesh Behera If this post answers your question, please mark it as an Answer.
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 4:57pm

Hi migurelh, The error may be due to the connection to the report server database is time out too. Please try to increase the value for DatabaseQueryTimeout in the rsreportserver.config to check if the issue is solved. For more information about DatabaseQueryTimeout, please see in: http://msdn.microsoft.com/en-us/library/ms157273.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT
October 22nd, 2010 11:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics