Share via

ConfigMgr (SCCM) – SQL Server Reporting Service (SSRS) – Error Timeout Expired

  • Article

Recently, I was working on SQL server Reporting Service issue and I thought of documenting it so that (may be http://s0.wp.com/wp-includes/images/smilies/icon_smile.gif?m=1308974810g ) it will helpful to someone !!!

Latest Updated Link - http://anoopcnair.com/2011/07/20/configmgr-sccm-sql-server-reporting-service-timeout-expired/

See, the error message

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘DataSet3′. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

http://anoopmannur.files.wordpress.com/2011/07/snap221.jpg?w=600&h=154

Logged into SQL server and ran the same report from the server as per the below note on the on the error “For more information about this error navigate to the report server on the local server machine“

I ran the same report from SQL server and the error got more clear now http://s0.wp.com/wp-includes/images/smilies/icon_smile.gif?m=1308974810g

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘DataSet3′. (rsErrorExecutingCommand)
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

Tried to change “Site Setting” in the SSRS web portal as mentioned below but that didn’t help.

http://anoopmannur.files.wordpress.com/2011/07/snap23.jpg?w=600&h=349

Launched the console and navigated through Reporting -> Reporting Services -> \Servername -> All reports – > Properties of “Software 02D – Computers with a specific software product”

http://anoopmannur.files.wordpress.com/2011/07/snap24.jpg?w=600

As the error was pointing to “DataSet3″ so change the timeout option of “DataSet3” from 30 to 1800.

http://anoopmannur.files.wordpress.com/2011/07/snap251.jpg?w=600

And that is it !!! The issue resolved !!!

http://anoopmannur.files.wordpress.com/2011/07/snap26.jpg?w=600&h=317