 |
|
|
|
Next: Notification services or another mechanism .. how..
|
| Author |
Message |
External
Since: Aug 14, 2007
Posts: 7
|
(Msg. 1) Posted: Tue Aug 14, 2007 6:09 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 |
|
| Back to top |
|
 | |
External
Since: Apr 28, 2004
Posts: 118
|
(Msg. 2) Posted: Wed Aug 15, 2007 4: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 |
|
| Back to top |
|
| |
External
Since: Aug 14, 2007
Posts: 7
|
(Msg. 3) Posted: Wed Aug 15, 2007 1:31 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 |
|
| |
External
Since: Aug 14, 2007
Posts: 7
|
(Msg. 4) Posted: Wed Aug 15, 2007 6:37 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 |
|
| |
External
Since: Apr 28, 2004
Posts: 118
|
(Msg. 5) Posted: Tue Aug 28, 2007 5: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 |
|
| |
External
Since: Apr 28, 2004
Posts: 118
|
(Msg. 6) Posted: Tue Aug 28, 2007 5: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 |
|
| |
External
Since: Aug 14, 2007
Posts: 7
|
(Msg. 7) Posted: Thu Aug 30, 2007 8:11 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 |
|
| |
| Related Topics: | Insert Matching Events to SQL Table - I have setup a few applications with NS, but always with SMTP as the delivery protocol. I need to build another instance were the result ends up as inserts to a SQL table. Can I accomplish this within the ADF or do I need to build a custom delivery..
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...
How to send .NET events to applications - Hello All, I am new to NS, with some experience in using Files and email as the main mechanism for notifying applications. In my current scenario, I have a 2 tiered client-server system (.NET) and I would like to leverage SQL Notification Services to..
time event? - Hi, I have some data in my database which stores when a contract expires. I'd like to send a notification 90, 60 and 30 days before the contract will expire. I'm having trouble coming up with a good event to trigger notifications. Do I setup the event...
Failure commiting Event Batches - i'm using a non-hosted event provider to provide event batches to a NS Application. it works well, but sometimes it throws an exception with the message "failed to commit the events batch". i am using the EventCollector obeject in a windows se... |
|
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
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
