all groups > sql server notification services > june 2004 >
You're in the

sql server notification services

group:

No Errors But No Notifications Being Generated


No Errors But No Notifications Being Generated Steve Youmans
6/23/2004 7:51:03 AM
sql server notification services:
I have a NS application that has an non-hosted event
generator that inserts information into the event tables.
I have defined my notification rules but they do not seem
to be invoked when the events are posted. I am not
getting any kind of error messages in the event log. (I
ran the sql and it should be returning records and that is
why I think the rules are never getting invoked. I even
tried running NSPrepare/ExecuteRulesFiring and got the
following results: 829 2004-06-23 13:58:22.220 2004-06-23
13:59:22.220 NULL NULL NULL NULL NULL
NULL NULL 0
(The null values are the event class, rule, etc. Why
can't it find it?)

Any suggestions on what to check? I have made sure the
instance is running and all pieces are enabled but I am at
a loss as to go from here.

BTW, all components are running on a single box that has
Win 2K server, SQL Server 2K SP3, has both the 1.0 and 1.1
framework running side-by-side. (I have added the fix as
described in the readme file for NS SP1 so that the 1.1
framework is tried first, then 1.0)

No Errors But No Notifications Being Generated Steve Youmans
6/23/2004 1:41:52 PM
I moved the generator and distributor to another machine
that has Windows XP Pro and only the 1.1 framework
installed and the process worked. I suspect the problem
is with having the 1.0 and 1.1 framework running side-by-
side.

[quoted text, click to view]
AddThis Social Bookmark Button