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

Re: Event Info

Subject: Re: Event Info
From: "andyjax"
Date: Tue, 28 Jun 2005 13:07:02 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Actually what I found was the line should match for <xsd:element 
name="RightStockEventsName"  sql:relation="RightStockEventsName">

"Joe Webb" wrote:

> Very good! Thanks for sharing the solutions with the community. 
> 
> To clarify, you had something like this in your XSD file:
> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema";
> xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
>   <xsd:element name="event" sql:relation="WrongStockEventsName">
>     <xsd:complexType>
>       <xsd:sequence>
>         <xsd:element name="StockSymbol" type="xsd:string" />
>         <xsd:element name="StockPrice" type="xsd:decimal" />
>       </xsd:sequence>
>     </xsd:complexType>
>   </xsd:element>
> </xsd:schema>
> 
> But your ADF had something like:
> <EventClass>
>   <EventClassName>RightStockEventsName</EventClassName>
>   <Schema>
>     <Field>
>         <FieldName>StockSymbol</FieldName>
>         <FieldType>nvarchar(6)</FieldType>
>         <FieldTypeMods>not null</FieldTypeMods>
>     </Field>
> 
> 
> Glad it's resolved...
> 
> -- 
> 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 Tue, 28 Jun 2005 10:45:08 -0700, "andyjax"
> <[email protected]> wrote:
> 
> >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>