question

TonyStrother-2074 avatar image
0 Votes"
TonyStrother-2074 asked StoyanChalakov answered

SSRS 2016 iisue- Failed to deploy report 'SystemCenter.Operations.Manager.Health.Check.Report.Library.Report.Misc.OMSManaged'. AdjustDataSources: Exception

SCOM 2019, SSRS 2016- with event id 31567 is OPS Mgr log. I find plenty of references for SSRS2017 but none for fixing the issue with SSRS 2016.

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" />

sql-server-reporting-servicesmsc-operations-manager
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.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @TonyStrother-2074 ,
Please check the data source settings:
1. Open Internet Explorer, visit http://servername/reports.
2. Click on “Show Details” on the upper right corner. If you see “Data Warehouse Main” listed, please click it and check its properties. The settings should be:
Connection Type: Microsoft SQL server
Connection String: data source=<Name of the SQL reporting server>;initial catalog=OperationsManagerDW;Integrated Security=SSPI
(Ensure the NETBIOS name of the SQL reporting server is used.)
The option “credentials are not required” is selected.
Hope this helps.
Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November


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.

StoyanChalakov avatar image
0 Votes"
StoyanChalakov answered

Hi Tony,

here you will find also some more details and screenshots on what has to be checked (chanhed) exactly:

Creating a Data Source for the Operational DB on OpsMgr 2012 R2 Reporting Server
https://blog.tyang.org/2013/12/06/creating-data-source-operational-db-opsmgr-2012-r2-reporting-server/


(If the reply was helpful please don't forget to upvote or accept as answer, thank you)
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.