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 ?

 

 

solved 0
Samer Al Kari 2022-03-19T14:22:14+05:30 2 Answers 33 views Beginner 0

Answers ( 2 )

    0
    2022-03-19T15:16:46+05:30

    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.

  1. 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/

    Best answer

Leave an answer

Sorry, you do not have a permission to answer to this question .