Friday, June 15, 2012

Failed to initialize the AppDomain:ReportManager_MSSQLSERVER_0

q: Today the customer began receiving an HTTP 500 error when trying to access their SQL Server Reporting website.  /reports   The Server had the following error in the Application Log: Event 1223 / ASP.NET 2.0.50727.

Failed to initialize the AppDomain:ReportManager_MSSQLSERVER_0
Exception: System.SystemException
Message: Failed to create AppDomain.
StackTrace:    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.OutOfMemoryException
Message: Exception of type 'System.OutOfMemoryException' was thrown.

a: A quick fix that seemed to work without affecting anything else on the box was to recycle the "DefaultAppPool" Application Pool within IIS.  After that the site loaded & reports were able to run.