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

A sneaky bug that cost me a lot of grief - NULL vs NOT NULL event fields

Subject: A sneaky bug that cost me a lot of grief - NULL vs NOT NULL event fields
From: Tokes
Date: Wed, 04 Jul 2007 05:56:55 -0000
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Just wanted to warn people of a bug I came across in using
Notification Services that drove me mad for a couple of hours:

Make sure the field definitions of your event EXACTLY match what is
being returned in the EventQuery of your SQLProvider Hosted Provider!

I had one column defined as NOT NULL-able in the event, but the event
provider query was returning some NULL values. The thing that made
this bug so difficult to find was that there was no errors being
logged anywhere - nothing was showing up in the event log, and when I
ran Profiler on the server it showed that the provider was being run
(the Event Submit Batch proc was running). Why didn't I get some kind
of "failed to submit batch" error?

 - Tokes


<Prev in Thread] Current Thread [Next in Thread>
  • A sneaky bug that cost me a lot of grief - NULL vs NOT NULL event fields, Tokes <=