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

Event View does not return Events while NSEvent Table has ..

 
   Database Forums (Home) -> Notification Services RSS
Next:  INSERTINg a Clob in a portable way  
Author Message
TechJunkie

External


Since: Aug 14, 2007
Posts: 6



(Msg. 1) Posted: Tue Aug 14, 2007 6:55 pm
Post subject: Event View does not return Events while NSEvent Table has rows
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

Dear group ,
my subscription rule uses View Names for both the Subscription and
Event Tables.
Even though the NSSubscription and NSEventClass tables have data, the
rule does not find any rows using the views. After looking at the
NSCurrentTables there are no rows being added here.
Thus I am unable to get Notifications in the Notification View \Table.
Please help me with this

Thanks,
Junkie

 >> Stay informed about: Event View does not return Events while NSEvent Table has .. 
Back to top
Login to vote
Joe Webb1

External


Since: Apr 28, 2004
Posts: 408



(Msg. 2) Posted: Wed Aug 15, 2007 8:19 am
Post subject: Re: Event View does not return Events while NSEvent Table has rows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Tue, 14 Aug 2007 18:09:26 +0000, TechJunkie wrote:

> Dear group ,
> my subscription rule uses View Names for both the Subscription and
> Event Tables.
> Even though the NSSubscription and NSEventClass tables have data, the
> rule does not find any rows using the views. After looking at the
> NSCurrentTables there are no rows being added here.
> Thus I am unable to get Notifications in the Notification View \Table.
> Please help me with this
>
> Thanks,
> Junkie


The NSCurrentTables are populated as needed with quantum data so you won't
see rows there outside of the quantum.

Can you post your match rule for us to review?

Thanks!

Joe


--
Joe Webb
SQL Server MVP
http://www.sqlns.com

 >> Stay informed about: Event View does not return Events while NSEvent Table has .. 
Back to top
Login to vote
TechJunkie

External


Since: Aug 14, 2007
Posts: 6



(Msg. 3) Posted: Wed Aug 15, 2007 2:56 pm
Post subject: Re: Event View does not return Events while NSEvent Table has rows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks a lot Joe.
Can you please throw some light on the quantum data and its impact,
this seems to be a arcane area for some of us.
We are used to using the default settings for the qunatum data as per
the samples from Microsoft.
Here are my match rules.

<EventClasses>
<EventClass>
<EventClassName>TSAlert</EventClassName>
<Schema>
<Field>
<FieldName>Group_size</FieldName>
<FieldType>int</FieldType>
</Field>
<Field>
<FieldName>request_Group_size</FieldName>
<FieldType>int</FieldType>
</Field>
<Field>
<FieldName>scheduler_ID</FieldName>
<FieldType>numeric(18,0)</FieldType>
</Field>
</Schema>
</EventClass>
</EventClasses>

<SubscriptionClasses>
<SubscriptionClass>
<SubscriptionClassName>GroupSizeAlerts_Subscription</
SubscriptionClassName>
<Schema>
<Field>
<FieldName>DeviceName</FieldName>
<FieldType>varchar(255)</FieldType>
</Field>
<Field>
<FieldName>SubscriberLocale</FieldName>
<FieldType>varchar(10)</FieldType>
</Field>
<Field>
<FieldName>Group_size</FieldName>
<FieldType>int</FieldType>
</Field>
<Field>
<FieldName>request_Group_size</FieldName>
<FieldType>int</FieldType>
</Field>
<Field>
<FieldName>scheduler_ID</FieldName>
<FieldType>numeric(18,0)</FieldType>
</Field>
</Schema>
<EventRules>
<EventRule>
<RuleName>GroupSize_AlertsEventRule</RuleName>
<Action>
INSERT INTO [NSApplicationNameDB].[dbo].
[GroupSize_AlertsNotifier] ([SubscriberId],[DeviceName],
[SubscriberLocale],[Group_size],[request_Group_size],[scheduler_ID])
SELECT S.[SubscriberId],S.[DeviceName],S.[SubscriberLocale],E.
[Group_size],E.[request_Group_size],E.[scheduler_ID] FROM
[NSApplicationNameDB].[dbo].[TSAlert] E, [NSApplicationNameDB].[dbo].
[GroupSizeAlerts_Subscription] S where E.[scheduler_ID] = S.
[scheduler_ID]
</Action>
<EventClassName>TSAlert</EventClassName>
</EventRule>
</EventRules>
</SubscriptionClass>
</SubscriptionClasses>

Thanks a lot,
Junkie


On Aug 15, 7:19 am, Joe Webb wrote:
> On Tue, 14 Aug 2007 18:09:26 +0000, TechJunkie wrote:
> > Dear group ,
> > my subscription rule uses View Names for both the Subscription and
> > Event Tables.
> > Even though the NSSubscription and NSEventClass tables have data, the
> > rule does not find any rows using the views. After looking at the
> > NSCurrentTables there are no rows being added here.
> > Thus I am unable to get Notifications in the Notification View \Table.
> > Please help me with this
>
> > Thanks,
> > Junkie
>
> The NSCurrentTables are populated as needed with quantum data so you won't
> see rows there outside of the quantum.
>
> Can you post your match rule for us to review?
>
> Thanks!
>
> Joe
>
> --
> Joe Webb
> SQL Server MVPhttp://www.sqlns.com
 >> Stay informed about: Event View does not return Events while NSEvent Table has .. 
Back to top
Login to vote
TechJunkie

External


Since: Aug 14, 2007
Posts: 6



(Msg. 4) Posted: Wed Aug 15, 2007 7:56 pm
Post subject: Re: Event View does not return Events while NSEvent Table has rows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Dear Joe and group.
What are the actual stored procs, dll's etc that sql server uses to
deliver notifications via SMTP.
Is there any way to step through the execution of SQL Server CLR
module.
I guess Some of the functionality in New SQL Server are dll's on CLR
Please help me .
Thanks,
Kiran

On Aug 15, 9:31 am, TechJunkie wrote:
> Thanks a lot Joe.
> Can you please throw some light on the quantum data and its impact,
> this seems to be a arcane area for some of us.
> We are used to using the default settings for the qunatum data as per
> the samples from Microsoft.
> Here are my match rules.
>
> <EventClasses>
> <EventClass>
> <EventClassName>TSAlert</EventClassName>
> <Schema>
> <Field>
> <FieldName>Group_size</FieldName>
> <FieldType>int</FieldType>
> </Field>
> <Field>
> <FieldName>request_Group_size</FieldName>
> <FieldType>int</FieldType>
> </Field>
> <Field>
> <FieldName>scheduler_ID</FieldName>
> <FieldType>numeric(18,0)</FieldType>
> </Field>
> </Schema>
> </EventClass>
> </EventClasses>
>
> <SubscriptionClasses>
> <SubscriptionClass>
> <SubscriptionClassName>GroupSizeAlerts_Subscription</
> SubscriptionClassName>
> <Schema>
> <Field>
> <FieldName>DeviceName</FieldName>
> <FieldType>varchar(255)</FieldType>
> </Field>
> <Field>
> <FieldName>SubscriberLocale</FieldName>
> <FieldType>varchar(10)</FieldType>
> </Field>
> <Field>
> <FieldName>Group_size</FieldName>
> <FieldType>int</FieldType>
> </Field>
> <Field>
> <FieldName>request_Group_size</FieldName>
> <FieldType>int</FieldType>
> </Field>
> <Field>
> <FieldName>scheduler_ID</FieldName>
> <FieldType>numeric(18,0)</FieldType>
> </Field>
> </Schema>
> <EventRules>
> <EventRule>
> <RuleName>GroupSize_AlertsEventRule</RuleName>
> <Action>
> INSERT INTO [NSApplicationNameDB].[dbo].
> [GroupSize_AlertsNotifier] ([SubscriberId],[DeviceName],
> [SubscriberLocale],[Group_size],[request_Group_size],[scheduler_ID])
> SELECT S.[SubscriberId],S.[DeviceName],S.[SubscriberLocale],E.
> [Group_size],E.[request_Group_size],E.[scheduler_ID] FROM
> [NSApplicationNameDB].[dbo].[TSAlert] E, [NSApplicationNameDB].[dbo].
> [GroupSizeAlerts_Subscription] S where E.[scheduler_ID] = S.
> [scheduler_ID]
> </Action>
> <EventClassName>TSAlert</EventClassName>
> </EventRule>
> </EventRules>
> </SubscriptionClass>
> </SubscriptionClasses>
>
> Thanks a lot,
> Junkie
>
> On Aug 15, 7:19 am, Joe Webb wrote:
>
>
>
> > On Tue, 14 Aug 2007 18:09:26 +0000, TechJunkie wrote:
> > > Dear group ,
> > > my subscription rule uses View Names for both the Subscription and
> > > Event Tables.
> > > Even though the NSSubscription and NSEventClass tables have data, the
> > > rule does not find any rows using the views. After looking at the
> > > NSCurrentTables there are no rows being added here.
> > > Thus I am unable to get Notifications in the Notification View \Table.
> > > Please help me with this
>
> > > Thanks,
> > > Junkie
>
> > The NSCurrentTables are populated as needed with quantum data so you won't
> > see rows there outside of the quantum.
>
> > Can you post your match rule for us to review?
>
> > Thanks!
>
> > Joe
>
> > --
> > Joe Webb
> > SQL Server MVPhttp://www.sqlns.com- Hide quoted text -
>
> - Show quoted text -
 >> Stay informed about: Event View does not return Events while NSEvent Table has .. 
Back to top
Login to vote
Joe Webb1

External


Since: Apr 28, 2004
Posts: 408



(Msg. 5) Posted: Tue Aug 28, 2007 9:08 am
Post subject: Re: Event View does not return Events while NSEvent Table has rows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

SSNS processes items in quantums for efficiency.

A quantum is essentially a block of time, eg 15 minutes.

So as SSNS processes items, it looks to all items with the specified
quantum that it's working on. In most cases it the time period immediately
prior to the current time, however if SSNS was off for a while, it'll go
back an process prior quantums in order to catch up. We can define how far
back it'll go in order to catch up.

HTH...

Joe



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




On Wed, 15 Aug 2007 13:31:41 +0000, TechJunkie wrote:

> Thanks a lot Joe.
> Can you please throw some light on the quantum data and its impact,
> this seems to be a arcane area for some of us.
> We are used to using the default settings for the qunatum data as per
> the samples from Microsoft.
> Here are my match rules.
>
> <EventClasses>
> <EventClass>
> <EventClassName>TSAlert</EventClassName>
> <Schema>
> <Field>
> <FieldName>Group_size</FieldName>
> <FieldType>int</FieldType>
> </Field>
> <Field>
> <FieldName>request_Group_size</FieldName>
> <FieldType>int</FieldType>
> </Field>
> <Field>
> <FieldName>scheduler_ID</FieldName>
> <FieldType>numeric(18,0)</FieldType>
> </Field>
> </Schema>
> </EventClass>
> </EventClasses>
>
> <SubscriptionClasses>
> <SubscriptionClass>
> <SubscriptionClassName>GroupSizeAlerts_Subscription</
> SubscriptionClassName>
> <Schema>
> <Field>
> <FieldName>DeviceName</FieldName>
> <FieldType>varchar(255)</FieldType>
> </Field>
> <Field>
> <FieldName>SubscriberLocale</FieldName>
> <FieldType>varchar(10)</FieldType>
> </Field>
> <Field>
> <FieldName>Group_size</FieldName>
> <FieldType>int</FieldType>
> </Field>
> <Field>
> <FieldName>request_Group_size</FieldName>
> <FieldType>int</FieldType>
> </Field>
> <Field>
> <FieldName>scheduler_ID</FieldName>
> <FieldType>numeric(18,0)</FieldType>
> </Field>
> </Schema>
> <EventRules>
> <EventRule>
> <RuleName>GroupSize_AlertsEventRule</RuleName>
> <Action>
> INSERT INTO [NSApplicationNameDB].[dbo].
> [GroupSize_AlertsNotifier] ([SubscriberId],[DeviceName],
> [SubscriberLocale],[Group_size],[request_Group_size],[scheduler_ID])
> SELECT S.[SubscriberId],S.[DeviceName],S.[SubscriberLocale],E.
> [Group_size],E.[request_Group_size],E.[scheduler_ID] FROM
> [NSApplicationNameDB].[dbo].[TSAlert] E, [NSApplicationNameDB].[dbo].
> [GroupSizeAlerts_Subscription] S where E.[scheduler_ID] = S.
> [scheduler_ID]
> </Action>
> <EventClassName>TSAlert</EventClassName>
> </EventRule>
> </EventRules>
> </SubscriptionClass>
> </SubscriptionClasses>
>
> Thanks a lot,
> Junkie
>
>
> On Aug 15, 7:19 am, Joe Webb wrote:
>> On Tue, 14 Aug 2007 18:09:26 +0000, TechJunkie wrote:
>> > Dear group ,
>> > my subscription rule uses View Names for both the Subscription and
>> > Event Tables.
>> > Even though the NSSubscription and NSEventClass tables have data, the
>> > rule does not find any rows using the views. After looking at the
>> > NSCurrentTables there are no rows being added here.
>> > Thus I am unable to get Notifications in the Notification View \Table.
>> > Please help me with this
>>
>> > Thanks,
>> > Junkie
>>
>> The NSCurrentTables are populated as needed with quantum data so you won't
>> see rows there outside of the quantum.
>>
>> Can you post your match rule for us to review?
>>
>> Thanks!
>>
>> Joe
>>
>> --
>> Joe Webb
>> SQL Server MVPhttp://www.sqlns.com
 >> Stay informed about: Event View does not return Events while NSEvent Table has .. 
Back to top
Login to vote
Joe Webb1

External


Since: Apr 28, 2004
Posts: 408



(Msg. 6) Posted: Tue Aug 28, 2007 9:11 am
Post subject: Re: Event View does not return Events while NSEvent Table has rows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Shyam Pather's SSNS has some detail about debugging SSNS instances by
manually calling the procedures, etc.

But I suspect that your issue is that the SSNS instance login account
cannot send email through the SMTP server. Is it logging on using an
account with sufficient privileges? Or is it a local system account?

HTH...


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


On Wed, 15 Aug 2007 18:37:53 +0000, TechJunkie wrote:

> Dear Joe and group.
> What are the actual stored procs, dll's etc that sql server uses to
> deliver notifications via SMTP.
> Is there any way to step through the execution of SQL Server CLR
> module.
> I guess Some of the functionality in New SQL Server are dll's on CLR
> Please help me .
> Thanks,
> Kiran
>
> On Aug 15, 9:31 am, TechJunkie wrote:
>> Thanks a lot Joe.
>> Can you please throw some light on the quantum data and its impact,
>> this seems to be a arcane area for some of us.
>> We are used to using the default settings for the qunatum data as per
>> the samples from Microsoft.
>> Here are my match rules.
>>
>> <EventClasses>
>> <EventClass>
>> <EventClassName>TSAlert</EventClassName>
>> <Schema>
>> <Field>
>> <FieldName>Group_size</FieldName>
>> <FieldType>int</FieldType>
>> </Field>
>> <Field>
>> <FieldName>request_Group_size</FieldName>
>> <FieldType>int</FieldType>
>> </Field>
>> <Field>
>> <FieldName>scheduler_ID</FieldName>
>> <FieldType>numeric(18,0)</FieldType>
>> </Field>
>> </Schema>
>> </EventClass>
>> </EventClasses>
>>
>> <SubscriptionClasses>
>> <SubscriptionClass>
>> <SubscriptionClassName>GroupSizeAlerts_Subscription</
>> SubscriptionClassName>
>> <Schema>
>> <Field>
>> <FieldName>DeviceName</FieldName>
>> <FieldType>varchar(255)</FieldType>
>> </Field>
>> <Field>
>> <FieldName>SubscriberLocale</FieldName>
>> <FieldType>varchar(10)</FieldType>
>> </Field>
>> <Field>
>> <FieldName>Group_size</FieldName>
>> <FieldType>int</FieldType>
>> </Field>
>> <Field>
>> <FieldName>request_Group_size</FieldName>
>> <FieldType>int</FieldType>
>> </Field>
>> <Field>
>> <FieldName>scheduler_ID</FieldName>
>> <FieldType>numeric(18,0)</FieldType>
>> </Field>
>> </Schema>
>> <EventRules>
>> <EventRule>
>> <RuleName>GroupSize_AlertsEventRule</RuleName>
>> <Action>
>> INSERT INTO [NSApplicationNameDB].[dbo].
>> [GroupSize_AlertsNotifier] ([SubscriberId],[DeviceName],
>> [SubscriberLocale],[Group_size],[request_Group_size],[scheduler_ID])
>> SELECT S.[SubscriberId],S.[DeviceName],S.[SubscriberLocale],E.
>> [Group_size],E.[request_Group_size],E.[scheduler_ID] FROM
>> [NSApplicationNameDB].[dbo].[TSAlert] E, [NSApplicationNameDB].[dbo].
>> [GroupSizeAlerts_Subscription] S where E.[scheduler_ID] = S.
>> [scheduler_ID]
>> </Action>
>> <EventClassName>TSAlert</EventClassName>
>> </EventRule>
>> </EventRules>
>> </SubscriptionClass>
>> </SubscriptionClasses>
>>
>> Thanks a lot,
>> Junkie
>>
>> On Aug 15, 7:19 am, Joe Webb wrote:
>>
>>
>>
>> > On Tue, 14 Aug 2007 18:09:26 +0000, TechJunkie wrote:
>> > > Dear group ,
>> > > my subscription rule uses View Names for both the Subscription and
>> > > Event Tables.
>> > > Even though the NSSubscription and NSEventClass tables have data, the
>> > > rule does not find any rows using the views. After looking at the
>> > > NSCurrentTables there are no rows being added here.
>> > > Thus I am unable to get Notifications in the Notification View \Table.
>> > > Please help me with this
>>
>> > > Thanks,
>> > > Junkie
>>
>> > The NSCurrentTables are populated as needed with quantum data so you won't
>> > see rows there outside of the quantum.
>>
>> > Can you post your match rule for us to review?
>>
>> > Thanks!
>>
>> > Joe
>>
>> > --
>> > Joe Webb
>> > SQL Server MVPhttp://www.sqlns.com- Hide quoted text -
>>
>> - Show quoted text -
 >> Stay informed about: Event View does not return Events while NSEvent Table has .. 
Back to top
Login to vote
TechJunkie

External


Since: Aug 14, 2007
Posts: 6



(Msg. 7) Posted: Thu Aug 30, 2007 9:59 pm
Post subject: Re: Event View does not return Events while NSEvent Table has rows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Dear Joe appreciate the insight.

I CREATED a new Service account on the virtual server box name
"testadmin" and made it a member of the administrators for the
Domain, also this account is a also a member of
SQLServer2005NotificationServicesUser$ServerName

my NS Service is running under this account.

Also my Default SMTP Server on the same Virtual Server has Anonymous
Access and testadmin on the box has access to this Service.

Still no luck,
Thanks
Prabhukiran
 >> Stay informed about: Event View does not return Events while NSEvent Table has .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Failing NSEvent Begin Batch procs - Hello All: I have a somple NS app with an Event Class. I am submitting events as follows: The source Db has a trigger that gets fired ON INSERT The trigger call a Stored Procedure in the same Database. The SP then calls the 3 procedures in NS to submit...

Event Not Being Added To Rule and Event Table - Hello, I'm new to NS and I'm trying to do a test project. I seem to have everything working but I saw I didn't I have any events defined in my ADF file so I'm trying to add one now. I have subscibers and subscriptions, at least there in the..

Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_Sql.. - I am having problems enabling sql table for notifications in sql 2005. The problem is that when i use custom schema name i get following error: Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger' as its schema is..

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..

digest notifications for different events - Hi, we're currently designing a notification system for our document management product, and we're thinking about using SQL NS instead of developing a home-brewn subscription engine. SQL NS looks very promising to us. However, one of the critical..
   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 ]