microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Trouble with Notification Workflow Solution Accelerator

Subject: Re: Trouble with Notification Workflow Solution Accelerator
From: Joe Webb
Date: Wed, 01 Feb 2006 05:29:55 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi Pete - 

I'm not familiar with the Notification Workflow Solution Accelerator
application so I cannot offer much assistance there. 

I can tell you that SQLNS is cluster aware so at least from that
perspective you should be fine. 

One point of clarification: the NSMain database is the instance
database and it contains subscriber and subscriber device information
whereas the application database,
NotificationWorkflowNotificationWorkflowApp in your case I believe,
contains the subscription, event, and notification information. 

Have you created subscriptions that match the events you're
collecting?

HTH...

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


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)



On Tue, 31 Jan 2006 19:59:08 +0000 (UTC), Pete Zerger
<[email protected]> wrote:

>
>Let me provide additional information that may assist. 
>
>In the event someone participating in this group is familiar with the 
>Notification 
>Workflow Solution Accelerator application, I see lots of activity to the 
>NotificationWorkflowNotificationWorkflowApp database (which means event data 
>is being pulled across from Onepoint), but no activity whatsoever (even at 
>a filesystem level) to NotificationWorkflowNSMain, which holds all the 
>subscriber 
>and subscription data. This is further supported by the 
>NS$NotificationWorkflow 
>performance counters, which show the Quanta processed counter incrementing 
>every 15 seconds, but still shows 0 subscribers and 0 subscriptions, even 
>though we have created several and the information is present in the 
>NotificationWorkflowNSMain 
>database.
>
>Kind Regards,
>
>Pete Zerger MCSE(Messaging)
>mail:[email protected]
>BLOG:http://www.it-jedi.net/
>
>> I am working with the Notification Workflow Solution Accelerator (a
>> solution accelerator for MOM), and I am not finding any official
>> support statement or guidance on running the application on a
>> clustered SQL instance, and have found conflicting claims of support
>> in the MS newsgroups. Since this app is based on SQL Notification
>> Survices, which is cluster-capable to my knowledge, I wanted to
>> determine if this application is capable of running successsfully on a
>> clustered SQL instance. Thus far, we have been unable to make it do so
>> 
>> In the interest of the best use of our time, clarification would be
>> most appreciated.
>> 
>> This post from an MS resource implies support for named and clustered
>> SQL
>> 
>> instances:
>> 
>> http://groups.google.com/group/microsoft.public.mom/browse_thread/thre
>> ad/476b1481594918d9/bdf47f67763c1a19?lnk=st&q=sql+notification+service
>> s+logging&rnum=3&hl=en&utoken=1asA1zcAAACAT_kPml7nPanGq5_khmjXp082g2jF
>> HE-R0j7gEQoqfnvDyIr2trlnwjbGeK6z6-U5QvIbA_SapvijBBSQFbov
>> 
>> This post from a supposed former MS resource claims it is unsupported:
>> 
>> http://groups.google.com/group/microsoft.public.mom/browse_thread/thre
>> ad/8c2b2be5d2e01837/9dcf822ffa2bdfd5?lnk=st&q=MOM+notification+workflo
>> w+cluster&rnum=1&hl=en#9dcf822ffa2bdfd5
>> 
>> Any thoughts or official stance would be most appreciated.
>> 
>> Kind Regards,
>> 
>> Pete Zerger MCSE(Messaging)
>> mail:[email protected]
>> BLOG:http://www.it-jedi.net/
>> Kind Regards,
>> 
>> Pete Zerger MCSE(Messaging)
>> mail:[email protected]
>> BLOG:http://www.it-jedi.net/
>

<Prev in Thread] Current Thread [Next in Thread>