Re: Duplicate notifications
When you say that there were 2 notifications produced - were there 2
notifications in the notifications table? Or was there 1 notification in
the notification table, yet 2 were delivered to the subscriber?
SQL Server MVP
On Mon, 27 Aug 2007 17:24:01 -0700, pwellington wrote:
> We are experiencing a transient problem wherein duplication notifications
> are occaisionally generated for no dicernible reason. It happened twice in
> the last week in period where a several notifications were generated with no
> Probing the data tables revealed the following:
> 1) Only 1 event was generated.
> 2) 2 notifications were generated for the only subscriber to this
> particular event instance.
> 3) Running the rule query manual using the eventbatchID produced only 1 row
> that would have been inserted into the Notifications table.
> 4) Nothing appears to be awry with the Notification view defined or the
> 'Instead of insert' trigger. (i might have missed something.)
> The use of 'read uncommited' in the generatied view definitions is a little
> unsettling. Could this be leading to this 'phantom' notification?
> Should the distributor ThreadPoolSize be set to 1?
> For the most part NS works great. I just need to wring out these last
> little snags.