I've been sufferring from the following error for weeks:
I'm accessing the reports through QueryString. Sometimes the reports work and sometimes not.
The content of the Reporting Services' log files are listed bellow:
(SQLDUMPER_ERRORLOG.log)
08/25/06 14:22:49, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 4012
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x14DB9AF4
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
08/25/06 14:22:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
08/25/06 14:22:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting Services\LogFiles\SQLDmpr0119.mdmp
08/25/06 14:22:51, ACTION, w3wp.exe, Watson Invoke: No
(SQLDmpr0118.log)
w3wp!library!8!8/25/2006-14:14:27:: 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.
w3wp!library!8!8/25/2006-14:14:59:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!9!8/25/2006-14:15:00:: i INFO: Call to RenderFirst( '/Reports/Report3' )
w3wp!processing!9!8/25/2006-14:15:00:: w WARN: The grouping expression for a category grouping returned a null value.
w3wp!library!1!8/25/2006-14:16:35:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!9!8/25/2006-14:16:35:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!25/8/2006-14:21:32:: i INFO: Call to RenderFirst( '/Reports/Report3' )
w3wp!processing!5!8/25/2006-14:21:32:: w WARN: The grouping expression for a category grouping returned a null value.
w3wp!processing!5!25/8/2006-14:21:32:: 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!25/8/2006-14:21:32:: 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.
I've reinstalled the SQL Server 2005 and the SP1 trying to solve this problem but it didn't work.
Is there anyone who can help me?
Thanks since now
Jo?o Talles Dantas Batista
jtdbf@.hotmail.com
Did you ever get a solution? We're seeing the same error re: "AdjustTokenPrivileges"|||
Not yet.
I've installed the SP1 and the HotFix2153. Even after this, I still have the same error.
It's very strange because the Microsoft's support asked me to do it, but it didn't work.
Have you tried anything different?
Jo?o Talles Dantas Batista
No comments:
Post a Comment