SCCM Reports
Question
I have a weird issue related to SCCM reports.
When clicking on one of the SCCM reports (like Compliance 1 – over all compliance), getting an error:
(
An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source ‘AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_’. —> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
——————————-
Microsoft.ConfigurationManagement.ManagementProvider.SmsException
An error has occurred during report processing.
Stack Trace:
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
——————————-
System.Web.Services.Protocols.SoapException
An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source ‘AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_’. —> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
Stack Trace:
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
)
but the thing is, when trying for the 2nd attempt for the same report, it work just fine, any thoughts ?
Answers ( 2 )
Thanks for the reply.
All as described in the troubleshooting blogs, The Funny part is it through an error on the 1st attempt, but works just fine on the 2nd attempts.
I try to launch SQL Server Reporting Services Configuration Manager from the Start menu of SQL Server and check whether all the services are OK.
You can also check the connectivity is ok or not.
I have two SSRS troubleshooting posts that might help you here.
https://www.anoopcnair.com/fix-sccm-report-server-cannot-open-configmgr/
https://www.anoopcnair.com/reporting-server-ssrs-issues-configmgr/