Share via

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

Pierce, Paula 20 Reputation points
13 Mar 2025, 13:31

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 '5f65ce8d-6bef-bb24-b214-45a08285af2a'. Failed to deploy report 'Microsoft.SystemCenter.DataWarehouse.Report.Override'. Error while loading code module: 'Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral'. Details: Could not load file or assembly 'Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral' or one of its dependencies. The system cannot find the file specified.

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report

Instance name: Data Warehouse Synchronization Service

Instance ID: {6E911EF4-DCD5-DE0A-5354-17689052F8D0}

Management group: LCOMS

This is happening in our SCOM 2022 Environment after the installation of UR2. We have installed multiple versions of SSRS 2022 and none have resolved the issue.

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,547 questions
0 comments No comments
{count} votes

Accepted answer
  1. XinGuo-MSFT 21,901 Reputation points
    14 Mar 2025, 06:53

    Hi,

    It sounds like you're dealing with a frustrating issue.

    Here are some steps you can take to resolve the problem:

    1. Verify UR2 Version: Ensure you have the correct and latest version of the Update Rollup 2 for SCOM 2022. There was an issue with the initial release of UR2, which was later fixed. Make sure you have the updated version.
    2. Update SSRS Configuration: If the assembly is missing, you might need to manually add it to the ReportServer\bin folder and update the rssrvpolicy.config file to include the new assembly.
    3. Review Logs: Check the setup logs for any additional errors or warnings that might provide more insight into the issue. Logs can be found in the C:\Program Files\Microsoft SQL Server\nnn\Setup Bootstrap\Log folder[]](https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/troubleshoot-a-reporting-services-installation?view=sql-server-ver16).

    Let me know if you need further help or have any other questions!

    References:

    UR2 for SCOM 2022 – Step by Step – Kevin Holman's Blog

    0 comments No comments

0 additional answers

Sort by: Most helpful

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.