Reporting Services Error-URGENT!!!

This is critical. The company I am in runs 3 reports that calculates huge amounts of data and it takes about 45 minutes to run. Unfortunately I get the following error after about 30 minutes. I need to fix this today. No one is cancelling the report it just appears to time out.

Any clue guys?

Reporting Services Error
--

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'DataSet1'. (rsErrorExecutingCommand) Get Online Help
Operation cancelled by user.

Go to the Report Manager and go into site settings. There are settings for report execution timeout.
Hope this helps
-JW

|||thanks that was obvious! I changed it and ran the report again. I will know soon if that fixed it.|||For 2 of the 3 reports that take bout 45 minute to run, changing the timeout setting DID work.

However, the last report takes about one hour to run and the page comes up with an error that says "Page Not Found." I extended the IIS properties for the reporting services to 3 hour for session state and asp script timeout.

Any clues on this one?|||Do you have a timeout set on the query? This is in the dataset properties.

Also, instead of running the report live, try running it and delivering the output to a file share. This will tell you if it is IIS.|||How much of that data is being processed on the server using Stored Procedures and Views? If large datasets are being sent to the client for processing, then the root problem isn't the timeout, it's the design of excessive data processing on the client (in this case Reporting Services is the client) that is likely at fault. This is also one potential situation where analysis services could be used to cache and preprocess the data. Your 45 minute report might be transformed to run in a matter of seconds. An excessively long running report may be the real problem.|||

hi Alex,

how do you solve the rsErrorExecutingCommand error finally? coz i also encounter the same problem as you. appreciate if you could share your solution, thanks

rgds,Catherine

|||

I face the same issue. When a user runs the report himself through http://server/reports and the report runs for more than 60 minutes (1 hour), then , even the execution timeout is set to "NEVER", the report stops exaction in 1 hour with exception:

Exception information example:
Exception type: ReportServerException
Exception message: Execution '3bu40lywe1c3dfuyo4a5in45' cannot be found (rsExecutionNotFound)

The walkaround is to make a subscription that generates this report. For example my report was saved to a server share after 1,5 hours of execution.