Export to Excel error with OverrideNames

Question

Export to Excel error with OverrideNames

Gordon Barclay

SSC Eights!

Points: 922
More actions
April 4, 2018 at 7:58 am

#344530

Using the information posted found at Export to Excel I have managed to update the reportserver.config file to provide a method of exporting to Excel without the issues raised by including the export of report headers etc. The issue that I have is that when I use the OverrideNames attribute an exception is raised when attempting to restart the Report Server, but when I have the following It works fine and exports the data in an acceptable format.
<Extension Name="Excel (No Header)" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
<Configuration>
  <DeviceInfo>
   <SimplePageHeaders>True</SimplePageHeaders>
  </DeviceInfo>
</Configuration>
</Extension>
The name of the additional export method created as a result of the above is Excel 2003

Now I wish to rename this as per the above link to Excel (No Header) but any inclusion of the OverrideNames attribute results in the following exception;
<Header>
<Product>Microsoft SQL Server Reporting Services Version 2011.0110.6260.01 ((SQL11_SP3_GDR).180109-2115 )</Product>
<Locale>English (United Kingdom)</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__04_03_2018_15_59_57.log</Path>
<SystemName>CBKH-DEVRPT-01</SystemName>
<OSName>Microsoft Windows NT 6.2.9200</OSName>
<OSVersion>6.2.9200</OSVersion>
<ProcessID>4440</ProcessID>
<Virtualization>Hypervisor</Virtualization>
</Header>
<ProcessorArchitecture>AMD64</ProcessorArchitecture>
<ApplicationArchitecture>AMD64</ApplicationArchitecture>
rshost!rshost!130c!04/03/2018-15:59:57:: i INFO: CLR runtime is initialized.
rshost!rshost!130c!04/03/2018-15:59:57:: i INFO: Derived memory configuration based on physical memory as 8388148 KB
appdomainmanager!DefaultDomain!130c!04/03/2018-15:59:57:: i INFO: Entered managed ServiceMain in DefaultDomain.
configmanager!DefaultDomain!8ac!04/03/2018-15:59:58:: e ERROR: Error loading configuration file: Object reference not set to an instance of an object.
library!DefaultDomain!8ac!04/03/2018-15:59:58:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: , Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.ReportingServices.Diagnostics.ExtensionsConfiguration.ExtractRenderingExternsionOverrideNames(XmlNode extensionElement, RenderingExtension p)
   at Microsoft.ReportingServices.Diagnostics.ExtensionsConfiguration.ParseRenderExtensions(XmlNode child, ExtensionArray array)
   at Microsoft.ReportingServices.Diagnostics.ExtensionsConfiguration.ParseExtensions(XmlNode child, ExtensionArray array)
   at Microsoft.ReportingServices.Diagnostics.ExtensionsConfiguration.ParseXML(XmlNode node)
   at Microsoft.ReportingServices.Diagnostics.RSConfigurationFileManager.ParseExtensions(XmlNode child, ConfigurationPropertyBag properties)
   at Microsoft.ReportingServices.Diagnostics.RSConfigurationFileManager.ParseDocument(XmlDocument xmlConfiguration)
   at Microsoft.ReportingServices.Diagnostics.RSConfigurationFileManager.LoadDocument()
   at Microsoft.ReportingServices.Diagnostics.RSConfigurationFileManager.LoadConfiguration()
   --- End of inner exception stack trace ---;
appdomainmanager!DefaultDomain!8ac!04/03/2018-15:59:58:: e ERROR: Appdomain:1 DefaultDomain failed to initialize. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.NullReferenceException: Object reference not set to an instance of an object..
appdomainmanager!DefaultDomain!1328!04/03/2018-15:59:58:: e ERROR: Windows service failed to start. Exception: System.Exception: Default appdomain failed to initialize.
   at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()
   at Microsoft.ReportingServices.Library.ReportService.OnStart(String[] args)
Has anyone else experienced this before or able to suggest a fix for this?
The SQL version is 2012 and is on a Windows 2012 R2 server.
Many thanks in advance.
Gordon Barclay

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Gordon Barclay SSC Eights! Points: 922 More actions · Answer 1

Well I can only assume nobody else has encountered this issue, If I manage to resolve this myself I'll put the solution here for others.

Gordon Barclay

Sue_H SSC Guru Points: 90860 More actions · Answer 2

Gordon Barclay - Wednesday, May 2, 2018 2:25 AM
Well I can only assume nobody else has encountered this issue, If I manage to resolve this myself I'll put the solution here for others.

It's hard to say as it's somewhere in how you modified the config file for this. Whatever it was, reporting services choked on it.
Maybe check some other posts doing the same thing and compare it to your changes. And check everything including things like no extra spaces, carriage returns, etc.

Sue