How can timeout values be changed within SQL Reporting Services? These timeouts show up when using the Quest (InTrust) Knowledge Portal.
When timeouts happen you may see the following errors during report generation.
"An error has occurred during report processing. Query execution failed for data set 'MainDataSet'. A severe error occurred on the current command. The results, if any, should be discarded. Operation cancelled by user.(rsProcessingAborted)" or the following in the Application log of your SRS server
Event Type: Warning Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 11/30/2006 Time: 2:33:40 PM
Description: Event code: 3005
Both SQL Reporting Services (SRS) and the Internet Explorer web browser have built in timeout values which may cause certain reports to fail to generate as part of an reporting job and interactive.
More information can be found at the following link http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
1. Please download the attached zip file which contains three files:
On Quest Knowledge Portal 1.0 (InTrust 9.6) and 1.1 (InTrust 10.0) also extend the http execution timeout by editing the web.config file located in 'C:\Program Files\Quest Software\Knowledge Portal\'.
Add the line <httpRuntime executionTimeout = "9000" /> near the end of the web.config file as shown below: