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

Re: Event Info

Subject: Re: Event Info
From: "andyjax"
Date: Tue, 28 Jun 2005 10:45:08 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
I finally found the problem, my XSD file did not have the name set the same 
as the EventClass. After making it match I now get Events data and 
EventBatches has a count.

"andyjax" wrote:

> I have torn it down to 1 single event in a XML file and 3 fields to populate. 
> Still only get batch info no event data written to table. Should I be 
> concerned about this? I just wanted to make sure everything works as needed 
> before addding more functionality to my prototype.
> 
> Sorry to be so unknowledgeable , but that is why I am posting, to get 
> knowledge.
> 
> "andyjax" wrote:
> 
> > I have removed the whole Instance and Application and tried to recreate 
> > from 
> > scratch. The only thing I have defined in the ADF is the EventClass and 
> > HostedProvider being FileWatcher.
> > 
> > I still am just getting NS<EventClassName>EventBatches  with entries and a 
> > count of 0, and nothing in the NS<EventClassName>Events table. I have 
> > limited 
> > the number of items for the event to be 3 items, and the corresponding XML 
> > data is the same structure.
> > 
> > What next.
> > 
> > "Joe Webb" wrote:
> > 
> > > Andyjax - 
> > > 
> > > >My sample data should be 10 records. The number of things to compare on 
> > > >is 
> > > >wide, 
> > > >25 things to match on. Not sure if the event data is too wide.
> > > 
> > > Events are submitted in batches as we discussed before. Then when the
> > > generator fires, the matching rules are executed. So they don't have
> > > any impact on your event submission problem.
> > > 
> > > HTH...
> > > 
> > > -- 
> > > Joe Webb
> > > SQL Server MVP
> > > 
> > > 
> > > ~~~
> > > 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 Mon, 27 Jun 2005 09:20:04 -0700, "andyjax"
> > > <[email protected]> wrote:
> > > 
> > > >The EventBatches table has something like the following:
> > > >EventBatchID     ProviderID    EventCount
> > > >6                1                  0    
> > > >
> > > >My sample data should be 10 records. The number of things to compare on 
> > > >is 
> > > >wide, 
> > > >25 things to match on. Not sure if the event data is too wide.
> > > >
> > > >In response to your other post looking for errors in the Application 
> > > >Log, 
> > > >this is what I found:
> > > >Description: Some notifications cannot be delivered because they 
> > > >reference 
> > > >non-existent subscribers, unknown subscriber device names, or 
> > > >unsupported 
> > > >protocols for the notification class. Use the 
> > > >NSDiagnosticFailedNotifications 
> > > >stored procedure for details about undeliverable notifications. 
> > > >
> > > >I tried to run the procedure, but nothing comes back as a logged 
> > > >problem. I 
> > > >am using SQL 2005 June CTP Dev Edition on Windows XP.
> > > >
> > > >"Joe Webb" wrote:
> > > >
> > > >> Hi Andyjax - 
> > > >> 
> > > >> If things are working correctly, you should see event data in the
> > > >> NS<EventClassName>Events table and a record of the batch in the
> > > >> NS<EventClassName>EventBatches table in the application database. 
> > > >> 
> > > >> Are there errors in the application event log? 
> > > >> 
> > > >> -- 
> > > >> Joe Webb
> > > >> SQL Server MVP
> > > >> 
> > > >> 
> > > >> ~~~
> > > >> 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 Mon, 27 Jun 2005 08:30:01 -0700, "andyjax"
> > > >> <[email protected]> wrote:
> > > >> 
> > > >> >I am working through Shyam's book trying to look to make sure the 
> > > >> >application 
> > > >> >is working as needed. The processing of my data using a filewatcher 
> > > >> >processes 
> > > >> >the file done, but I don't see a batch in the NS<Service Name>Events 
> > > >> >table.
> > > >> >
> > > >> >Am I missing something, or should I not worry about it? The 
> > > >> >MusicStore 
> > > >> >example in the book is working just fine. I am just trying to build a 
> > > >> >prototype and taking the slow process of adding a little bit more 
> > > >> >each time 
> > > >> >as Shyam suggests.
> > > >> >
> > > >> >Any help would be appreciated. 
> > > >> 
> > > >> 
> > > 
> > > 

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