Rahman Agoro, the frontline SQL DBA

Just another WordPress.com weblog

Archive for the ‘SSRS’ Category

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

Posted in SSRS, Tips | Leave a Comment »