Groups | Blog | Home
all groups > sql server reporting services > september 2004 >

sql server reporting services : Data Driven Subscription - odd issue


Matt
9/6/2004 7:53:02 AM
Hi,

my result set for a Data Driven Subscription consists of 24 subscribers with
associated data so I would expect 24 emails. For some reason 32 emails are
sent - i.e. there are some double-ups.

Any ideas on this?

thanks

Matt

Daniel Reib [MSFT]
9/7/2004 10:45:06 AM
Do you always get 32? RS should not send duplicate emails. In some rare
cases it could happen, but these cases only have to do with system crashes.

You are not on Beta2 are you? Beta2 did have issues with duplicate emails.

If you can post the log file that might also shed some light. It would be
best to get a log file with just a single execution of the subscription.
You can do this by restarting the ReportServer service and then having the
subscription kick off. After the subscription finishes sending mails, copy
off the log file. Just make sure no other subscriptions are firing at the
same time.

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

AddThis Social Bookmark Button