Reporting Services – v2016 – HTTP Error 500

Error

Error – Browser

500

Image

TroubleShooting

LogFiles

ReportServerServices

Image


appdomainmanager!DefaultDomain!24e4!10/26/2017-11:08:54:: i INFO: Appdomain STARTED: id='3'; name='ReportServer_MSSQLSERVER_0-1-131535149338364464'
appdomainmanager!DefaultDomain!24e4!10/26/2017-11:08:54:: e ERROR: AppDomain ReportServer_MSSQLSERVER_0 failed to start. Error: Unable to read the security policy file for trust level 'RosettaSrv'.
library!DefaultDomain!24e4!10/26/2017-11:08:54:: 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 ReportServer_MSSQLSERVER_0.  ---> System.Configuration.ConfigurationErrorsException: Unable to read the security policy file for trust level 'RosettaSrv'.
   at System.Web.HttpRuntime.SetTrustLevel(TrustSection trustSection, SecurityPolicySection securityPolicySection)
   at System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags, PolicyLevel policyLevel, Exception appDomainCreationException)
   at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters, PolicyLevel policyLevel, Exception appDomainCreationException)
   at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters, PolicyLevel policyLevel)
   at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters, PolicyLevel policyLevel)
   at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironment(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters)
   at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironmentAndReportErrors(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters)
   at System.Web.Hosting.ApplicationManager.GetAppDomainWithHostingEnvironment(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters)
   at System.Web.Hosting.ApplicationManager.CreateObjectInternal(String appId, Type type, IApplicationHost appHost, Boolean failIfExists, HostingEnvironmentParameters hostingParameters)
   at System.Web.Hosting.ApplicationManager.CreateObject(String appId, Type type, String virtualPath, String physicalPath, Boolean failIfExists, Boolean throwOnError)
   at ReportingServicesHttpRuntime.RsHttpRuntime.Create(RsAppDomainType type, String vdir, String pdir, Int32& domainId)
   --- End of inner exception stack trace ---;
appdomainmanager!DefaultDomain!24e4!10/26/2017-11:08:54:: e ERROR: AppDomain ReportServer error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0.  ---> System.Configuration.ConfigurationErrorsException: Unable to read the security policy file for trust level 'RosettaSrv'..
appdomainmanager!DefaultDomain!24e4!10/26/2017-11:08:54:: e ERROR: AppDomain ReportServer id 3 ('ReportServer_MSSQLSERVER_0-1-131535149338364464') was created. Unloading it...
appdomainmanager!DefaultDomain!24e4!10/26/2017-11:08:54:: i INFO: UnloadAspDomain ReportServer: 3, 'ReportServer_MSSQLSERVER_0-1-131535149338364464'
appdomainmanager!DefaultDomain!24e4!10/26/2017-11:08:55:: i INFO: SetUnloadStarted AppDomain id '3': unloadStarted = 1
appdomainmanager!DefaultDomain!24e4!10/26/2017-11:08:55:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-131535149338364464 unloading.
library!DefaultDomain!24e4!10/26/2017-11:08:55:: 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 ReportServer within the Report Server service. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0.  ---> System.Configuration.ConfigurationErrorsException: Unable to read the security policy file for trust level 'RosettaSrv'.

Textual

  1. 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 ReportServer_MSSQLSERVER_0. —> System.Configuration.ConfigurationErrorsException: Unable to read the security policy file for trust level ‘RosettaSrv’.
    at System.Web.HttpRuntime.SetTrustLevel(TrustSection trustSection, SecurityPolicySection securityPolicySection)

 

Remediation

Reporting Server Services

Configuration

Configuration File

web.config
web.config – Before Change

Here is what our configuration file looked like before the change.

Image

Code

    <securityPolicy>
      <trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />
    </securityPolicy>
    <trust level="RosettaSrv" originUrl="" />

Explanation
  1. We can see that the RosettaSrv section is commented out

 

web.config – Revised

Re-enabled the commented out section

Image

Code
    <securityPolicy>
      <trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />
    </securityPolicy>
	
	
	<trust level="RosettaSrv" originUrl="" legacyCasModel="true" />

Explanation
  1. We have re-enabled the RosettaSrv section

 

Compare Files

There are many online tools for comparing files.

Mergely

Here is what things look like from the fine mergely tool.

Summary

Almost a year ago commented out the Rosetta section.

That was SQL Server v2014.

Now we are v2016, that Rosetta section is required.

Dedicate

Dedicating to our internal Engineering Platform team.

Because of the VMWare backup they take was able to compare the before and after versions of the Reporting Services Configuration Files.

Leave a Reply

Please log in using one of these methods to post your comment:

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