none
Data Warehouse failed to deploy reports for a management pack to SQL Reporting Services Server

    Question

  • I just installed the Remote Desktop Services 2012 MP and I started receive the following alerts:

    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 'c81d93be-218d-0d84-2fd8-c8c415b93be5'. Failed to deploy linked report 'Report.Windows.Server.2012.RDSessionHostServerActiveAndInActiveConnectionsByDay'. Failed to convert management pack element reference '$MPElement[Name="Microsoft.Windows.Server.2012.RemoteDesktopServicesRole.Service.RDSessionHost.InactiveSessions.PerformanceCollection"]$' to guid. Check if MP element referenced exists in the MP. An object of class ManagementPackElement with ID bcde77f3-211c-6a07-1272-47218344572f was not found.

    The funny thing is that I see the Report in Reporting Services called "Report.Windows.Server.2012.RDSessionHostServerActiveAndInActiveConnectionsByDay".

    I tried this - http://blogs.technet.com/b/momteam/archive/2012/10/24/kb-reports-are-not-populated-in-the-system-center-2012-operations-manager-reporting-pane.aspx, but now I get the above alert twice. I tried to remove and reinstall the MP and I still get the same error. All my other SCOM 2012 reports are there and working.

    Please help,

    Reuvy

    Wednesday, December 19, 2012 7:22 AM

All replies

  • Same thing happened to me. Are you using SCOM 2012 SP1 Beta?
    Thursday, December 20, 2012 6:22 AM
  • Hi,

    Please remove the RDS MP and re-import it referring to the MP guide:

    System Center 2012 Monitoring Pack for Microsoft Windows Server 2012 Remote Desktop Services

    http://www.microsoft.com/en-us/download/details.aspx?id=35812

    If the issue persists, please also check the Event Log and let us know the details if you find any related errors.

    Thanks.

    Nicholas Li
    TechNet Community Support

    Thursday, December 20, 2012 9:30 AM
    Moderator
  • Hi Nicholas,

    I tried that am still getting the same errors. The MP guide has no specific instructions as to a special way you need to install this MP. The errors:

    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 'c81d93be-218d-0d84-2fd8-c8c415b93be5'. Failed to deploy linked report 'Report.Windows.Server.2012.RDSessionHostServerActiveAndInActiveConnectionsByDay'. Failed to convert management pack element reference '$MPElement[Name="Microsoft.Windows.Server.2012.RemoteDesktopServicesRole.Service.RDSessionHost.InactiveSessions.PerformanceCollection"]$' to guid. Check if MP element referenced exists in the MP. An object of class ManagementPackElement with ID bcde77f3-211c-6a07-1272-47218344572f was not found. 

    One or more workflows were affected by this.  

    Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report 
    Instance name: 1e5a9bf3-d6d7-4861-bf81-56d9cc9727c2 
    Instance ID: {1CCCDA8D-EF07-EF5F-42A6-BE64A2F70C6B} 
    Management group: Servers

    [I for some reason get it twice though, and I wonder (unrelated/related) if it's because I tried fixing the issue using http://blogs.technet.com/b/momteam/archive/2012/10/24/kb-reports-are-not-populated-in-the-system-center-2012-operations-manager-reporting-pane.aspx, as mentioned above.]

    In the second event, the only thing that changed was the following two lines, or at least that's what I noticed:

    Instance name: 7eb13951-5bb1-4501-95d8-f9751cef6c8a 
    Instance ID: {24FB9FC2-6CC6-724D-2933-0E6C3FD48FAD} 

    • Edited by ReuvyGroovy Sunday, December 23, 2012 10:54 AM
    Sunday, December 23, 2012 10:52 AM
  • Hi,

    Please see if the following method helps:

    EventID 31567: Failed to deploy reporting component to the SQL Server Reporting Services server.

    http://thoughtsonopsmgr.blogspot.com/2010/09/eventid-31567-failed-to-deploy.html

    Thanks.


    Nicholas Li
    TechNet Community Support

    Tuesday, January 01, 2013 9:21 AM
    Moderator
  • Hey,

    As part of your previous suggestion to re-install the MP I had already done that, but unfortunately ii didn't help either.

    Thanks,

    Reuvy

    Tuesday, January 01, 2013 10:18 AM
  • Hi Reuvy

    Can you check the collation of your SQL Reporting Services databases

    Cheers

    Graham


    Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

    Tuesday, January 01, 2013 10:22 AM
    Moderator
  • Hey Graham,

    Curiously, its "Latin1_General_CI_AS_KS_WS", while the OperationsManager DB is using "SQL_Latin1_General_CP1_CI_AS". You think that is the culprit?

    Reuvy

    Tuesday, January 01, 2013 12:18 PM
  • Not sure - you usually see errors along the lines of "Cannot resolve the collation conflict between "SQL collation "SQL_Latin1_General_CP1_CI_AS" and "{Your_SQL_Collation_Name}" in the equal to operation."  which you don't seem to have.

    The other issue might be that a report is dependant on a rule that, for some reason, no longer exists. Can you see the following collection rule in Authoring, Rules?

    Microsoft.Windows.Server.2012.RemoteDesktopServicesRole.Service.RDSessionHost.InactiveSessions.PerformanceCollection

    I'll try and find the time to load this MP into my test environment to see if I get the same issue.

    Cheers

    Graham


    Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

    Wednesday, January 02, 2013 8:07 AM
    Moderator
  • Hey Grant,

    Yeah, I've seen that Collation error - we got it before we tried to install. Hopefully/Thankfully, we solved that one.

    I checked and didn't find the rule in the MMC, so I went to the DB and ran the query:

    SELECT [Name] FROM [OperationsManager].[dbo].[RuleView] where name like '%RemoteDesktopServicesRole%'

    And I got in return the following values:

    Microsoft.Windows.Server.2008R2.RemoteDesktopServicesRole.Service.RDSessionHost.ActiveSessions.BaselineCollection
    Microsoft.Windows.Server.2008R2.RemoteDesktopServicesRole.Service.RDSessionHost.InactiveSessions.PerformanceCollection
    Microsoft.Windows.Server.2008R2.RemoteDesktopServicesRole.Service.RDSessionHost.InactiveSessions.BaselineCollection
    Microsoft.Windows.Server.2008R2.RemoteDesktopServicesRole.Service.RDSessionHost.ActiveSessions.PerformanceCollection
    Microsoft.Windows.Server.2008R2.RemoteDesktopServicesRole.Service.RDSessionHost.TotalSessions.PerformanceCollection

    Interestingly / Strangely, nothing showed up for 2012.

    Reuvy

    Wednesday, January 02, 2013 9:29 AM
  • That is more likely to be the issue - the report is referencing an element that doesn't exist and hence can't be loaded.

    I'll see if I can get to check this during the afternoon (I'm UK based).

    Cheers

    Graham


    Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

    Wednesday, January 02, 2013 11:21 AM
    Moderator
  • Have you installed the Windows Server 2012 Remote Desktop Services Management Pack?

    http://www.microsoft.com/en-us/download/details.aspx?id=35812

    Even if you don't have Windows Server 2012 RDS deployed, it looks like the reports require that this MP is installed.

    Cheers

    Graham


    Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

    Wednesday, January 02, 2013 12:56 PM
    Moderator
  • Hey Graham,

    This whole thing started when I DID install the Windows Server 2012 RDS MP (http://www.microsoft.com/en-us/download/details.aspx?id=35812) - see above :-)

    Thursday, January 03, 2013 6:17 AM
  • Did you ever solve this?  I'm having the same problem, I just imported MP today and the error popped up.
    Wednesday, February 20, 2013 7:39 PM
  • Seeing the same issue here...

    Anyone ever came up with a solution?


    Regards,
    Anders

    Friday, February 22, 2013 1:56 PM
  • Push got the same issue.

    Hmm the thing with the collation is a strange thing. so the Default Collation for the Reporting Services is correct or should we change to SQL_Latin1_General_CP1_CI_AS ?

    I tryed to change over the option tap of the DB but i endet up with an error. after googeling i got a Forum post witch sayes do not change the default collation of the Reporitng service DB.

    Hm but waht is now the requrirement of SCOM ?

    Anyway if supported and reqired i will leave the DB on default.

    Hm i will now try to reinstall the MP but i think i have no luck

    Regards

    Florian

    Monday, February 25, 2013 10:21 AM
  • It looks like this is an old issue thats never been fixed. Here's a possible workaround.

    http://blogs.technet.com/b/mgoedtel/archive/2007/12/19/some-mp-reports-are-not-deployed-to-the-reporting-services-server.aspx

    Monday, March 04, 2013 8:02 PM
  • I attempted the workaround mentioned in link posted by YammyIT and unfortunately, for me, it did not solve the issue.
    Tuesday, March 05, 2013 1:28 PM
  • Hi,

    I am getting the same error event id 31567 after deployed Sharepoint 2013 MP (version 15.0.4420.1017): 

    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 '4e6e9979-550b-1f39-9554-af9ca0a59445'. Failed to deploy linked report 'Microsoft.SharePoint.Server_Performance_Report'. Failed to convert management pack element reference '$MPElement[Name="Microsoft.SharePoint.Server.2013.ECM_Disk_Based_Cache_Is_At_Critical_Capacity"]$' to guid. Check if MP element referenced exists in the MP. An object of class ManagementPackElement with ID d14ff666-6f78-d045-ff2d-d0e4526c6cd4 was not found.

    One or more workflows were affected by this.

    Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report
    Instance name: 779a736e-d352-45e2-aa26-8fc585ba8d41
    Instance ID: {58B66222-7135-A5A3-D96A-7B3C38D15661}

    I have already tried this : http://thoughtsonopsmgr.blogspot.ch/2010/09/eventid-31567-failed-to-deploy.html , but it didn't work. Link posted by YammyIT didn't work either :( 

    Collation of my ReportServer db is Latin1_General_CI_AS_KS_WS , but I haven't seen any collation related issues in event log. I have SCOM 2012 SP1 on Server 2012. 

    Wednesday, April 03, 2013 8:07 AM
  • Hi,

    I have instaled the latest version of the The Windows Server Network Load Balancing (NLB) Management Pack (6.0.7004.0) and I'm getting same error:

    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 '520a202b-48a7-f0a5-a37c-a4417bd38840'. Failed to deploy report 'Microsoft.Windows.NetworkLoadBalancing.ReportLibrary.Performance'. System.Web.Services.Protocols.SoapException: The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: Deserialization failed: The value 'ContentsOnly' is not valid for DataElementOutput.
    Parameter name: DataElementOutput Line 21, position 3268.
    at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Guid batchId, Warning[]& Warnings)
    at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)

    SCOM 2012 SP1 on Windows Server 2012 and SQL Server 2012

    Regards

    Friday, April 05, 2013 2:19 PM
  • Hi,

    I have instaled the latest version of the The Windows Server Network Load Balancing (NLB) Management Pack (6.0.7004.0) and I'm getting same error:

    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 '520a202b-48a7-f0a5-a37c-a4417bd38840'. Failed to deploy report 'Microsoft.Windows.NetworkLoadBalancing.ReportLibrary.Performance'. System.Web.Services.Protocols.SoapException: The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: Deserialization failed: The value 'ContentsOnly' is not valid for DataElementOutput.
    Parameter name: DataElementOutput Line 21, position 3268.
    at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Guid batchId, Warning[]& Warnings)
    at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)

    SCOM 2012 SP1 on Windows Server 2012 and SQL Server 2012

    Regards

    I'm having the same issue atm. , and I have SCOM 2012 SP1 on SSRS 2008 R2 SP2 did that resolution too but still no difference same error.
    Thursday, April 11, 2013 7:12 AM
  • I have the same issue with the NLB MP (SCOM 2012 SP1 UR1, SQL 2012 SP1)...

    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 '520a202b-48a7-f0a5-a37c-a4417bd38840'. Failed to deploy report 'Microsoft.Windows.NetworkLoadBalancing.ReportLibrary.Performance'. The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: Deserialization failed: The value 'ContentsOnly' is not valid for DataElementOutput.
    Parameter name: DataElementOutput Line 21, position 3268.

    Does anyone have an update please?


    Douks

    Wednesday, July 24, 2013 9:19 AM