Export (0) Print
Expand All

Setting Time-out Values for Report Execution

You can specify time-out values to set limits on how system resources are used. Report server supports two time-out values:

  • A query time-out value is the number of seconds that the report server waits for a response from the database. This value is defined in a report.
  • A report execution time-out value is the maximum number of seconds that report processing can continue before it is stopped. This value is defined at the system level. You can vary this setting for individual reports.

Most time-out errors occur during query processing. If you are encountering time-out errors, try increasing the query time-out value. Make sure to adjust the report execution time-out value so that it is larger than the query time-out. The time period should be sufficient to complete both query and report processing.

Query time-out values are specified during report authoring when you define a dataset. The time-out value is stored with the report, in the Timeout element of the report definition. By default, this value is set to 30 seconds. For more information, see How to: Create a Dataset (Report Designer).

Users who have permission to modify the properties of a published report can reset this value by editing the report definition file. For more information about modifying the report definition of a published report, see Adding, Modifying, and Deleting Reports.

You can also specify a query time-out value for data-driven subscriptions. The query time-out value is specified in the Data-Driven Subscription pages. The value you specify determines how long the report server waits for query processing to complete when retrieving data from the subscriber data source.

You can set the report execution time-out value to limit the amount of time that a report server uses to process a report. Report execution time-out values can be specified in Report Manager. You can set a default value for all reports in the Site Settings page, and then override that value in the Execution properties page for a specific report. By default, the value is set to 1800 seconds. For more information, see Setting Report Execution Properties.

The report server evaluates running jobs at 60 second intervals. At each 60 second interval, the report server compares actual process time against the report execution time-out value. If the processing time for a report exceeds the report execution time-out value, report processing will stop.

Note that if you specify a time-out value that is smaller than 60 seconds, the report may execute in full if processing starts and completes during the quiet part of the cycle when the report server is not evaluating running jobs. For example, if you set a time-out value of 10 seconds for a report that takes 20 seconds to run, the report will process in full if report execution starts early in the 60 second cycle.

ms155782.note(en-US,SQL.90).gifNote:
You can set the RunningRequestsDbCycle setting in the RSReportServer.config file to change the frequency of how often running jobs are evaluated.

Community Additions

ADD
Show:
© 2014 Microsoft