locked
An internal error occurred on the report server RRS feed

  • Question

  • Hi, I have SQL Server 2012 SP1 on Windows Server 2008 R2 SP1.

    When try to open a server report from an asp.net application using ReportViewer, This message will appear:

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

    Here is the details error from log file:

    library!ReportServer_0-2!6f4!11/12/2014-22:26:45:: w WARN: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
       at Microsoft.ReportingServices.Diagnostics.Utilities.RSServiceTraceInternal.FailInternal(String componentName, String message)
       at Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean condition, String message)
       at Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Boolean rawStreamRequested, ConnectionManager connectionManager, Boolean supportReadWrite, WriteOptions updateMode, Boolean isForUpgrade, String& mimeType)
       at Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, ConnectionManager connectionManager, Boolean supportReadWrite, WriteOptions updateMode, Boolean isForUpgrade, String& mimeType)
       at Microsoft.ReportingServices.Library.ServerSnapshot.GetChunk(String name, ReportChunkTypes type, Boolean supportReadWrite, WriteOptions updateMode, String& mimeType)
       at Microsoft.ReportingServices.Library.SnapshotManager.GetChunk(String name, ReportChunkTypes type, String& mimeType)
       at Microsoft.ReportingServices.Library.SnapshotManager.Microsoft.ReportingServices.ReportProcessing.IChunkFactory.GetChunk(String chunkName, ReportChunkTypes type, ChunkMode mode, String& mimeType)
       at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.DeserializeKatmaiReport(IChunkFactory chunkFactory, String chunkName, Boolean keepReferences, GlobalIDOwnerCollection globalIDOwnerCollection, IDOwner parentIDOwner, ReportItem parentReportItem)
       at Microsoft.ReportingServices.ReportProcessing.Execution.RenderReportOdpInitial.ProcessReport(ProcessingErrorContext errorContext, ExecutionLogContext executionLogContext, UserProfileState& userProfileState)
       at Microsoft.ReportingServices.ReportProcessing.Execution.RenderReport.Execute(IRenderingExtension newRenderer)
       at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition)
       at Microsoft.ReportingServices.Library.RenderLive.CallProcessingAndRendering(ProcessingContext pc, RenderingContext rc, OnDemandProcessingResult& result)
       at Microsoft.ReportingServices.Library.RenderStrategyBase.ExecuteStrategy(OnDemandProcessingResult& processingResult)
    webserver!ReportServer_0-2!6f4!11/12/2014-22:26:45:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
       at Microsoft.ReportingServices.Diagnostics.Utilities.RSServiceTraceInternal.FailInternal(String componentName, String message)
       at Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean condition, String message)
       at Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Boolean rawStreamRequested, ConnectionManager connectionManager, Boolean supportReadWrite, WriteOptions updateMode, Boolean isForUpgrade, String& mimeType)
       at Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, ConnectionManager connectionManager, Boolean supportReadWrite, WriteOptions updateMode, Boolean isForUpgrade, String& mimeType)
       at Microsoft.ReportingServices.Library.ServerSnapshot.GetChunk(String name, ReportChunkTypes type, Boolean supportReadWrite, WriteOptions updateMode, String& mimeType)
       at Microsoft.ReportingServices.Library.SnapshotManager.GetChunk(String name, ReportChunkTypes type, String& mimeType)
       at Microsoft.ReportingServices.Library.SnapshotManager.Microsoft.ReportingServices.ReportProcessing.IChunkFactory.GetChunk(String chunkName, ReportChunkTypes type, ChunkMode mode, String& mimeType)
       at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.DeserializeKatmaiReport(IChunkFactory chunkFactory, String chunkName, Boolean keepReferences, GlobalIDOwnerCollection globalIDOwnerCollection, IDOwner parentIDOwner, ReportItem parentReportItem)
       at Microsoft.ReportingServices.ReportProcessing.Execution.RenderReportOdpInitial.ProcessReport(ProcessingErrorContext errorContext, ExecutionLogContext executionLogContext, UserProfileState& userProfileState)
       at Microsoft.ReportingServices.ReportProcessing.Execution.RenderReport.Execute(IRenderingExtension newRenderer)
       at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition)
       at Microsoft.ReportingServices.Library.RenderLive.CallProcessingAndRendering(ProcessingContext pc, RenderingContext rc, OnDemandProcessingResult& result)
       at Microsoft.ReportingServices.Library.RenderStrategyBase.ExecuteStrategy(OnDemandProcessingResult& processingResult)
       --- End of inner exception stack trace ---
       at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
       at Microsoft.ReportingServices.Library.ExecutionDisposerProxy.ExecuteReport()
       at Microsoft.ReportingServices.Library.Re


    Wednesday, November 12, 2014 7:42 PM

Answers

  • Hi a.ch,

    According to your description, the error message “An internal error occurred on the report server. See the error log for more details. (rsInternalError)” was thrown out when you opened a report with ReportViewer in web application.

    Regarding the error message, it has reported the same error message thrown when a report contains Tablix control meeting the following conditions:

    • The Tablix control has at least one row group and at least one column group.
    • There are at least 100 instances of the column group.
    • The cell at the intersection of the row and column group contains a nested Tablix control, a chart, or other data regions.

    In your scenario, if the report meets conditions above, please install Cumulative update package 3 for SQL Server 2012 in your environment. For more information, please refer to this KB: FIX: rsInternalError error when you export a report that contains a Tablix control in SSRS 2008 R2 or in SSRS 2012.

    If issue persists, please check the Reporting Service error log (default location: %programfiles%\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles) around the time that issue occurs. It would be better if you can post the detail error message for our analysis.

    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu

    Friday, November 14, 2014 6:32 AM