"There is an error in xml document" when running SCCM report

Skip B 91 Reputation points
2023-03-07T15:37:10.64+00:00

Out of the blue a handful of SCCM reports started throwing an error. These are related to software installed on clients and are supposed to provide a dropdown menu to choose software titles from. Reports that ask the user to type in a name are not affected. Furthermore, the reports that are having a problem when run from the SCCM console work fine if I run them in a browser connected the SQL Reporting Service - http://<reporting services server>/Reports.

The error is:

There is an error in XML document (1, 498284).


Microsoft.ConfigurationManagement.ManagementProvider.SmsException

There is an error in XML document (1, 498284).

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.InvalidOperationException

There is an error in XML document (1, 498284).

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.Xml.XmlException

'', hexadecimal value 0x01, is an invalid character. Line 1, position 498284.

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)


Everything I've read indicates a non-standard character somewhere. Where do I look?

Skip

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,042 questions
Microsoft Configuration Manager
{count} votes

2 answers

Sort by: Most helpful
  1. CherryZhang-MSFT 6,491 Reputation points
    2023-03-08T07:07:55.2333333+00:00

    Hi @Skip B

    1, What is the SSRS version you are using?

    2, What software are you installed? Is there any step-by-step guide for our reference?

    3, Please help upload following links for our reference:

      1. srsrp.log(Site system server)
    • SQL server reporting services log(C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles)

    Looking forward to your feedback.

    Best regards,
    Cherry


  2. Garth 5,801 Reputation points
    2023-03-08T10:22:26.7866667+00:00

    Please provide an example report that is having problem. E.g. The name of the report that others can review their copy within their environment.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.