StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POReporting Services Error on First Run of any Report
text
Body
copied!<p>This is a strange one!</p> <p>We have a forms authentication module implemented and is all working fine.</p> <p>However, when you restart/first run reporting services, the first report to run returns an Error 500, Internal Server Error. If you then re-run the report, all works perfectly well, and all reports work perfectly well from this point.</p> <p>It's not the report, it happens on a simple 'blank' report.</p> <p>The Reporting Service Log file shows a 'file not exists error', but not which file.</p> <pre><code>webserver!ReportServer_0-2!266c!08/22/2011-14:32:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnhandledHttpApplicationException: , Microsoft.ReportingServices.Diagnostics.Utilities.UnhandledHttpApplicationException: The report server encountered an unhandled exception in HttpApplication. ---> </code></pre> <p><strong>System.Web.HttpException: File does not exist.</strong></p> <pre><code> at System.Web.StaticFileHandler.GetFileInfo(String virtualPathWithPathInfo, String physicalPath, HttpResponse response) at System.Web.StaticFileHandler.ProcessRequestInternal(HttpContext context) at System.Web.DefaultHttpHandler.BeginProcessRequest(HttpContext context, AsyncCallback callback, Object state) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --- End of inner exception stack trace ---; ui!ReportManager_0-1!26cc!08/22/2011-14:32:09:: e ERROR: </code></pre> <p><strong>System.Net.WebException: The remote server returned an error: (500) Internal Server Error.</strong></p> <pre><code> at System.Net.HttpWebRequest.GetResponse() at Microsoft.ReportingServices.UI.ServerAuthType.GetReportServerAuthentication() at Microsoft.ReportingServices.UI.ServerAuthType.get_ServerUsesBasic() at Microsoft.ReportingServices.UI.WebControlConnection.get_NetworkCredentials() at Microsoft.Reporting.WebForms.ServerReport.get_ServerNetworkCredentials() at Microsoft.Reporting.WebForms.ServerReport.get_Service() at Microsoft.Reporting.WebForms.ServerReport.GetServerVersion() at Microsoft.ReportingServices.UI.ViewReport.Control_Init(Object sender, EventArgs args) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at Microsoft.ReportingServices.UI.SharedArea.Control_Init(Object sender, EventArgs args) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at Microsoft.ReportingServices.UI.ReportWrapperPage.Page_Init(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Page.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) ui!ReportManager_0-1!26cc!08/22/2011-14:32:09:: e ERROR: HTTP status code --> 500 -------Details-------- **System.Net.WebException: The remote server returned an error: (500) Internal Server Error.** at System.Net.HttpWebRequest.GetResponse() at Microsoft.ReportingServices.UI.ServerAuthType.GetReportServerAuthentication() at Microsoft.ReportingServices.UI.ServerAuthType.get_ServerUsesBasic() at Microsoft.ReportingServices.UI.WebControlConnection.get_NetworkCredentials() at Microsoft.Reporting.WebForms.ServerReport.get_ServerNetworkCredentials() at Microsoft.Reporting.WebForms.ServerReport.get_Service() at Microsoft.Reporting.WebForms.ServerReport.GetServerVersion() at Microsoft.ReportingServices.UI.ViewReport.Control_Init(Object sender, EventArgs args) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at Microsoft.ReportingServices.UI.SharedArea.Control_Init(Object sender, EventArgs args) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at Microsoft.ReportingServices.UI.ReportWrapperPage.Page_Init(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Page.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) library!ReportServer_0-2!25d8!08/22/2011-14:32:09:: Call to GetSystemPropertiesAction(). ui!ReportManager_0-1!26cc!08/22/2011-14:32:09:: e ERROR: </code></pre> <p><strong>System.Threading.ThreadAbortException: Thread was being aborted.</strong></p> <pre><code> at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) </code></pre> <p><em><strong>Any</em></strong> help/hints/suggestions much appreciated, as I've ran out of them!</p> <p>I'm pretty sure it's an authentication issue. A report can have a subscription 'cache' refresh and still work, but then you still get the above the first time a 'user' tries to run any report.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload