We recently discovered the below error in our log which happened before our Reporting Services going down. Our servers have been very slow lately and wondering if this could be part of the problem.
我们最近在我们的日志中发现了以下错误,该错误发生在我们的Reporting Services关闭之前。我们的服务器最近一直很慢,并想知道这是否可能是问题的一部分。
Error Message: "Polling caught an exception, restarting polling. Error Message System.Data.SqlClient.SqlException: Timeout expired."
错误消息:“轮询捕获异常,重新启动轮询。错误消息System.Data.SqlClient.SqlException:超时已过期。”
1 个解决方案
#1
Polling is used to detect scheduled reports and subscriptions.
轮询用于检测预定的报告和订阅。
SQL Agent runs jobs (created by the subscription page) that populates tables that are polled every 10 secs by Rpt Svcs (defined in .config files, default is 10 IIRC).
SQL Agent运行作业(由订阅页面创建),该作业填充由Rpt Svcs每10秒轮询一次的表(在.config文件中定义,默认为10 IIRC)。
Anyway, this means that the RS box could not query the RS database to see if anything happened.
无论如何,这意味着RS盒无法查询RS数据库以查看是否发生了任何事情。
#1
Polling is used to detect scheduled reports and subscriptions.
轮询用于检测预定的报告和订阅。
SQL Agent runs jobs (created by the subscription page) that populates tables that are polled every 10 secs by Rpt Svcs (defined in .config files, default is 10 IIRC).
SQL Agent运行作业(由订阅页面创建),该作业填充由Rpt Svcs每10秒轮询一次的表(在.config文件中定义,默认为10 IIRC)。
Anyway, this means that the RS box could not query the RS database to see if anything happened.
无论如何,这意味着RS盒无法查询RS数据库以查看是否发生了任何事情。