ResearchThis! KB: No graphs present in reports emailed from Operations Manager 2007 R2

Here is an issue that a couple of people have reported in OpsMgr 2007 R2, along with a not-so-obvious fix

 Problem

When a report is run directly from SCOM 2007 R2, the report contains the expected graph and text data line (maximum value XXX, minimum value XXX, average value XXX). However, when the report is scheduled and sent by email only the text line is sent. Instead of the graph there is a empty space in the message.

Resolution

1. Add the following entries to the ReportingServicesService.exe.config file in the \ReportServer\bin folder on your Reporting Server.

<dependentAssembly>

                  <assemblyIdentity name=”Microsoft.ReportingServices.ProcessingCore” publicKeyToken=”89845dcd8080cc91″ culture=”neutral” />

                  <bindingRedirect oldVersion=”9.0.242.0″ newVersion=”10.0.0.0″ />

            </dependentAssembly>

            <dependentAssembly xmlns=”urn:schemas-microsoft-com:asm.v1″>

                  <assemblyIdentity name=”Microsoft.ReportingServices.ProcessingCore” publicKeyToken=”89845dcd8080cc91″ culture=”neutral” />

                  <bindingRedirect oldVersion=”9.0.242.0″ newVersion=”10.0.0.0″ />

            </dependentAssembly>

2. After doing this, restart the SQL Reporting service

Background

When you build a .NET Framework application against a strong-named assembly, the application uses that version of the assembly at run time by default, even if a new version is available. However, you can configure the application to run against a newer version of the assembly. For details on how the runtime uses these files to determine which assembly version to use, see How the Runtime Locates Assemblies on this page in MSDN. In this case, the redirect is from a SQL 2005 version to SQL 2008 version (in fact, OpsMgr 2007 did not always support SQL 2008).

Issue and Resolution Reported By: Andreas “Tenchuu” Zuckerhut

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.