Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Duplicate notifications

 
   Database Forums (Home) -> Notification Services RSS
Next:  in sql server is it possible to get the amount of..  
Author Message
pwellington

External


Since: Aug 27, 2007
Posts: 1



(Msg. 1) Posted: Mon Aug 27, 2007 9:24 pm
Post subject: Duplicate notifications
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

Hi,
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
problem.

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.

Thanks.

 >> Stay informed about: Duplicate notifications 
Back to top
Login to vote
Joe Webb1

External


Since: Apr 28, 2004
Posts: 408



(Msg. 2) Posted: Tue Aug 28, 2007 8:31 am
Post subject: Re: Duplicate notifications [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?


--
Joe Webb
SQL Server MVP
http://weblogs.sqlteam.com/joew/




On Mon, 27 Aug 2007 17:24:01 -0700, pwellington wrote:

> Hi,
> 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
> problem.
>
> 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.
>
> Thanks.

 >> Stay informed about: Duplicate notifications 
Back to top
Login to vote
TechJunkie

External


Since: Aug 14, 2007
Posts: 6



(Msg. 3) Posted: Thu Aug 30, 2007 11:26 pm
Post subject: Re: Duplicate notifications [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Wellington.
There is a quantumn for Vaccuming the Events Table and Notifications
table.
You can find it in the Application Settings part of the NS- ADF File.
If it occours before the Notification is delivered ( not created) a
duplicate Notification can be created,
please send a snippet of the ADF File.
Prabhukiran

On Aug 28, 2:26 pm, pwellington
wrote:
> Hi Joe,
>
> There were 2 notifications in the notifications table and they were
> associated with the same Notification Batch Id.
>
> Pat
>
> "Joe Webb" wrote:
> > 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?
>
> > --
> > Joe Webb
> > SQL Server MVP
> >http://weblogs.sqlteam.com/joew/
>
> > On Mon, 27 Aug 2007 17:24:01 -0700, pwellington wrote:
>
> > > Hi,
> > > 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
> > > problem.
>
> > > 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.
>
> > > Thanks.
 >> Stay informed about: Duplicate notifications 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Duplicate Events - The nature of the event provider for my SQLNS application is to produce exact duplicate rows into the event table. Obviously, I am not interested in receiving duplicate notifications. What are some strategies for having SQLNS produce one notification..

Avoiding sending duplicate notifications. - Hi, I am hoping this is a really simple queastion. I haven't come accross it yet in Shyam's book... I want to make sure that people don't get duplicate notifications. For example, if you can subscribe to recieve notifications when records of a certai...

Using NS for Reminders question - Duplicate notifications - My requirement is to allow users to subscribe to notifications when a task has been created, and also to schedule reminders that the task is still pending. I have the notification at time the task is created by an event-triggered subscription, and that..

NS API Question - Is it possible to have an arseembly in SQL 2005 to expose the NS API? The idea is to have interfaces exposed as web services from SQL 2005 directly that allow for the management of NS subscriptions. This would allow the existing ASP.Net 1.1 code to cal...

Clean out??? - I was asked to look into a problem a customer was having , Turned out they moved SMTP server and in the process the generator got disabled. This was back in May. So I have that all squared away and now I'm looking for a quick way to clear out the..
   Database Forums (Home) -> Notification Services All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]