-
Title
Error: "Query execution failed for data set 'MainDataSet'." during timeout for reports in Quest -
Description
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
User: N/A
Computer: SRSSERVERNAME
Description: Event code: 3005 -
Cause
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 -
Resolution
1. Please download the attached zip file which contains three files:
receivetimeout.reg (this will update the receivetimeout value in IE to 36000000 milliseconds - 10 hours but this value can be edited)
sessionTimeout.rss (this will update the three timeout values in SRS to a value specified at the command line)
updatesql.cmd (this will call the rs.exe util to and pass the value 36000 seconds - 10 hours to the sessionTimeout.rss script but you can edit this as well)
a.) You should edit the receivetimeout.reg and updatesql.cmd to suit your desired timeout values and to reflect the name of your SQL server (if not being run on the SQL SRS server itself) and then double-click on the updatesql.cmdb.) If you need to update individual machines running IE you can double-click on the receivetimeout.reg file.
--------------------------------------------------------------------------------
2. Within the IIS settings open the 'Quest Knowledge Portal Application Pool' properties:a.) On the Recycling tab uncheck the recycle worker processes.b.) On the Perfomance tab uncheck the Idle Timeout.c.) Repeat steps (a) and (b) on the 'Report Server' application pool.
-
Attachments
-
Additional Information
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:
<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
<httpRuntime executionTimeout = "9000" />
</system.web>
</configuration>You will need to restart the IIS for this change to commit.