Duplicate emails being sent from SSRS by Kishor_SN

Active

Type:	Bug
ID:	777124
Opened:	1/22/2013 1:08:48 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

We are using Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2).

The architecture is a scale out deployment.

Whenever we subscribe to a report in SSRS and if the subscription returns no data, then SSRS keeps sending report email to the subscribed user multiple times. The interval is a little random. Sometimes it is every 15mins or sometimes 30mins. But, emails keep coming in.

Details (expand)

English

SQL Server 2008 SP3

Reporting Services

Windows Server 2008 Enterprise

US English

1. Subscribe to email subscription to a report which do not return any data
2. After the report is processed and no data returned, then, emails keep pouring in every 15mins or 30mins

1. Following errors are seen in SSRS logs -

processing!ReportServer_0-26!f738!01/22/2013-00:01:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 5., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 5.

2. Email sent continuously with interval of 15mins or 30mins
3. The entry in Notifications table in ReportServerDB does not get cleared. The number of attempts keeps increasing sending email for each attempt.

1. Only one email should be sent even though the report has no data.
2. The notifications table should get cleared.

X64

0 attachments

Microsoft