Kevin Holman's System Center Blog

Posts in this blog are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified in the Terms of UseAre you interested in having a dedicated engineer that will be your Mic

Charts not showing up in scheduled reports?

Charts not showing up in scheduled reports?

  • Comments 5
  • Likes

 

image

 

 

There is an issue where scheduled reports will email the report, however, the graphic/chart will not show up in the attachment.

Additionally, on the reporting server application event log – you will see the following event:

Level: Error
EventID: 108
Source: Report Server Windows Service
Message: Report Server Windows Service (instancename) cannot load the EnterpriseManagementChartControl extension

This is a known issue, and there is a KB:  http://support.microsoft.com/kb/972821

 

The KB instructs us to edit the \ReportServer\bin\ReportingServicesService.exe.config file, and add in the following text:

<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>

The only challenge – it doesn’t tell us WHERE to add that in the file.

This XML section must be added in between <runtime><assemblyBinding…> and </assemblyBinding></runtime> statements of the \ReportServer\bin\ReportingServicesService.exe.config file.

Here is an example of mine below, with the new text added and highlighted:

 

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics" />
  </configSections>
  <system.diagnostics>
    <switches>
      <add name="DefaultTraceSwitch" value="3" />
    </switches>
  </system.diagnostics>
  <RStrace>
    <add name="FileName" value="ReportServerService_" />
    <add name="FileSizeLimitMb" value="32" />
    <add name="KeepFilesForDays" value="14" />
    <add name="Prefix" value="appdomain, tid, time" />
    <add name="TraceListeners" value="file" />
    <add name="TraceFileMode" value="unique" />
    <add name="Components" value="all:3" />
  </RStrace>
  <runtime>
    <alwaysFlowImpersonationPolicy enabled="true" />
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral" />
        <bindingRedirect oldVersion="8.0.242.0" newVersion="10.0.0.0" />
        <bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0" />
      </dependentAssembly>
      <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>
    </assemblyBinding>
    <gcServer enabled="true" />
  </runtime>
  <appSettings>
    <add key="ManagementGroupId" value="8326457b-80f5-c454-89a5-ee520cc88e71" />
  </appSettings>
</configuration>
Comments
  • Your awesome!  I also ran into this after migrating to a new sql 2008 server for my data warehouse, and found that very same stuff to add to the config file but was lost on where to put it, and hadn't found the time to trial and error it or open a case w/ MS.

  • Jason - your comment made me re-read my post - I actually screwed it up!  Above I have corrected the example.

  • That would explain why it didn't work for me :)  I did confirm that this way is working for me.  I also restarted reporting services after making the change to the config file, not sure if that step is required or not.

  • I'm having a similar issue where charts aren't displaying. I have tried the fix in this blog, and it hasn't worked for my issue. I send daily e-mails with a link to the report server, which displays the charts with no problem. When I save a copy to the hard disk it is missing the charts. I have an Availability chart that does work when saved to the hard drive. This chart that I'm having issues with is a performance series chart that displays % of free disk space. Does anyone know why this isn't working?

    Thanks Larry

  • Sorry, I figured out my own mistake. I forgot to restart the reporting service which corrected my error.

    Regards,

    Larry

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
Search Blogs