Prev: Debugging Custom Assembly SSRS - Failed to load expression host as
Next: Encryption Key
From: scott dallamura on 23 Jan 2007 10:57
i am getting the same error, SP1 with the 2153 hotfix (applying the hotfix
did not solve the problem). i found another person with a similar issue:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=251046

does anyone know of a cause or workaround?

"JXJ" wrote:

> We are getting intermittent errors from RS - at least a few times a day. The
> message that displays is:
>
> An internal error occurred on the report server. See the error log for more
> details. (rsInternalError)
>
> If we run the same report again after we get this error, it works fine with
> the same parameters.
>
> The system is at SQL 2005 SP1 with the 2153 hotfix pack installed.
>
> The log file shows that an assertion is tripping in UpdateTimingInformation.
> Here is the log:
>
> w3wp!library!5!11/21/2006-13:06:44:: i INFO: Call to RenderFirst(
> '/FinancialReports/AssetListing2' )
> w3wp!processing!5!11/21/2006-13:06:48:: a ASSERT: Assertion failed! Call
> stack:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext
> jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64
> reportRenderingDurationMs)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension
> renderer, DateTime executionTimeStamp, GetReportChunk
> getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc,
> CreateReportChunk cacheDataCallback, Boolean& dataCached)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
> executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
> ProcessingContext pc, RenderingContext rc)
> Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
> reportContext, ItemProperties properties, ParameterInfoCollection
> effectiveParameters, Guid reportId, ClientRequest session, String
> description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
> thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport,
> Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime&
> executionDateTime, RuntimeDataSourceInfoCollection& alldataSources,
> UserProfileState& usedUserProfile)
> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
>
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
> Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> Microsoft.ReportingServices.Library.RenderReportAction.Render(String
> format, String deviceInfo)
> Microsoft.ReportingServices.WebServer.ReportExecutionService.InternalRender(String
> Format, String DeviceInfo, Stream& Result, String& Extension, String&
> MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
> Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format,
> String deviceInfo, String& extension, String& mimeType, String& encoding,
> String[]& streams, Warning[]& warnings)
> Microsoft.Reporting.WebForms.ServerReport.Render(String format, String
> deviceInfo, NameValueCollection additionalParams, String& mimeType, String&
> extension)
> Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String
> format, String deviceInfo, NameValueCollection additionalParams, String&
> mimeType, String& fileExtension)
> Microsoft.Reporting.WebForms.ReportControlSource.RenderReportHTML4(String
> deviceInfo)
> Microsoft.Reporting.WebForms.ReportControl.RenderReport(ReportControlSource
> controlSource, String instanceIdentifier, String navigationID, ZoomMode
> zoomMode, Int32 zoomPercent, Int32 pageNumber, String prefix, String
> searchText, String linkTarget, String replacementRoot, String alertMessage,
> Boolean enableFindNext, Boolean sizeToContent)
> Microsoft.Reporting.WebForms.ReportAreaPage.OnPreRender(EventArgs e)
> System.Web.UI.Control.PreRenderRecursiveInternal()
> System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint,
> Boolean includeStagesAfterAsyncPoint)
> System.Web.UI.Page.ProcessRequest()
> System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
> System.Web.UI.Page.ProcessRequest(HttpContext context)
> System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler,
> TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath
> path, VirtualPath filePath, String physPath, Exception error, String
> queryStringOverride)
> System.Web.HttpServerUtility.Transfer(IHttpHandler handler, Boolean
> preserveForm)
> Microsoft.Reporting.WebForms.ReportAreaPageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
> Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
> context)
> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> System.Web.HttpApplication.ResumeSteps(Exception error)
> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
>
> w3wp!library!5!11/21/2006-13:06:48:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details., un-named assertion fired for component processing;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details.
>
 | 
Pages: 1
Prev: Debugging Custom Assembly SSRS - Failed to load expression host as
Next: Encryption Key