Data Driven Subscription - odd issue

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
MattDo 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.
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:uSoQBN6kEHA.1152@.TK2MSFTNGP11.phx.gbl...
> 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
>

data doesn't be transfered to one of my subscribers!

I use merge replication and the topology is central publication. I have 20 subscribers.

when I run agent, I got message "No data needed to be merged". Publisher doesn't send data to this subscriber. When I update date again, I can send data to subscriber.

Why?!

How replication works?!

and How specifies records that must be send to the subscriber?!

Publisher and subscriber work with SQL 2000 with sp 3 installed on windows server 2003.

Please help me.

Thanks.

It's not clear what you're expecting or what the problem is.

To learn about replication, you should start by reading Replication topics in Books Online, then come back with any specific questions.

|||

I guess you have setup merge replication using "NoSync" option. See http://msdn2.microsoft.com/en-us/library/aa239398(SQL.80).aspx.

Did you see convergent data after the first sync?

Thanks.

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

sql

data doesn't be transfered to one of my subscribers!

I use merge replication and the topology is central publication. I have 20 subscribers.

when I run agent, I got message "No data needed to be merged". Publisher doesn't send data to this subscriber. When I update date again, I can send data to subscriber.

Why?!

How replication works?!

and How specifies records that must be send to the subscriber?!

Publisher and subscriber work with SQL 2000 with sp 3 installed on windows server 2003.

Please help me.

Thanks.

It's not clear what you're expecting or what the problem is.

To learn about replication, you should start by reading Replication topics in Books Online, then come back with any specific questions.

|||

I guess you have setup merge replication using "NoSync" option. See http://msdn2.microsoft.com/en-us/library/aa239398(SQL.80).aspx.

Did you see convergent data after the first sync?

Thanks.

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