question

anthonypstrother-8017 avatar image
0 Votes"
anthonypstrother-8017 asked XinGuo-MSFT commented

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

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&amp;EvtSrc=Microsoft.ReportingServices.Exceptions.ErrorStrings&amp;EvtID=rsInvalidParameter&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;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&amp;EvtSrc=Microsoft.ReportingServices.Exceptions.ErrorStrings&amp;EvtID=rsInvalidParameter&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;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.

msc-operations-manager
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Does the reply of CyrAz or Stoyan help? Is the problem solved now?

0 Votes 0 ·
StoyanChalakov avatar image
1 Vote"
StoyanChalakov answered StoyanChalakov edited

Hi Tony (@anthonypstrother-8017),

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CyrAz avatar image
1 Vote"
CyrAz answered CyrAz edited

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.