Share via

Assistance with report deployment errors/issues

Tony Strother 171 Reputation points
2020-11-25T18:28:26.563+00:00

I am getting this alert in SCOM 2019 using SSRS 2016 for Reporting. I cannot seem to find a solution for this, would greatly appreciate assistance:
Data Warehouse failed to deploy reports for a management pack to SQL Reporting Services Server. Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried.

Exception 'DeploymentException': Failed to deploy reports for management pack with version dependent id 'd62b23ec-5c08-1591-aee2-a800b167732c'. Failed to deploy report 'SystemCenter.Operations.Manager.Health.Check.Report.Library.Report.Misc.OMSManaged'. AdjustDataSources: Exception <ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsInvalidParameter</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">The value of parameter 'DataSources' is not valid.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">https://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsInvalidParameter&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=13.0.4259.0</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">13.0.4259.0</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsInvalidParameter" msrs:HelpLink="https://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsInvalidParameter&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=13.0.4259.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">The value of parameter 'DataSources' is not valid.</Message></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" />

Thanks,
TS

System Center Operations Manager
System Center Operations Manager

A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Tony Strother 171 Reputation points
    2020-11-25T19:11:10.923+00:00

    Thank you Leon, both of those refer to SSRS 2017, I am using SSRS 2016, the option mentioned in the articles is not present in SSRS 2016.

    Was this answer helpful?


  2. Leon Laude 86,201 Reputation points
    2020-11-25T18:54:07.857+00:00

    Hi @Tony Strother ,

    I have written a blog post about the "Failed to deploy reporting component to the SQL Server Reporting Services server" over here:
    https://thesystemcenterblog.com/2020/03/31/scom-2019-installation-reports-fail-to-deploy-fix

    This is also on Kevin's blog post about installing SCOM 2019, under the Known Issues (#3) section:
    https://kevinholman.com/2019/03/14/scom-2019-quickstart-deployment-guide

    ----------

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Best regards,
    Leon

    Was this answer helpful?

    0 comments No comments

Your answer

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