microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Duplicate Notifications

Subject: Re: Duplicate Notifications
From: David Van de Vate
Date: Tue, 03 May 2005 13:40:48 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Joe:

Thanks in advance for your prompt attention to this question. It truly
has me baffled.

We are quite certain that we are acurately generating events. 

We're reasonably certain that we checked the other usual suspects.

However, the diagnostics confirm that we generated twice that many
notifications.

The event rule in question looks something like the following.  When run
against a set of events at any point in time, it returns one correct set
of notification data.

however,  the output from NSNotificationBatchDetails
shows 1 NotificationBatch, 1 RuleFiring with what looks to be duplicate
notifications in sequence.  That is 1 & 2 are identical, 3 & 4, and so
on. 

It's almost as if statement below were run in parallel against the same
set of events (ie a mutex didn't work).

However, setting the generator thread pool size to 1 did not change the
outcome.

Let me know what else I can pass along.



<EventRule>
      <RuleName>MyEventRule</RuleName>
                    <Action>
                        SELECT DISTINCT
dbo.MyEventNotificationNotify(s.SubscriberId, 
s.DeviceName,
s.SubscriberLocale, 
e.UniqueData
)
                        FROM  MyEvent  s INNER JOIN
                                MyEventEvent e ON (e.SelectRuleID =
s.SelectRuleID)
                        where e.Customfield matches something else
</Action>
                    <EventClassName>MyEventEvent</EventClassName>
                </EventRule>





*** Sent via Developersdex http://www.developersdex.com ***

<Prev in Thread] Current Thread [Next in Thread>