HTTP 500 Internal Server Error after Windows Update

  • We finished a recent update to our server and ever since then our SSRS default instance has stopped working. We are now getting an "HTTP 500 Internal Server Error". 

    When looking at the log file located at "C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\LogFiles" we see several log file with today's (7/2/18) timestamp. The most recent log file has a number of lines denoted as errors shown at the end.

    Couple additional notes:
    1. I suspect it has to do with something related to .NET updaets during the general update.
    2. The update was doing a number of security updates, and interestingly... one related to .NET failed. See screen shot below.

    Any ideas?

    Screen shot:

    Error from log file:

    appdomainmanager!DefaultDomain!27a8!07/02/2018-17:01:19:: e ERROR: AppDomain ReportManager_MSSQLSERVER_0 failed to start. Error: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
    library!DefaultDomain!27a8!07/02/2018-17:01:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: Failed to create HTTP Runtime, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0. ---> System.Web.HttpException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---> System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
    File name: 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
    File name: 'Microsoft.ReportingServices.SharePoint.ObjectModel'

    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
     at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
     at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) 
    at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
     at System.Reflection.Assembly.Load(String assemblyString)
     at System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective)

     --- End of inner exception stack trace ---
     at System.Web.Configuration.CompilationSection.LoadAssemblyHelper(St
    appdomainmanager!ReportManager_0-1!27a8!07/02/2018-17:01:19:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-131750496787639960 unloading
    library!DefaultDomain!27a8!07/02/2018-17:01:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerAppDomainManagerException: Failed to create Report Server HTTP Runtime, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerAppDomainManagerException: An error occurred when attempting to start the application domain ReportManager within the Report Server service. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0. ---> System.Web.HttpException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---> System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
     --- End of inner exception stack trace ---;
    rshost!rshost!27a8!07/02/2018-17:01:19:: e ERROR: Failed to create HttpRuntime 80131500.
    rshost!rshost!27a8!07/02/2018-17:01:19:: e ERROR: Failed to get appdomain 80131500, pipeline=0x0000000EA83A1C20.
    rshost!rshost!27a8!07/02/2018-17:01:19:: e ERROR: Error state. Internal abort for pipeline=0x0000000EA83A1C20 ...
    appdomainmanager!DefaultDomain!25dc!07/02/2018-17:01:25:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-131750496787639960 unregistered.
    rshost!rshost!25dc!07/02/2018-17:01:25:: i INFO: Application domain type ReportManager statistics: created: 1, unloaded: 1, failed: 0, timed out: 0.

  • ptownbro - Monday, July 2, 2018 6:49 PM

    We finished a recent update to our server and ever since then our SSRS default instance has stopped working. We are now getting an "HTTP 500 Internal Server Error". 

    When looking at the log file located at "C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\LogFiles" we see several log file with today's (7/2/18) timestamp. The most recent log file has a number of lines denoted as errors shown at the end.

    Couple additional notes:
    1. I suspect it has to do with something related to .NET updaets during the general update.
    2. The update was doing a number of security updates, and interestingly... one related to .NET failed. See screen shot below.

    Any ideas?

    Screen shot:

    Error from log file:

    appdomainmanager!DefaultDomain!27a8!07/02/2018-17:01:19:: e ERROR: AppDomain ReportManager_MSSQLSERVER_0 failed to start. Error: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
    library!DefaultDomain!27a8!07/02/2018-17:01:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: Failed to create HTTP Runtime, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0. ---> System.Web.HttpException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---> System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
    File name: 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
    File name: 'Microsoft.ReportingServices.SharePoint.ObjectModel'

    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
     at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
     at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) 
    at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
     at System.Reflection.Assembly.Load(String assemblyString)
     at System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective)

     --- End of inner exception stack trace ---
     at System.Web.Configuration.CompilationSection.LoadAssemblyHelper(St
    appdomainmanager!ReportManager_0-1!27a8!07/02/2018-17:01:19:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-131750496787639960 unloading
    library!DefaultDomain!27a8!07/02/2018-17:01:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerAppDomainManagerException: Failed to create Report Server HTTP Runtime, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerAppDomainManagerException: An error occurred when attempting to start the application domain ReportManager within the Report Server service. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0. ---> System.Web.HttpException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---> System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.SharePoint.ObjectModel' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
     --- End of inner exception stack trace ---;
    rshost!rshost!27a8!07/02/2018-17:01:19:: e ERROR: Failed to create HttpRuntime 80131500.
    rshost!rshost!27a8!07/02/2018-17:01:19:: e ERROR: Failed to get appdomain 80131500, pipeline=0x0000000EA83A1C20.
    rshost!rshost!27a8!07/02/2018-17:01:19:: e ERROR: Error state. Internal abort for pipeline=0x0000000EA83A1C20 ...
    appdomainmanager!DefaultDomain!25dc!07/02/2018-17:01:25:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-131750496787639960 unregistered.
    rshost!rshost!25dc!07/02/2018-17:01:25:: i INFO: Application domain type ReportManager statistics: created: 1, unloaded: 1, failed: 0, timed out: 0.

    Is this suppose to be running in Sharepoint integrated mode? The error thrown in related to that add-in. The error could be related to "or one of it's dependencies"  - could be that the .Net upgrades affected one of those files used by the add-in.

    Sue

  • Not that I am aware of. This was setup originally choosing the default settings. Is there a way to turn that off or to fix it somehow that you know of?

  • ptownbro - Wednesday, July 4, 2018 2:37 PM

    Not that I am aware of. This was setup originally choosing the default settings. Is there a way to turn that off or to fix it somehow that you know of?

    You can uninstall the Reporting Services add-in for Sharepoint. It could be there from another installation. There have a been some odd errors like your where they are not using Sharepoint either. Check the steps they listed in this post:
    Microsoft SSRS 2012 Report Manager - HTTP 500 error

    You can also get the 500 error due to permissions - I don't think that's it in your case. But it doesn't hurt to check - make sure the reporting services service account has full control permissions on the RSTempFiles folder.

    Sue

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

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