Rahman Agoro, the frontline SQL DBA

Just another WordPress.com weblog

SSRS 2008 Reporting Services HTTP 500 Error

Posted by rahmanagoro on January 1, 2013


I recently had a HTTP 500 error whilst trying to open a SSRS page, I was a bit suspicious of this error as it didn’t have any diagnostic information to suggest the root cause of the error on the SSRS page. I then went onto checking the report server database server to see if I could find any information relating to the database server. 

Upon diagnosing the problem, I checked the application logs on the report server and stumbled upon the error information below.

 

</span>

Failed to initialize the AppDomain:ReportManager_MSSQLSERVER_0
Exception: System.Web.HttpException
Message: Could not load file or assembly 'Microsoft.ReportingServices.Diagnostics, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. There is not enough space on the disk. (Exception from HRESULT: 0x80070070)
StackTrace:    at System.Web.Compilation.BuildManager.ReportTopLevelCompilationException()
   at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled()
   at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters)
   at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters)
   at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironment(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters)
   at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironmentAndReportErrors(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters)
InnerException: System.Configuration.ConfigurationErrorsException
Message: Could not load file or assembly 'Microsoft.ReportingServices.Diagnostics, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. There is not enough space on the disk. (Exception from HRESULT: 0x80070070)
StackTrace:    at System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective)
   at System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory()
   at System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai)
   at System.Web.Configuration.AssemblyInfo.get_AssemblyInternal()
   at System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig)
   at System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName)
   at System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp)
   at System.Web.Compilation.BuildManager.CompileGlobalAsax()
   at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled()
InnerException: System.IO.FileLoadException

Message: Could not load file or assembly 'Microsoft.ReportingServices.Diagnostics, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. There is not enough space on the disk. (Exception from HRESULT: 0x80070070)

StackTrace:    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)

InnerException: System.IO.FileLoadException

Message: Could not load file or assembly 'Microsoft.ReportingServices.Diagnostics' or one of its dependencies. There is not enough space on the disk. (Exception from HRESULT: 0x80070070)
StackTrace:
  

 

From the error we can see that it’s ran out of space somewhere, and hence why we have the problem.

The corrective action taken was to check the log folder for SSRS as it was one of the main disk space consumers. I can see from the location that there are loads of files generated.

Check the SSRS log file location in this case, C:\Apps\MSSQL\MSRS10.MSSQLSERVER\Reporting Services\LogFiles.

It turns out that in SSRS, Default trace is switched on by default and the tracing level set by default is level 3 which includes the following: Exceptions, restarts, warnings, status messages (default). This explains why the file sizes on this case were quite big in size.


 <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="tid, time" />
        <add name="TraceListeners" value="file" />
        <add name="TraceFileMode" value="unique" />
        <add name="Components" value="all" />
  </RStrace>

<span style="font-family: Calibri; color: #000000; font-size: medium;">  

The DefaultTraceSwitch as we can see above is set to 3.

So when you run into this error, it can be caused by anything including lack of disk space as I have found out.

For more information, please see http://msdn.microsoft.com/en-us/library/ms156500.aspx

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

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

 
%d bloggers like this: