RS integrated with MOSS - Internal Error - AdjustTokenPrivileges

I'm running MOSS 2007 Enterprise, SQL 2005 SP2, RS integrated with MOSS and have a number of reports deployed to a Reports Library in MOSS. 3 out of 10 times I run a report I get a error message stating that 'An internal error occured on the report server.' Just hitting Apply on the parameter panel will fix the problem and render the report as expected.

Previous entries to the forum about this error hints at an error that supposedly was fixed in SP2; since I'm running SP2 something else must be the problem.

Any insight to what might cause the problem ?

Regards,

Trond

Relevant content from the RS error log included below:

04/26/07 11:42:21, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ProcessID = 7008

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ThreadId = 0

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,Flags = 0x0

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,MiniDumpFlags = 0x0

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,SqlInfoPtr = 0x47405860

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,DumpDir = <NULL>

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ExceptionRecordPtr = 0x00000000

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ContextPtr = 0x00000000

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ExtraFile = <NULL>

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,InstanceName = <NULL>

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ServiceName = <NULL>

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used

04/26/07 11:42:23, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used

04/26/07 11:42:23, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0147.mdmp

04/26/07 11:42:23, ACTION,w3wp.exe, Watson Invoke: No

w3wp!processing!1!4/26/2007-11:42:21:: 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.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)

Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)

Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)

Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()

Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()

Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.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!1!4/26/2007-11:42:21:: 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.

Reapplying SP2, rebooting and then reapplying SP2 once more because I got frustrated beyond what's good for my health, seems to have fixed this issue.

Why the initial and the second SP2 didn't help is beyond my understanding.

Trond