Troubleshooting Service Manager 2010 Reporting #sysctr


Last week I had some challenges getting Service Manager Reporting working properly in a scenario with a remote SQL Server Reporting Services (SSRS) as shown below.

Context.
During deployment of the Service Manager data warehouse management server, you can specify the server to which Microsoft SQL Server Reporting Services (SSRS) will be deployed. By default, the computer that is hosting the data warehouse management server is selected during setup. If you specify a different computer, you are prompted to follow this procedure to configure the remote SSRS server. Before you follow this procedure, you must perform the following actions:

  • Copy Microsoft.EnterpriseManagement.Reporting.Code.dll from the Service Manager installation media to the computer that is hosting SSRS.
  • Add a code segment to a configuration file on the computer that is hosting SSRS.
Manual Steps to Configure the Remote SQL Server Reporting Services http://technet.microsoft.com/en-us/library/ff461215.aspx
Problem.
Despite performing this procedure Service Manager Reporting did not working. I get my Reporting wündebar in the Service Manager console including the 5 categories but no reports. Opening MP Sync Job, *.*.Report.Library packages have Pending Associations. Whenever I hit resume, MPSyncJob just stops after a few seconds.
Opening Operations Manager eventlog on Service Manager Data Warehouse server brings me to the following consecutive messages for Incident, Problem, Change, Activity and Configuration Management Report Library.
Management pack association ignored. This does not require any action. If you continue to frequently see this warning, contact your administrator. This process will continue to retry.
Management pack ID: 9541d60e-9a8b-cfd2-2008-155c3e0ada5c
Management pack name: ServiceManager.IncidentManagement.Report.Library
Management pack version: 7.0.6555.0
Data source name: Service Manager
This explains why reports are not displayed in the Service Manager Reporting console . Report library management packs are not included in the data warehouse database.
Solution.
With the following procedure, I solved the problem, special thanks to Ergin Seyfe which pointed me the use of gacutil, to add Microsoft.EnterpriseManagement.Reporting.Code.dll to the Global Assembly Cache.

Copy and install the Microsoft.EnterpriseManagement.Reporting.Code.dll file using gacutil

1.   On the Service Manager installation media, in the Prerequisites folder, locate the file Microsoft.EnterpriseManagement.Reporting.Code.dll.
2.   Copy this file to the \Windows\assembly folder on the computer that will host SSRS.
3.   Log on to the computer that will host SSRS.
4.   Click Start, and then click Run.
5.   In the Run dialog box, type cmd, and then press ENTER.
6.   In the command dialog box, type cd\windows\assembly, and then press ENTER.
7.   Type the command gacutil /i Microsoft.EnterpriseManagement.Reporting.Code.dll, and then press ENTER.
8.   Notice that Assembly successfully added to the cache displays.

To verify the installation of the Microsoft.EnterpriseManagement.Reporting.Code.dll file using gacutil

1.   Log on to the computer that will host SSRS.
2.   Click Start, and then click Run.
3.   In the Run dialog box, type cmd, and then press ENTER.
4.   In the command dialog box, type cd\windows\assembly, and then press ENTER.
5.   Type the command gacutil /l Microsoft.EnterpriseManagement.Reporting.Code, and then press ENTER.

Note! The file extension (.dll) is not used with the /l switch.

6.   Observe that The Global Assembly Cache contains the following assemblies: Microsoft.EnterpriseManagement.Reporting.Code, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL Number of items = 1 displays

To use the gacutil tool you need to install the .NET Framework 3.5 SDK. You will need the SDK as the gacutil tool is not included with the runtime. For more information, download a copy of the SDK at http://go.microsoft.com/fwlink/?LinkId=178257. If you have installed the .NET Framework 3.5 SDK, you can use the following procedures to install and verify the assembly. If you don’t want to download and install the entire copy of SDK you can download the gacutil here.

Advertisements

4 thoughts on “Troubleshooting Service Manager 2010 Reporting #sysctr

  1. fahad

    I am facing the same issue but after following the above mentioned solution my issue is still exists. I already replace the dll file and add the mentioned code in rssrvpolicy.config. Install the dll file in assembly folder but still unable to generate the reports.

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