Search

Duplicate emails being sent from SSRS by Kishor_SN

Active

1
0
Sign in
to vote
Type: Bug
ID: 777124
Opened: 1/22/2013 1:08:48 AM
Access Restriction: Public
0
Workaround(s)
0
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)

Product Language

English

Version

SQL Server 2008 SP3

Category

Reporting Services

Operating System

Windows Server 2008 Enterprise

Operating System Language

US English

Steps to Reproduce

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

Actual Results

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.

Expected Results

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

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.