reporting-services - SSRS 2008 不呈现报告

Question

我有几台计算机可以毫无问题地呈现大型报告，但是，其他几台计算机无法呈现报告和崩溃报告服务。

我们有 SQL Server 2008 R2 SP1，我们观察到在呈现此报表时，Reporting Services 应用程序的内存使用量从 300MB 增加到 1.2GB。

当这个报告崩溃时，我们有日志文件:

rshost!rshost!4cf0!06/26/2013-10:33:38:: e ERROR: WriteCallback(): failed to write in write callback.
rshost!rshost!4cf0!06/26/2013-10:33:38:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x00000000063D2400.
rshost!rshost!106c!06/26/2013-10:33:38:: e ERROR: HttpPipelineCallback::SendResponse(): failed async writing response.
rshost!rshost!106c!06/26/2013-10:33:38:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x00000000063D2400.
httpruntime!ReportServer_0-1!106c!06/26/2013-10:33:38:: e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool), exception=System.Runtime.InteropServices.COMException (0x800703E3): The I/O operation has been aborted because of either a thread exit or an application request. (Exception from HRESULT: 0x800703E3)
   at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.SendResponse(Void* response, Boolean finalWrite, Boolean closeConn)
   at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
library!ReportServer_0-1!106c!06/26/2013-10:33:38:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: RsWorkerRequest::FlushResponse., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0-1-130167083080132500.  ---> System.Runtime.InteropServices.COMException (0x800703E3): The I/O operation has been aborted because of either a thread exit or an application request. (Exception from HRESULT: 0x800703E3)
   at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
   at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)
   --- End of inner exception stack trace ---;

知道什么会产生这个错误吗？为什么这会出现在某些计算机中，而在其他计算机中一切正常？

提前致谢。

Answer 1

如果您使用的是 Server Reporting Services(在线界面)，并且最终用户(仅阅读您的报告)出现了问题，最重要的是您要确保报告工作正常。

您可以先尝试缓存报告。这可能会解决您的问题，并使最终用户更满意，因为报告的加载速度将非常快。

您可以在此处阅读有关缓存的信息:https://docs.microsoft.com/en-us/sql/reporting-services/report-server/caching-reports-ssrs

这里有一些关于如何设置缓存的旧说明:
http://bhushan.extreme-advice.com/caching-ssrs-reports/

顺便说一句，您还应该确保:
-用户与您拥有相同的权利
- 文件是最新的，可供所有用户使用

从这里很难说可能是什么问题。如果缓存无助于解决此问题，请尝试使用缓存...它肯定会将您的报告和客户的幸福提升到新的水平。

干杯，
卡帕