Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Tue, 14 Aug 2007 18:09:26 -0000,    group: microsoft.public.sqlserver.notificationsvcs        back       


Event View does not return Events while NSEvent Table has rows    
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
date: Tue, 14 Aug 2007 18:09:26 -0000   author:   TechJunkie

Re: Event View does not return Events while NSEvent Table has rows    
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
date: Wed, 15 Aug 2007 04:19:26 -0700   author:   Joe Webb

Re: Event View does not return Events while NSEvent Table has rows    
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
date: Wed, 15 Aug 2007 13:31:41 -0000   author:   TechJunkie

Re: Event View does not return Events while NSEvent Table has rows    
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 -
date: Wed, 15 Aug 2007 18:37:53 -0000   author:   TechJunkie

Re: Event View does not return Events while NSEvent Table has rows    
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
date: Tue, 28 Aug 2007 05:08:36 -0700   author:   Joe Webb

Re: Event View does not return Events while NSEvent Table has rows    
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 -
date: Tue, 28 Aug 2007 05:11:10 -0700   author:   Joe Webb

Re: Event View does not return Events while NSEvent Table has rows    
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
date: Thu, 30 Aug 2007 20:11:05 -0000   author:   TechJunkie

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us