订阅状态:报表处理过程中出错

Question

我很难通过SSRS发送自动生成的电子邮件。我收到一个模糊的错误，指出“在报表处理过程中发生了一个错误”。我已经在下面详细介绍了完整的错误。有没有人知道为什么我会得到这个错误的一些可能的原因？

以下是共享数据集属性的示例：

​

​

​

​

下面是我得到的错误：

library!WindowsService_9!14c0!07/11/2019-10:18:01:: i INFO: Schedule 3d1ac939-3fb6-4313-9e04-bce6353a6825 executed at 07/11/2019 10:18:01.
schedule!WindowsService_9!14c0!07/11/2019-10:18:01:: Creating Time based subscription notification for subscription: a9d6e90a-84fc-439d-b715-49f7479cf69d
library!WindowsService_9!14c0!07/11/2019-10:18:01:: i INFO: Schedule 3d1ac939-3fb6-4313-9e04-bce6353a6825 execution completed at 07/11/2019 10:18:01.
library!WindowsService_9!14c0!07/11/2019-10:18:01:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 1722, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
processing!WindowsService_9!14c0!07/11/2019-10:18:01:: e ERROR: An exception has occurred in data set 'DS_Example'. Details: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. 
processing!WindowsService_9!14c0!07/11/2019-10:18:01:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
processing!WindowsService_9!14c0!07/11/2019-10:18:01:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. 
   --- End of inner exception stack trace ---;
processing!WindowsService_9!14c0!07/11/2019-10:18:01:: w WARN: Data source ' Data source for shared dataset': Report processing has been aborted.
processing!WindowsService_9!14c0!07/11/2019-10:18:01:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. 
   --- End of inner exception stack trace ---;
library!WindowsService_9!14c0!07/11/2019-10:18:01:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.
notification!WindowsService_9!14c0!07/11/2019-10:18:01:: e ERROR: Error occured processing subscription a9d6e90a-84fc-439d-b715-49f7479cf69d: An error has occurred during report processing.

我运行了数据集引用的过程。数据生成时没有任何问题。我已经为现有报表创建了订阅，它们都可以正确地执行。我还检查了连接，以确认这不是凭据问题，但连接没有错误。

订阅应为指定用户生成每日报告。

Answer 1

因此，看起来需要授予服务帐户、数据库和表的权限。问题已解决！

Answer 2

Win32错误1722是此错误消息的关键。这是一个RPC服务器不可用错误。Microsoft有一篇关于这个问题的知识库文章：

https://support.microsoft.com/en-us/help/842423/a-call-to-the-authzinitializecontextfromsid-api-function-fails-during