SSRS not responding ASSERT: Assertion failed<p align=left><font face=Arial size=2>Hi all </font></p> <p align=left> </p> <p align=left>I am facing  this prob with SSRS.</p> <p align=left>please sugges any solution.</p> <p align=left> </p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><font face="Times New Roman"><b><span style="font-size:11pt">Problem</span></b><span style="font-size:11pt">:</span></font></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">I have a few reports deployed on the report server.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">When I click them I get the following error</font></span></p> <ul style="margin-top:0cm" type=disc> <li class=MsoNormal style="margin:12pt 0cm 0pt;tab-stops:list 36.0pt"><b><span style="font-size:11pt;font-family:Verdana">An internal error occurred on the report server. See the error log for more details. (rsInternalError) </span></b></li></ul> <p class=MsoNormal style="margin:0cm 0cm 0pt"><b><span style="font-size:11pt"><font face="Times New Roman"> </font></span></b></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><b><span style="font-size:11pt"><font face="Times New Roman">Checking the log file has the following entries</font></span></b></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">w3wp!processing!1!10/12/2007-17:02:12:: a ASSERT: Assertion failed!<span style="">   </span>Call stack:</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean&amp; dataCached)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>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[]&amp; warnings, ReportSnapshot&amp; resultSnapshotData, DateTime&amp; executionDateTime, RuntimeDataSourceInfoCollection&amp; alldataSources, UserProfileState&amp; usedUserProfile)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters, String[]&amp; secondaryStreamNames)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters, String[]&amp; secondaryStreamNames)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.Library.RenderReportAction.Render(String format, String deviceInfo)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, Stream&amp; Result, String&amp; Extension, String&amp; MimeType, String&amp; Encoding, Warning[]&amp; Warnings, String[]&amp; StreamIds)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.WebServer.ReportExecutionService.InternalRender(String Format, String DeviceInfo, Stream&amp; Result, String&amp; Extension, String&amp; MimeType, String&amp; Encoding, Warning[]&amp; Warnings, String[]&amp; StreamIds)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format, String deviceInfo, String&amp; extension, String&amp; mimeType, String&amp; encoding, String[]&amp; streams, Warning[]&amp; warnings)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection additionalParams, String&amp; mimeType, String&amp; extension)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String&amp; mimeType, String&amp; fileExtension)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.ReportControlSource.RenderReportHTML4(String deviceInfo)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>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, Int32 searchStartPage, Boolean sizeToContent)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.ReportAreaPage.OnPreRender(EventArgs e)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.UI.Control.PreRenderRecursiveInternal()<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.UI.Page.ProcessRequest()<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.UI.Page.ProcessRequest(HttpContext context)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpServerUtility.Transfer(IHttpHandler handler, Boolean preserveForm)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.ReportAreaPageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpApplication.ResumeSteps(Exception error)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">w3wp!library!1!10/12/2007-17:02:12:: 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;</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style=""> </span>Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">w3wp!library!1!10/12/2007-17:02:15:: i INFO: Exception dumped to: C:\apps_srv\SQL 2005 Analysis Services\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p><span style="font-size:11pt;font-family:'Times New Roman'"><br style="page-break-before:always" clear=all></span> <p class=MsoNormal style="margin:0cm 0cm 0pt"><font face="Times New Roman"> <span style="font-size:11pt"></span></font></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <h1 style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">The reportserver also generates SQLDumper log file and a crash dump file</font></span></h1> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">The<span style="">  </span>report executes fine sometime and sometime gives the error mentioned above.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">The reportserver at some point in time stopped doing anything.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">I tried to delete those reports created I couldn’t delete one report.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">When I try to delete it takes a long time and says request timeout error.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">Then I opened the web.config file of reportserver and report manager and just saved it so that the application reloads. And then it worked fine for few moments. I was also able to delete that report which was not getting deleted before. But after some time I again get the assertion failed error.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">I have the same reports deployed in another server where they are working fine.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">The database is SQL Server 2005 with SP2</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">How do it solve this problem</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p>© 2009 Microsoft Corporation. All rights reserved.Fri, 13 Feb 2009 16:51:41 Z60228c86-e6f2-4f5b-91fb-5634676a1cc6http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#60228c86-e6f2-4f5b-91fb-5634676a1cc6http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#60228c86-e6f2-4f5b-91fb-5634676a1cc6Hari Ganeshanhttp://social.msdn.microsoft.com/Profile/en-US/?user=Hari%20GaneshanSSRS not responding ASSERT: Assertion failed<p align=left><font face=Arial size=2>Hi all </font></p> <p align=left> </p> <p align=left>I am facing  this prob with SSRS.</p> <p align=left>please sugges any solution.</p> <p align=left> </p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><font face="Times New Roman"><b><span style="font-size:11pt">Problem</span></b><span style="font-size:11pt">:</span></font></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">I have a few reports deployed on the report server.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">When I click them I get the following error</font></span></p> <ul style="margin-top:0cm" type=disc> <li class=MsoNormal style="margin:12pt 0cm 0pt;tab-stops:list 36.0pt"><b><span style="font-size:11pt;font-family:Verdana">An internal error occurred on the report server. See the error log for more details. (rsInternalError) </span></b></li></ul> <p class=MsoNormal style="margin:0cm 0cm 0pt"><b><span style="font-size:11pt"><font face="Times New Roman"> </font></span></b></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><b><span style="font-size:11pt"><font face="Times New Roman">Checking the log file has the following entries</font></span></b></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">w3wp!processing!1!10/12/2007-17:02:12:: a ASSERT: Assertion failed!<span style="">   </span>Call stack:</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean&amp; dataCached)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>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[]&amp; warnings, ReportSnapshot&amp; resultSnapshotData, DateTime&amp; executionDateTime, RuntimeDataSourceInfoCollection&amp; alldataSources, UserProfileState&amp; usedUserProfile)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters, String[]&amp; secondaryStreamNames)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters, String[]&amp; secondaryStreamNames)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.Library.RenderReportAction.Render(String format, String deviceInfo)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, Stream&amp; Result, String&amp; Extension, String&amp; MimeType, String&amp; Encoding, Warning[]&amp; Warnings, String[]&amp; StreamIds)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.ReportingServices.WebServer.ReportExecutionService.InternalRender(String Format, String DeviceInfo, Stream&amp; Result, String&amp; Extension, String&amp; MimeType, String&amp; Encoding, Warning[]&amp; Warnings, String[]&amp; StreamIds)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format, String deviceInfo, String&amp; extension, String&amp; mimeType, String&amp; encoding, String[]&amp; streams, Warning[]&amp; warnings)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection additionalParams, String&amp; mimeType, String&amp; extension)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String&amp; mimeType, String&amp; fileExtension)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.ReportControlSource.RenderReportHTML4(String deviceInfo)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>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, Int32 searchStartPage, Boolean sizeToContent)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.ReportAreaPage.OnPreRender(EventArgs e)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.UI.Control.PreRenderRecursiveInternal()<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.UI.Page.ProcessRequest()<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.UI.Page.ProcessRequest(HttpContext context)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpServerUtility.Transfer(IHttpHandler handler, Boolean preserveForm)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.ReportAreaPageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpApplication.ResumeSteps(Exception error)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style="">            </span>System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)<span style="">  </span></font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">w3wp!library!1!10/12/2007-17:02:12:: 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;</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"><span style=""> </span>Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">w3wp!library!1!10/12/2007-17:02:15:: i INFO: Exception dumped to: C:\apps_srv\SQL 2005 Analysis Services\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p><span style="font-size:11pt;font-family:'Times New Roman'"><br style="page-break-before:always" clear=all></span> <p class=MsoNormal style="margin:0cm 0cm 0pt"><font face="Times New Roman"> <span style="font-size:11pt"></span></font></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <h1 style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">The reportserver also generates SQLDumper log file and a crash dump file</font></span></h1> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">The<span style="">  </span>report executes fine sometime and sometime gives the error mentioned above.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">The reportserver at some point in time stopped doing anything.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">I tried to delete those reports created I couldn’t delete one report.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">When I try to delete it takes a long time and says request timeout error.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">Then I opened the web.config file of reportserver and report manager and just saved it so that the application reloads. And then it worked fine for few moments. I was also able to delete that report which was not getting deleted before. But after some time I again get the assertion failed error.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">I have the same reports deployed in another server where they are working fine.</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">The database is SQL Server 2005 with SP2</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman">How do it solve this problem</font></span></p> <p class=MsoNormal style="margin:0cm 0cm 0pt"><span style="font-size:11pt"><font face="Times New Roman"> </font></span></p>Fri, 12 Oct 2007 17:04:40 Z2007-11-29T01:59:01Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#7650c354-8c53-40ea-892b-cbbadba23179http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#7650c354-8c53-40ea-892b-cbbadba23179Robert Brucknerhttp://social.msdn.microsoft.com/Profile/en-US/?user=Robert%20BrucknerSSRS not responding ASSERT: Assertion failed<p>I have seen a similar assert, which however affects only certain 64 bit multi-proc/multi-core AMD hardware.  So, if your hardware is AMD 64 bit, please try to disable the &quot;Cool'n'Quiet&quot; technology in the BIOS of the AMD box and report back if you still see the issue or not afterwards. More information in <a title="http://support.microsoft.com/kb/895980" href="http://support.microsoft.com/kb/895980">http://support.microsoft.com/kb/895980</a></p> <p> </p> <p>Additional information and trouble shooting information can also be found here: <a title="http://developer.amd.com/assets/TSC_Dual-Core_Utility.pdf" href="http://developer.amd.com/assets/TSC_Dual-Core_Utility.pdf">http://developer.amd.com/assets/TSC_Dual-Core_Utility.pdf</a> </p> <p> </p> <p> </p> <p>-- Robert<br></p> <p> </p>Fri, 12 Oct 2007 21:49:56 Z2007-11-29T01:59:01Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#4a07fb8a-0737-4b35-b410-14e76d99f219http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#4a07fb8a-0737-4b35-b410-14e76d99f219Hari Ganeshanhttp://social.msdn.microsoft.com/Profile/en-US/?user=Hari%20GaneshanSSRS not responding ASSERT: Assertion failed<p align=left><font face=Arial size=2>thanks a lot robert.</font></p> <p align=left> </p> <p align=left>But i had the same reports deployed on my development server where they are working fine.</p> <p align=left> </p> <p align=left>The dev server is HP Proliant DL585 G1, AMD Opteron(tm) Processor 885 machine</p> <p align=left>the UAT server is a HP Proliant DL585 G2, Dual-Core AMD Opteron(tm) machine</p> <p align=left> </p> <p align=left>is this issue on both the kind of servers.</p> <p align=left> </p>Mon, 15 Oct 2007 09:16:28 Z2007-10-15T09:16:28Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#f2ad6184-2e5f-4d97-814a-4aec0c998237http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#f2ad6184-2e5f-4d97-814a-4aec0c998237Robert Brucknerhttp://social.msdn.microsoft.com/Profile/en-US/?user=Robert%20BrucknerSSRS not responding ASSERT: Assertion failed<p align=left>I guess you will need to check the AMD support site, but it seems your dev server is not a dual-core machine and that might be the reason why it works fine there.</p> <p align=left> </p> <p align=left>-- Robert</p>Mon, 15 Oct 2007 22:42:25 Z2007-10-16T11:30:30Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#6393c93c-6327-4734-a47b-3b39da5475c8http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#6393c93c-6327-4734-a47b-3b39da5475c8Hari Ganeshanhttp://social.msdn.microsoft.com/Profile/en-US/?user=Hari%20GaneshanSSRS not responding ASSERT: Assertion failed<p>Hi robert</p> <p align=left> </p> <p align=left>You are right. the problem is only with the dual core processor.</p> <p align=left>i ran a ping 127.0.0.1 -t on both servers. the dev server was giving consisten results.</p> <p align=left>but the uat server(dual core) was giving inconsistent results.</p> <p align=left>i have also changed the boot.ini file</p> <p align=left>and now the reports are working perfect,</p> <p align=left>thanks a lot for you help.</p> <p align=left> </p> <p align=left> </p> <p align=left>hari</p> <p align=left><font face=Arial size=2></font> </p>Tue, 16 Oct 2007 11:29:14 Z2007-10-16T11:29:14Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#e1f55ea2-7c3d-4903-84bb-e9b1b49bedc4http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#e1f55ea2-7c3d-4903-84bb-e9b1b49bedc4Torsten_Katthoeferhttp://social.msdn.microsoft.com/Profile/en-US/?user=Torsten_KatthoeferSSRS not responding ASSERT: Assertion failed<p align=left><font face=Arial size=2>Hi!</font></p> <p align=left> </p> <p align=left>I've the same problem on an Intel Quad-Processor, sometimes the reports are renderd fine, sometimes there stopped with an error:</p> <p align=left> </p> <p align=left>w3wp!library!1!10/17/2007-15:42:38:: Using folder C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\RSTempFiles for temporary files.<br>w3wp!processing!1!10/17/2007-15:42:38:: a ASSERT: Assertion failed!   Call stack:<br> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs)  <br> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean&amp; dataCached)  <br> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)  <br> 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[]&amp; warnings, ReportSnapshot&amp; resultSnapshotData, DateTime&amp; executionDateTime, RuntimeDataSourceInfoCollection&amp; alldataSources, UserProfileState&amp; usedUserProfile)  <br> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters)  <br> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters, String[]&amp; secondaryStreamNames)  <br> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()  <br> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()  <br> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters, String[]&amp; secondaryStreamNames)  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)  <br> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()  <br> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)  <br> System.Web.HttpApplication.ResumeSteps(Exception error)  <br> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)  <br> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)  <br> System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)  <br> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)  </p> <p align=left>w3wp!library!1!10/17/2007-15:42:38:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Interner </p> <p align=left>....</p> <p> </p> <p align=left>Is there any idea?</p> <p align=left> </p> <p align=left>Torsten</p>Wed, 17 Oct 2007 14:16:10 Z2007-10-17T14:16:10Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#b5c8a013-da6e-4527-b820-409cd4996a63http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#b5c8a013-da6e-4527-b820-409cd4996a63Robert Brucknerhttp://social.msdn.microsoft.com/Profile/en-US/?user=Robert%20BrucknerSSRS not responding ASSERT: Assertion failed<p align=left><font face=Arial size=2>Yes, this is the same class of issue in UpdateTimingInformation (which is inlined on x64 CLR).  </font></p> <p align=left><font face=Arial size=2>Did you try checking with Intel support regarding timer drift on quad core CPUs?  </font>Btw, the timer drift should be minimal after a hard-reboot.</p> <p align=left> </p> <p align=left>-- Robert</p>Thu, 18 Oct 2007 04:38:56 Z2007-10-18T04:38:56Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#eb070803-3d19-456e-872b-c64adf374405http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#eb070803-3d19-456e-872b-c64adf374405softambrishhttp://social.msdn.microsoft.com/Profile/en-US/?user=softambrishSSRS not responding ASSERT: Assertion failed<p>I am c<span style="font-size:10pt;font-family:Arial">ontinuously getting this exception when I deploy the report on the report server, but it works just fine on development machine through visual studio 2005.</span></p> <p align=left><span style="font-size:10pt;font-family:Arial"></span> </p> <p align=left><span style="font-size:10pt;font-family:Arial">I am using SQL Server 2005 reporting services.</span></p> <p align=left><span style="font-size:10pt;font-family:Arial"></span> </p> <p align=left><span style="font-size:10pt;font-family:Arial">Please let me know if anyone has encountered the similar error and solved it.</span></p> <p align=left><span style="font-size:10pt;font-family:Arial"></span> </p> <p align=left><span style="font-size:10pt;font-family:Arial">Thanks in advance.</span></p> <p align=left><span style="font-size:10pt;font-family:Arial"></span> </p> <p align=left>ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item &quot;/Mintu/Y Report&quot; is not allowed for this item type., ;<br> Info: <strong><font color="#ff0000">Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException</font></strong>: The operation you are attempting on item &quot;/Mintu/Y Report&quot; is not allowed for this item type.</p> <p align=left><strong><font color="#ff0000">a ASSERT: Assertion failed!   Call stack:</font></strong><br> Microsoft.ReportingServices.ReportProcessing.ProcessingErrorContext.RegisterItem(Severity severity, ProcessingErrorCode code, ObjectType objectType, String objectName)  <br> Microsoft.ReportingServices.ReportProcessing.ProcessingErrorContext.Register(ProcessingErrorCode code, Severity severity, ObjectType objectType, String objectName, String propertyName, ProcessingMessageList innerMessages, String[] arguments)  <br> Microsoft.ReportingServices.ReportProcessing.ProcessingErrorContext.Register(ProcessingErrorCode code, Severity severity, ObjectType objectType, String objectName, String propertyName, String[] arguments)  <br> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.GetExternalImage(ProcessingContext processingContext, String currentPath, ObjectType objectType, String objectName, Byte[]&amp; imageData, String&amp; mimeType)  <br> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran)  <br> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context)  <br> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, Boolean snapshotProcessing, Boolean processWithCachedData, GetReportChunk getChunkCallback, ErrorContext errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback, ProcessingContext&amp; context)  <br> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean&amp; dataCached)  <br> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)  <br> Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Warning[]&amp; warnings, ReportSnapshot&amp; resultSnapshotData, DateTime&amp; executionDateTime, RuntimeDataSourceInfoCollection&amp; alldataSources, UserProfileState&amp; usedUserProfile)  <br> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters)  <br> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters, String[]&amp; secondaryStreamNames)  <br> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()  <br> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()  <br> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters, String[]&amp; secondaryStreamNames)  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)  <br> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()  <br> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)  <br> System.Web.HttpApplication.ResumeSteps(Exception error)  <br> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)  <br> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)  <br> System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)  <br> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)  </p> <p>w3wp!library!7!11/27/2007-08:14:39:: 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;<br> Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.<br>w3wp!library!7!11/27/2007-08:14:41:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson</p> <p align=left><font face=Arial size=2></font> </p>Wed, 28 Nov 2007 21:07:58 Z2007-11-28T21:07:58Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#b3d811f5-c2bf-4846-b057-a67782362a13http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#b3d811f5-c2bf-4846-b057-a67782362a13Robert Brucknerhttp://social.msdn.microsoft.com/Profile/en-US/?user=Robert%20BrucknerSSRS not responding ASSERT: Assertion failed<p align=left><font face=Arial size=2>I just wanted to follow up regarding the failed assert call stack in UpdateTimingInformation or RenderReport (when inlined on x64).</font></p> <p align=left> </p> <p align=left>Cumulative update package #5 for SQL Server 2005 SP2 was released yesterday and is going to resolve this specific assert issue: <a title="http://support.microsoft.com/kb/943656/en-us" href="http://support.microsoft.com/kb/943656/en-us">http://support.microsoft.com/kb/943656/en-us</a></p> <p align=left>Note that you will need to explicitly call Microsoft CSS (<a title="http://support.microsoft.com" href="http://support.microsoft.com">http://support.microsoft.com</a>) and point them to the KB article to receive the update package.</p> <p align=left> </p> <p align=left>-- Robert</p>Tue, 18 Dec 2007 19:12:26 Z2007-12-18T19:12:26Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#258d89b0-bd00-4633-baa0-cc9db25f8401http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#258d89b0-bd00-4633-baa0-cc9db25f8401WFPainterhttp://social.msdn.microsoft.com/Profile/en-US/?user=WFPainterSSRS not responding ASSERT: Assertion failed<p align=left>I'm having a similar Assertion error, but doesn't seem to have to do with UpdateTimingInformation or RenderReport. I don't have any issue viewing reports on either the server or a client, and I am able to deploy reports from my development machine to the report server without issue. However, whether I'm in report manager web interface or the SQL Server Management Studio, I cannot delete any of my reports. The error it gives me is &quot;An internal error occurred on the report server. See the error log for more details. (rsInternalError).&quot; When I look at the log file, my assertion error reads:</p> <p align=left> </p> <p>w3wp!library!12!05/06/2008-14:46:52:: Call to GetSystemPermissionsAction().<br>w3wp!library!1!05/06/2008-14:46:52:: Call to ListSchedulesAction().<br>w3wp!library!1!05/06/2008-14:46:57:: Call to ListChildrenAction(/, False).<br>w3wp!library!12!05/06/2008-14:46:58:: Call to ListChildrenAction(/Data Sources, False).<br>w3wp!library!1!05/06/2008-14:46:59:: Call to ListChildrenAction(/ElectricalDistribution, False).<br>w3wp!library!12!05/06/2008-14:48:43:: Call to GetPermissionsAction(/ElectricalDistribution/Substation L - Loop Peak Amps).<br>w3wp!library!12!05/06/2008-14:48:43:: Call to GetPermissionsAction(/ElectricalDistribution/Substation L - Loop Peak Amps).<br>w3wp!library!12!05/06/2008-14:48:43:: Call to GetPermissionsAction(/ElectricalDistribution/Substation L - Loop Peak Amps).<br>w3wp!library!12!05/06/2008-14:48:43:: Call to GetPermissionsAction(/ElectricalDistribution/Substation L - Loop Peak Amps).<br>w3wp!library!12!05/06/2008-14:48:43:: Call to GetPermissionsAction(/ElectricalDistribution).<br>w3wp!library!12!05/06/2008-14:48:43:: Call to GetPermissionsAction(/ElectricalDistribution/Substation L - Loop Peak Amps).<br>w3wp!library!1!05/06/2008-14:48:43:: Call to GetPropertiesAction(/ElectricalDistribution/Substation L - Loop Peak Amps, PathBased).<br>w3wp!library!12!05/06/2008-14:48:46:: Call to GetSystemPermissionsAction().<br>w3wp!library!12!05/06/2008-14:48:46:: Call to GetPropertiesAction(/ElectricalDistribution/Substation L - Loop Peak Amps, PathBased).<br>w3wp!library!1!05/06/2008-14:48:47:: Call to DeleteItemAction(/ElectricalDistribution/Substation L - Loop Peak Amps).<br>w3wp!library!1!05/06/2008-14:48:47:: a ASSERT: Assertion failed!   Call stack:<br> Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()  <br> Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()  <br> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String Item)  <br> Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String Item)  <br> System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct&amp; sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)  <br> System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)  <br> System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)  <br> System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)  <br> System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)  <br> System.Web.Services.Protocols.WebServiceHandler.Invoke()  <br> System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()  <br> System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)  <br> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()  <br> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)  <br> System.Web.HttpApplication+ApplicationStepManager.ResumeSteps(Exception error)  <br> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)  <br> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)  <br> System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)  <br> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)  </p> <p>w3wp!library!1!05/06/2008-14:48:47:: 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 library;<br> Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.<br>w3wp!library!1!05/06/2008-14:48:48:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson</p> <p align=left> </p> <p align=left><br> </p> <p align=left>The server is a Intel Dual core and I am running SQL Server 2005 SP2. CORRECTION: The server is an Intel dual processor, not dual core.</p>Tue, 06 May 2008 20:11:44 Z2008-05-06T20:11:44Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#b3ae147d-eeb6-4aff-8973-a7234276e6fdhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#b3ae147d-eeb6-4aff-8973-a7234276e6fdWFPainterhttp://social.msdn.microsoft.com/Profile/en-US/?user=WFPainterSSRS not responding ASSERT: Assertion failedUninstalling all of SQL Server 2005, including the native client and manually deleteing the remaining directories, and reinstalling it fresh seems to have solved my issue. My only guess is that I had a corrupted installation when I upgraded from SQL 2000 to 2005 or when I applied Service Pack 2. <p align=left><font face=Arial size=2></font> </p>Wed, 14 May 2008 14:50:34 Z2008-05-14T14:50:34Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#12ac018a-9a55-4d2d-9606-1826fe2ffea9http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#12ac018a-9a55-4d2d-9606-1826fe2ffea9edTraininghttp://social.msdn.microsoft.com/Profile/en-US/?user=edTrainingSSRS not responding ASSERT: Assertion failed I have the same error here please help me:<br>Im running scom 2007.<br><br> <p>w3wp!library!e!01/21/2009-13:18:20:: Call to GetResourceContentsAction(/Microsoft.Windows.Server.2003/Report.Windows.Server.2003.PerformanceHistory.rpdl).<br>w3wp!library!e!01/21/2009-13:18:39:: i INFO: Call to RenderFirst( '/Microsoft.Windows.Server.2003/Report.Windows.Server.2003.PerformanceHistory' )<br>w3wp!processing!e!01/21/2009-13:18:40:: <strong><font color="#ff0000">a ASSERT: Assertion failed</font></strong>!   Call stack:<br> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs)  <br> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean&amp; dataCached)  <br> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)  <br> 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[]&amp; warnings, ReportSnapshot&amp; resultSnapshotData, DateTime&amp; executionDateTime, RuntimeDataSourceInfoCollection&amp; alldataSources, UserProfileState&amp; usedUserProfile)  <br> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters)  <br> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters, String[]&amp; secondaryStreamNames)  <br> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()  <br> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()  <br> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]&amp; warnings, ParameterInfoCollection&amp; effectiveParameters, String[]&amp; secondaryStreamNames)  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()  <br> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)  <br> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()  <br> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)  <br> System.Web.HttpApplication+ApplicationStepManager.ResumeSteps(Exception error)  <br> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)  <br> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)  <br> System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)  <br> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)  </p> <p>w3wp!library!e!01/21/2009-13:18:40:: 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;<br> Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.</p>Wed, 21 Jan 2009 18:32:18 Z2009-01-21T18:34:10Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#57788d9e-0db4-49bf-a925-b9d489ed3533http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#57788d9e-0db4-49bf-a925-b9d489ed3533Robert Brucknerhttp://social.msdn.microsoft.com/Profile/en-US/?user=Robert%20BrucknerSSRS not responding ASSERT: Assertion failedSCOM uses Reporting Services as underlying reporting platform.<br> <br>For the failed assert in UpdateTimingInformation, you have the following options:<br>* install SP2 and Cumulative Update 5 or any later Cumulative Update for RS 2005 (see <a href="http://blogs.msdn.com/robertbruckner/pages/reporting-services-2005-resources.aspx">http://blogs.msdn.com/robertbruckner/pages/reporting-services-2005-resources.aspx</a>)<br>* or apply the system bios changes discussed at the top of this thread if you have AMD hardware.<br><br>HTH,<br>Robert <hr class=sig> Robert Bruckner; http://blogs.msdn.com/robertbruckner; This posting is provided &quot;AS IS&quot; with no warranties, and confers no rights.Wed, 21 Jan 2009 21:12:29 Z2009-01-21T21:13:05Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#cf29ef66-c449-4f43-b5ec-97442131f570http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/60228c86-e6f2-4f5b-91fb-5634676a1cc6#cf29ef66-c449-4f43-b5ec-97442131f570edTraininghttp://social.msdn.microsoft.com/Profile/en-US/?user=edTrainingSSRS not responding ASSERT: Assertion failed<p>Hey Robert,<br><br>I applied the SQL SP3 and works perfectly :D tnks for your time.<br><br>srry for the delay in posting...<br><br>reporting.!!!....</p>Fri, 13 Feb 2009 16:51:38 Z2009-02-13T16:51:38Z