ServiceManager.ServiceManagement.Report.Library failed to deploy to the data warehouse

Scenario

When inspecting the status of System Center Service Manager (SCSM) 2012 Management Pack (MP) deployment you notice that the ServiceManager.ServiceManagement.Report.Library MP is still pending association hours after registering the System Center Data Warehouse (SCDW).

clip_image002

Note that although the above figure shows a status of imported subsequent batches are still pending association.

When you inspect the SCDW event log (Applications and Services Logs\Operations Manager) you notice a set of warnings and errors:

Level: Warning; Source: Deployment; Event ID: 33411

Report deployment failed for report with ID 08408456-f875-ff69-5266-d164d8f2a261 and name ServiceManager.Report.ServiceManagement.ServiceSummary.

One possible reason for this error is the Microsoft.EnterpriseManagement.Reporting.Code.dll may be missing. Please make sure you follow the instructions in the Service Manager Deployment Guide to deploy this DLL to the Reporting Services server.

Level: Warning; Source: Deployment; Event ID: 33403

Deployment Execution Infrastructure encountered an error while executing a deployer. 
MP element ID: 5520dd60-9951-a569-722e-48291e7a849b
MP name: ServiceManager.ServiceManagement.Report.Library
MP version: 7.5.2905.0
Operation: Install
Error message: Microsoft.EnterpriseManagement.Deployers.DeploymentException: Install ‘Report’ operation failed from within ‘install’ Installing reports  store = http://ssrs.contoso.com:80/ReportServer/ReportService2005.asmx parameters are folderpath = /SystemCenter/ServiceManager/ServiceManager.Console.Reporting.ServiceManagement, report name = ServiceManager.Report.ServiceManagement.ServiceSummary in AddReport within SRSResourceStore AddReport ; After initialize within SRSResourceStore AddReport ; After CreateReport within SRSResourceStore AddReport ;An attempt has been made to use a data extension ‘SCDWMultiMartDataProcessor’ that is either not registered for this report server or is not supported in this edition of Reporting Services. —> Microsoft.ReportingServices.Diagnostics.Utilities.DataExtensionNotFoundException: An attempt has been made to use a data extension ‘SCDWMultiMartDataProcessor’ that is either not registered for this report server or is not supported in this edition of Reporting Services.   at Microsoft.SystemCenter.ResourceAccessLayer.SrsResourceStore.AddReport(String folderPath, String name, String reportDescription, String reportId, IResource rdl, Boolean overwrite, Boolean visible)
   at Microsoft.EnterpriseManagement.Deployers.ReportDeployer.CreateReport(Boolean overwrite)

Microsoft.EnterpriseManagement.Deployers.DeploymentException
   at Microsoft.EnterpriseManagement.Deployers.ReportDeployer.CreateReport(Boolean overwrite)
   at Microsoft.EnterpriseManagement.Deployers.ReportDeployer.Install()
   at Microsoft.SystemCenter.DeploymentEngine.ExecutionManager.Run(DeployerBase deployer)
   at Microsoft.SystemCenter.DeploymentEngine.ExecutionManager.Run(IXPathNavigable instance)

Level: Error; Source: Deployment; Event ID: 33410

Deployment Execution Infrastructure has retried the maximum number of times and is giving up on this execution step. 
MP Element ID: 5520dd60-9951-a569-722e-48291e7a849b
MP name: ServiceManager.ServiceManagement.Report.Library
MP version: 7.5.2905.0
Operation: Install
Error message: Install ‘Report’ operation failed from within ‘install’ Installing reports  store = http://ssrs.contoso.com:80/ReportServer/ReportService2005.asmx parameters are folderpath = /SystemCenter/ServiceManager/ServiceManager.Console.Reporting.ServiceManagement, report name = ServiceManager.Report.ServiceManagement.ServiceSummary in AddReport within SRSResourceStore AddReport ; After initialize within SRSResourceStore AddReport ; After CreateReport within SRSResourceStore AddReport ;An attempt has been made to use a data extension ‘SCDWMultiMartDataProcessor’ that is either not registered for this report server or is not supported in this edition of Reporting Services. —> Microsoft.ReportingServices.Diagnostics.Utilities.DataExtensionNotFoundException: An attempt has been made to use a data extension ‘SCDWMultiMartDataProcessor’ that is either not registered for this report server or is not supported in this edition of Reporting Services.   at Microsoft.SystemCenter.ResourceAccessLayer.SrsResourceStore.AddReport(String folderPath, String name, String reportDescription, String reportId, IResource rdl, Boolean overwrite, Boolean visible)
   at Microsoft.EnterpriseManagement.Deployers.ReportDeployer.CreateReport(Boolean overwrite)

Resolution

Perform the Manual Steps to Configure the Remote SQL Server Reporting Services:

  1. Copy Microsoft.EnterpriseManagement.Reporting.Code.dll from the Service Manager installation media to the computer that is hosting SSRS.
  2. Add a code segment to the rssrvpolicy configuration file on the computer that is hosting SSRS.
  3. Add an Extension tag to the existing Data segment in the rsreportserver configuration file on the same computer.

More information

In my case I uninstalled SCSM 2010 w/SP1 and installed SCSM 2012 w/SP1.  I didn’t perform the Manual Steps to Configure the Remote SQL Server Reporting Services because I’d already done this.  However the third configuration element is new to SCSM 2012:

  • Add an Extension tag to the existing Data segment in the rsreportserver configuration file on the same computer.

After making this change I restarted the deployment of the MP from the SCSM management service console.  Moments later the SCDW event log shows successful deployment of the MP.

Level: Information; Source: Deployment; Event ID: 33407

Deployment Execution Infrastructure recovered from a previous deployer error. 
MP element ID: a6d3eb40-cf2f-f3ab-e2cb-f083405bd5b1
MP name: ServiceManager.ServiceManagement.Report.Library
MP version: 7.5.2905.0
Operation: Install

Deployment Execution Infrastructure has retried the maximum number of times and is giving up on this execution step. 
MP Element ID: 5520dd60-9951-a569-722e-48291e7a849b
MP name: ServiceManager.ServiceManagement.Report.Library
MP version: 7.5.2905.0
Operation: Install
Error message: Install ‘Report’ operation failed from within ‘install’ Installing reports  store = http://ssrs.contoso.com:80/ReportServer/ReportService2005.asmx parameters are folderpath = /SystemCenter/ServiceManager/ServiceManager.Console.Reporting.ServiceManagement, report name = ServiceManager.Report.ServiceManagement.ServiceSummary in AddReport within SRSResourceStore AddReport ; After initialize within SRSResourceStore AddReport ; After CreateReport within SRSResourceStore AddReport ;An attempt has been made to use a data extension ‘SCDWMultiMartDataProcessor’ that is either not registered for this report server or is not supported in this edition of Reporting Services. —> Microsoft.ReportingServices.Diagnostics.Utilities.DataExtensionNotFoundException: An attempt has been made to use a data extension ‘SCDWMultiMartDataProcessor’ that is either not registered for this report server or is not supported in this edition of Reporting Services.   at Microsoft.SystemCenter.ResourceAccessLayer.SrsResourceStore.AddReport(String folderPath, String name, String reportDescription, String reportId, IResource rdl, Boolean overwrite, Boolean visible)
   at Microsoft.EnterpriseManagement.Deployers.ReportDeployer.CreateReport(Boolean overwrite)

Further inspection of the properties of the MPSyncJob – what led me to investigate the issue in the first place – show the latest batch ID and the MP as associated with no more pending associations in future batches.

Advertisements

About Paul Williams

IT consultant working for Microsoft specialising in Identity Management and Directory Services.
This entry was posted in FIM 2010 R2, SCSM and tagged , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s