SQL 2005 Reporting Service timeout problem
Hi All, Just create a report on SQL 2005 reporting services, it works fine if I run the query on management studio. When I run it on reporting manager (IIS), the report showing error "Query execution failed for data set... timeout expired". The error is obviously about the query execution timeout, so I configure the timeout setting on reporting manager , site setting -> do not timeout or go to the report -> properties -> does not timeout. Unfortunately, both of them doesn't works. Please help. Many thanks
November 23rd, 2010 9:45am

Hi terryhkx123, You can configure timeout in SSRS designer on the data source properties (when you click dataset [datasetName]...). You need to run a profiler or get execution plan for youe t-sql/stored procedure to make sure all indexes in place. Also, use nolocks in t-sql if a report is based on non-volatile data. Sergei
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 7:32pm

Hi terry, From the error message, the issue is caused because the query execution timeout. So, it does not help by configuring the report execution timeout, rather, we should reset a bigger value for the report dataset timeout. Open the report dataset Properties and type a proper value in the timeout textbox. In Timeout, type the number of seconds that the report server waits for a response from the database. The default value is 30 seconds. Timeout must contain a value greater than zero or be left empty. If it is empty, the query does not time out. see http://msdn.microsoft.com/en-us/library/ms160345(v=SQL.90).aspx for more details on setting timeout value for a report dataset. thanks, Jerry
November 25th, 2010 3:42am

I would start looking at the query trying to optimize itBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
November 25th, 2010 3:45am

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

Other recent topics Other recent topics