问题描述
今天发生了一个有趣的错误,无法在网上找到有关此错误的信息,所以想知道你们中是否有人以前曾见过这种行为。
Had an interesting error today and couldn't find anything online about it so wondered if any of you guys had seen this behavior before.
内存错误和今天早上报告服务器上的CPU使用率激增,干净重启似乎可以解决此问题,但是自那时以来,所有电子邮件订阅已发送多次。我的意思是,就SSRS而言,订阅在其正常时间(上午10点)运行一次,这已经通过仔细检查日志以查看是否发生了另一次执行(没有发生)并重命名SPROC来证明。报告引用以确保失败,但不会失败,并且邮件会重新发送。然后,我检查了Exchange队列,并打开了连接日志记录,可以看到每30分钟将新邮件重新提交到交换邮件队列中。
We had an out of memory error and the CPU usage was spiking this morning on our reports server, a clean reboot seemed to rectify the issue, however since then all the email subscriptions have been sending multiple times. What do i mean by this, the subscription as far as SSRS is concerned ran once at its normal time (10am), this has been proven by scrutinizing the logs to see if another execution occurred (it didn't) and by renaming the SPROC that the report references to ensure that it would fail, yet it didn't and the mail resent. I then checked the Exchange queues and turned on logging for the connection and i could see a new mail being resubmitted every 30mins to the exchange mail queue.
问题是,导致该邮件重新提交到交换服务器的过程是什么,除了重新启动外,如何阻止邮件重新发送?
The question is, what process is causing that mail to be resubmitted to the exchange server and how, other than another reboot do we stop the emails resending.
预先感谢
-进一步-
具有经过更多的挖掘,我们注意到 [ReportServer]。[dbo] .Notifications
表中填充了所有发送多次的报告,并且Attempts列每增加一次发送重复电子邮件的时间。
Having done more digging we have noticed that the [ReportServer].[dbo].Notifications
table is populated with all of the reports that are sending out multiple times with the Attempts column incrementing every time the duplicate email is sent out.
我们仍然不知道为什么要重新发送
We still dont know why these are resending
推荐答案
降低到日志记录级别...如果将Report Server Service日志记录级别降低到级别2(异常,重新启动和警告),则该错误似乎会显现出来,但是当日志记录级别切换回3或更高级别时,错误似乎消失了。在这里注意到一些类似的行为:
It seems to be down to the logging level... If you switch the Report Server Service logging level down to level 2 (Exceptions, restarts and warnings) this error seems to manifest itself however when the logging level is switched back up to 3 or above the error seems to disappear. Some similar behavior is noticed here: http://social.msdn.microsoft.com/Forums/en-NZ/sqlreportingservices/thread/b78bb6e2-0810-4afd-ba6b-8b09a243f349
这篇关于SSRS订阅重复电子邮件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!