locked
SSRS not responding ASSERT: Assertion failed RRS feed

  • Question

  • Hi all

     

    I am facing  this prob with SSRS.

    please sugges any solution.

     

    Problem:

     

    I have a few reports deployed on the report server.

     

    When I click them I get the following error

    • An internal error occurred on the report server. See the error log for more details. (rsInternalError)

     

    Checking the log file has the following entries

     

    w3wp!processing!1!10/12/2007-17:02:12:: a ASSERT: Assertion failed!   Call stack:

                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.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds) 

                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, Int32 searchStartPage, 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.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.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage) 

                System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm) 

                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!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;

     Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

    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

     


     

     

    The reportserver also generates SQLDumper log file and a crash dump file

     

    The  report executes fine sometime and sometime gives the error mentioned above.

    The reportserver at some point in time stopped doing anything.

    I tried to delete those reports created I couldn’t delete one report.

    When I try to delete it takes a long time and says request timeout error.

     

    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.

     

    I have the same reports deployed in another server where they are working fine.

    The database is SQL Server 2005 with SP2

    How do it solve this problem

     

    Friday, October 12, 2007 5:04 PM

Answers

  • 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 "Cool'n'Quiet" technology in the BIOS of the AMD box and report back if you still see the issue or not afterwards. More information in http://support.microsoft.com/kb/895980

     

    Additional information and trouble shooting information can also be found here: http://developer.amd.com/assets/TSC_Dual-Core_Utility.pdf

     

     

    -- Robert

     

    Friday, October 12, 2007 9:49 PM
  • 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.

     

    -- Robert

    Monday, October 15, 2007 10:42 PM
  • I just wanted to follow up regarding the failed assert call stack in UpdateTimingInformation or RenderReport (when inlined on x64).

     

    Cumulative update package #5 for SQL Server 2005 SP2 was released yesterday and is going to resolve this specific assert issue: http://support.microsoft.com/kb/943656/en-us

    Note that you will need to explicitly call Microsoft CSS (http://support.microsoft.com) and point them to the KB article to receive the update package.

     

    -- Robert

    Tuesday, December 18, 2007 7:12 PM
  • SCOM uses Reporting Services as underlying reporting platform.
     
    For the failed assert in UpdateTimingInformation, you have the following options:
    * install SP2 and Cumulative Update 5 or any later Cumulative Update for RS 2005 (see http://blogs.msdn.com/robertbruckner/pages/reporting-services-2005-resources.aspx)
    * or apply the system bios changes discussed at the top of this thread if you have AMD hardware.

    HTH,
    Robert
    Robert Bruckner; http://blogs.msdn.com/robertbruckner; This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, January 21, 2009 9:12 PM

All replies

  • 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 "Cool'n'Quiet" technology in the BIOS of the AMD box and report back if you still see the issue or not afterwards. More information in http://support.microsoft.com/kb/895980

     

    Additional information and trouble shooting information can also be found here: http://developer.amd.com/assets/TSC_Dual-Core_Utility.pdf

     

     

    -- Robert

     

    Friday, October 12, 2007 9:49 PM
  • thanks a lot robert.

     

    But i had the same reports deployed on my development server where they are working fine.

     

    The dev server is HP Proliant DL585 G1, AMD Opteron(tm) Processor 885 machine

    the UAT server is a HP Proliant DL585 G2, Dual-Core AMD Opteron(tm) machine

     

    is this issue on both the kind of servers.

     

    Monday, October 15, 2007 9:16 AM
  • 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.

     

    -- Robert

    Monday, October 15, 2007 10:42 PM
  • Hi robert

     

    You are right. the problem is only with the dual core processor.

    i ran a ping 127.0.0.1 -t on both servers. the dev server was giving consisten results.

    but the uat server(dual core) was giving inconsistent results.

    i have also changed the boot.ini file

    and now the reports are working perfect,

    thanks a lot for you help.

     

     

    hari

     

    Tuesday, October 16, 2007 11:29 AM
  • Hi!

     

    I've the same problem on an Intel Quad-Processor, sometimes the reports are renderd fine, sometimes there stopped with an error:

     

    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.
    w3wp!processing!1!10/17/2007-15:42:38:: 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!10/17/2007-15:42:38:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Interner

    ....

     

    Is there any idea?

     

    Torsten

    Wednesday, October 17, 2007 2:16 PM
  • Yes, this is the same class of issue in UpdateTimingInformation (which is inlined on x64 CLR). 

    Did you try checking with Intel support regarding timer drift on quad core CPUs?  Btw, the timer drift should be minimal after a hard-reboot.

     

    -- Robert

    Thursday, October 18, 2007 4:38 AM
  • I am continuously getting this exception when I deploy the report on the report server, but it works just fine on development machine through visual studio 2005.

     

    I am using SQL Server 2005 reporting services.

     

    Please let me know if anyone has encountered the similar error and solved it.

     

    Thanks in advance.

     

    ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "/Mintu/Y Report" is not allowed for this item type., ;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "/Mintu/Y Report" is not allowed for this item type.

    a ASSERT: Assertion failed!   Call stack:
     Microsoft.ReportingServices.ReportProcessing.ProcessingErrorContext.RegisterItem(Severity severity, ProcessingErrorCode code, ObjectType objectType, String objectName) 
     Microsoft.ReportingServices.ReportProcessing.ProcessingErrorContext.Register(ProcessingErrorCode code, Severity severity, ObjectType objectType, String objectName, String propertyName, ProcessingMessageList innerMessages, String[] arguments) 
     Microsoft.ReportingServices.ReportProcessing.ProcessingErrorContext.Register(ProcessingErrorCode code, Severity severity, ObjectType objectType, String objectName, String propertyName, String[] arguments) 
     Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.GetExternalImage(ProcessingContext processingContext, String currentPath, ObjectType objectType, String objectName, Byte[]& imageData, String& mimeType) 
     Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran) 
     Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context) 
     Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, Boolean snapshotProcessing, Boolean processWithCachedData, GetReportChunk getChunkCallback, ErrorContext errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback, ProcessingContext& context) 
     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, 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!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;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
    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

     

    Wednesday, November 28, 2007 9:07 PM
  • I just wanted to follow up regarding the failed assert call stack in UpdateTimingInformation or RenderReport (when inlined on x64).

     

    Cumulative update package #5 for SQL Server 2005 SP2 was released yesterday and is going to resolve this specific assert issue: http://support.microsoft.com/kb/943656/en-us

    Note that you will need to explicitly call Microsoft CSS (http://support.microsoft.com) and point them to the KB article to receive the update package.

     

    -- Robert

    Tuesday, December 18, 2007 7:12 PM
  • 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 "An internal error occurred on the report server. See the error log for more details. (rsInternalError)." When I look at the log file, my assertion error reads:

     

    w3wp!library!12!05/06/2008-14:46:52:: Call to GetSystemPermissionsAction().
    w3wp!library!1!05/06/2008-14:46:52:: Call to ListSchedulesAction().
    w3wp!library!1!05/06/2008-14:46:57:: Call to ListChildrenAction(/, False).
    w3wp!library!12!05/06/2008-14:46:58:: Call to ListChildrenAction(/Data Sources, False).
    w3wp!library!1!05/06/2008-14:46:59:: Call to ListChildrenAction(/ElectricalDistribution, False).
    w3wp!library!12!05/06/2008-14:48:43:: Call to GetPermissionsAction(/ElectricalDistribution/Substation L - Loop Peak Amps).
    w3wp!library!12!05/06/2008-14:48:43:: Call to GetPermissionsAction(/ElectricalDistribution/Substation L - Loop Peak Amps).
    w3wp!library!12!05/06/2008-14:48:43:: Call to GetPermissionsAction(/ElectricalDistribution/Substation L - Loop Peak Amps).
    w3wp!library!12!05/06/2008-14:48:43:: Call to GetPermissionsAction(/ElectricalDistribution/Substation L - Loop Peak Amps).
    w3wp!library!12!05/06/2008-14:48:43:: Call to GetPermissionsAction(/ElectricalDistribution).
    w3wp!library!12!05/06/2008-14:48:43:: Call to GetPermissionsAction(/ElectricalDistribution/Substation L - Loop Peak Amps).
    w3wp!library!1!05/06/2008-14:48:43:: Call to GetPropertiesAction(/ElectricalDistribution/Substation L - Loop Peak Amps, PathBased).
    w3wp!library!12!05/06/2008-14:48:46:: Call to GetSystemPermissionsAction().
    w3wp!library!12!05/06/2008-14:48:46:: Call to GetPropertiesAction(/ElectricalDistribution/Substation L - Loop Peak Amps, PathBased).
    w3wp!library!1!05/06/2008-14:48:47:: Call to DeleteItemAction(/ElectricalDistribution/Substation L - Loop Peak Amps).
    w3wp!library!1!05/06/2008-14:48:47:: a ASSERT: Assertion failed!   Call stack:
     Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow() 
     Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() 
     Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String Item) 
     Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String Item) 
     System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) 
     System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) 
     System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) 
     System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) 
     System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values) 
     System.Web.Services.Protocols.WebServiceHandler.Invoke() 
     System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest() 
     System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context) 
     System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 
     System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 
     System.Web.HttpApplication+ApplicationStepManager.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!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;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
    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

     


     

    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.

    Tuesday, May 6, 2008 8:11 PM
  • Uninstalling 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.

     

    Wednesday, May 14, 2008 2:50 PM
  • I have the same error here please help me:
    Im running scom 2007.

    w3wp!library!e!01/21/2009-13:18:20:: Call to GetResourceContentsAction(/Microsoft.Windows.Server.2003/Report.Windows.Server.2003.PerformanceHistory.rpdl).
    w3wp!library!e!01/21/2009-13:18:39:: i INFO: Call to RenderFirst( '/Microsoft.Windows.Server.2003/Report.Windows.Server.2003.PerformanceHistory' )
    w3wp!processing!e!01/21/2009-13:18:40:: 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+ApplicationStepManager.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!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;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

    Wednesday, January 21, 2009 6:32 PM
  • SCOM uses Reporting Services as underlying reporting platform.
     
    For the failed assert in UpdateTimingInformation, you have the following options:
    * install SP2 and Cumulative Update 5 or any later Cumulative Update for RS 2005 (see http://blogs.msdn.com/robertbruckner/pages/reporting-services-2005-resources.aspx)
    * or apply the system bios changes discussed at the top of this thread if you have AMD hardware.

    HTH,
    Robert
    Robert Bruckner; http://blogs.msdn.com/robertbruckner; This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, January 21, 2009 9:12 PM
  • Hey Robert,

    I applied the SQL SP3 and works perfectly :D tnks for your time.

    srry for the delay in posting...

    reporting.!!!....

    Friday, February 13, 2009 4:51 PM
  • I was experiencing this same error just recently on SSRS with build 9.00.5000. 

    My solution was this:

     

    The resolution for us was to use a utility "RS Scripter" we scripted the reports out of SSRS and 
    then re-imported the reports back onto the same SSRS instance with a different folder name (these could 
    be rename back to the originals after the imports completed).  Then we have to reset the DataSource connections.  
    The reporting links appear to be working correctly now.
    
    Unfortunately, no SP or additional updates would resolve the issue.
    Thursday, January 19, 2012 5:17 PM