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