How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr. I recently worked on a SQL Server Reporting Service issue, and I thought of documenting it so that (maybe :)) it will be helpful for someone !!!
- Fix Report Server Cannot Open A Connection Error ConfigMgr | SCCM HTMD Blog (anoopcnair.com)
- Free SCCM Training 37 Hours Of Latest Technical Content Lab Setup HTMD Blog (anoopcnair.com)
| Index |
|---|
| How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr |
How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr
See the error message. How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr.
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
I logged into the SQL server and ran the same report from the server as per the below note 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 the SQL server, and the error is more explicit now.
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘DataSet3’. (rsErrorExecutingCommand)
Timeout expired. The timeout period elapsed before completion of the operation or the server is not responding
As mentioned below, I tried to change “Site Setting” in the SSRS web portal, but that didn’t help.
Launched the console and navigated through Reporting -> Reporting Services -> \\Servername -> All reports – > Properties of “Software 02D – Computers with a specific software product.”
As the error was pointing to “DataSet3” change the timeout option of “DataSet3” from 30 to 1800.
And that is it !!! The issue is resolved !!!
We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.
Author
Anoop C Nair has been Microsoft MVP from 2015 onwards for 10 consecutive years! He is a Workplace Solution Architect with more than 22+ years of experience in Workplace technologies. He is also a Blogger, Speaker, and leader of the Local User Group Community. His main focus is on Device Management technologies like SCCM and Intune. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security, Career, etc..
which console are you talking about? can’t find any console for reporting services exept for reporting services configuration manager.
I am running sql 2005 and I’m facing the same issue.
thanx
Hi ! – I was talking about SCCM Console.
I assume this is in SCCM 2007 as I can’t find mentioned tools in SCCM 2012 console, any hints how to achieve the same in SCCM 2012?