Event ID 31567 - Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried. SQL 2019, SSRS 2019

anthony strother 411 Reputation points
2021-06-04T22:46:39.35+00:00

Evening, I am seeing this issue consistently.
Environment:
Windows Server 2019, SCOM 2019 UR3 - 2 management servers
Windows Server 2019, SQL 2019, v15.0.4123.1 RTM CU10
Windows Server 2019, SSRS2019, v15.0.1102.897

Started seeing the issue shortly after I finished installing everything, let it sit for a couple of day.

Event ID: 31567
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&EvtSrc=Microsoft.ReportingServices.Exceptions.ErrorStrings&EvtID=rsInvalidParameter&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=15.0.1102.897</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">15.0.1102.897</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&EvtSrc=Microsoft.ReportingServices.Exceptions.ErrorStrings&EvtID=rsInvalidParameter&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=15.0.1102.897" 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" />

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report
Instance name: Data Warehouse Synchronization Service
Instance ID: {D93D6C9D-7BBE-1C97-6401-022459DE9BAB}

Thanks in advance for your time and assistance.

Operations Manager
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.
1,467 questions
{count} votes

2 answers

Sort by: Most helpful
  1. CyrAz 5,181 Reputation points
    2021-06-05T23:04:14.42+00:00

    That report comes from the Health Check Report MP, which requires some configuration (especially for the report Datasource).
    Read documentation here : https://github.com/pzerger/scomhealthcheck/blob/master/Health%20Check%20MP%20Setup%20Guide.pdf

    1 person found this answer helpful.
    0 comments No comments

  2. SChalakov 10,376 Reputation points MVP
    2021-06-06T20:40:25.67+00:00

    Hi Tony (@anthony strother ),

    did you already enable the propagation of all report extensions like described here:

    Reports are missing in SCOM – Event ID 31567

    Operations Manager 2019 and 1807 reports fail to deploy

    and here:

    SCOM 2019 installation – Reports fail to deploy [FIX]
    https://thesystemcenterblog.wordpress.com/2020/03/31/scom-2019-installation-reports-fail-to-deploy-fix/

    ----------

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

    Best Regards,
    Stoyan

    1 person found this answer helpful.
    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.