SQL-NS 2005 StockBroker Sample doesn't notify

FAQ

Profile

SQL-NS 2005 StockBroker Sample doesn't notify

Database Forums (Home) -> Notification Services

Next: SSNS Security using installation user acct not se..

Author

Message

James

External

Since: Mar 02, 2005
Posts: 9

(Msg. 1) Posted: Tue Jun 12, 2007 11:31 am Post subject: SQL-NS 2005 StockBroker Sample doesn't notify Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

From Ch.3 of Shyam Pather's SQL-NS book, I have followed the instructions exactly as stated in the book, I get success on the TEST and setup_all and I get no errors when aI start the service as described on pg. 69-70. I run the Test.sql file that inserts records in the StockBroker database, and it runs without any errors. However, the file 'FileNotifications.txt' is NOT written to no matter hopw long I wait. What gives? Thanks, James Klett jimklett @ mathias-die . com >> Stay informed about: SQL-NS 2005 StockBroker Sample doesn't notify

James

External

Since: Mar 02, 2005
Posts: 9

(Msg. 2) Posted: Tue Jun 12, 2007 3:24 pm Post subject: Re: SQL-NS 2005 StockBroker Sample doesn't notify [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

This is what I see in the NotificationBatchesStatusCodes table 0 Undone 1 Generating 2 Generated 3 Creating distributor work items 4 Created distributor work items 5 Failed to generate NULL NULL JIM "James" wrote in message > From Ch.3 of Shyam Pather's SQL-NS book, I have followed the instructions > exactly as stated in the book, I get success on the TEST and setup_all and > I get no errors when aI start the service as described on pg. 69-70. I > run the Test.sql file that inserts records in the StockBroker database, > and it runs without any errors. However, the file 'FileNotifications.txt' > is NOT written to no matter hopw long I wait. What gives? > > > > Thanks, > > > > James Klett > > jimklett @ mathias-die . com > > > >> Stay informed about: SQL-NS 2005 StockBroker Sample doesn't notify

Joe Webb1

External

Since: Apr 28, 2004
Posts: 408

(Msg. 3) Posted: Mon Jun 18, 2007 6:55 am Post subject: Re: SQL-NS 2005 StockBroker Sample doesn't notify [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

On Tue, 12 Jun 2007 15:24:36 -0500, James wrote: > This is what I see in the NotificationBatchesStatusCodes table > > 0 Undone > 1 Generating > 2 Generated > 3 Creating distributor work items > 4 Created distributor work items > 5 Failed to generate > NULL NULL > > > JIM > > > "James" wrote in message > >> From Ch.3 of Shyam Pather's SQL-NS book, I have followed the instructions >> exactly as stated in the book, I get success on the TEST and setup_all and >> I get no errors when aI start the service as described on pg. 69-70. I >> run the Test.sql file that inserts records in the StockBroker database, >> and it runs without any errors. However, the file 'FileNotifications.txt' >> is NOT written to no matter hopw long I wait. What gives? >> >> >> >> Thanks, >> >> >> >> James Klett >> >> jimklett @ mathias-die . com >> >> >> Double check to make sure you have subscribers, subscriber devices, and subscriptions set up. That's the most common problem for the symptoms you've described. Also, you may want to ensure that the service account has write permissions for the output folder. HTH... -- Joe Webb SQL Server MVP http://www.sqlns.com >> Stay informed about: SQL-NS 2005 StockBroker Sample doesn't notify

james31

External

Since: Dec 16, 2003
Posts: 10

(Msg. 4) Posted: Wed Jun 20, 2007 1:47 pm Post subject: Re: SQL-NS 2005 StockBroker Sample doesn't notify [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Thank you for the reply. I made the folder public etc... but still nothing. I am running the 1st sample from the book's CD, so everything is supposed to just work as far as subscribers... they are all setup by Shyam's code. Thanks again JIM "Joe Webb" wrote in message > On Tue, 12 Jun 2007 15:24:36 -0500, James wrote: > >> This is what I see in the NotificationBatchesStatusCodes table >> >> 0 Undone >> 1 Generating >> 2 Generated >> 3 Creating distributor work items >> 4 Created distributor work items >> 5 Failed to generate >> NULL NULL >> >> >> JIM >> >> >> "James" wrote in message >> >>> From Ch.3 of Shyam Pather's SQL-NS book, I have followed the >>> instructions >>> exactly as stated in the book, I get success on the TEST and setup_all >>> and >>> I get no errors when aI start the service as described on pg. 69-70. I >>> run the Test.sql file that inserts records in the StockBroker database, >>> and it runs without any errors. However, the file >>> 'FileNotifications.txt' >>> is NOT written to no matter hopw long I wait. What gives? >>> >>> >>> >>> Thanks, >>> >>> >>> >>> James Klett >>> >>> jimklett @ mathias-die . com >>> >>> >>> > > Double check to make sure you have subscribers, subscriber devices, and > subscriptions set up. That's the most common problem for the symptoms > you've described. > > Also, you may want to ensure that the service account has write > permissions for the output folder. > > HTH... > > > -- > Joe Webb > SQL Server MVP > http://www.sqlns.com >> Stay informed about: SQL-NS 2005 StockBroker Sample doesn't notify

gkorobkov

External

Since: Jun 23, 2007
Posts: 1

(Msg. 5) Posted: Sat Jun 23, 2007 3:49 pm Post subject: Re: SQL-NS 2005 StockBroker Sample doesn't notify [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

On Jun 12, 8:31 pm, "James" wrote: > From Ch.3 of Shyam Pather's SQL-NS book, Excuse me. Where I can get or download source code for this book? (Microsoft® SQL Server 2000 Notification Services by Pather Shyam) Please, if it possibe could you send it on my e-mail Best regards George Korobkov. >> Stay informed about: SQL-NS 2005 StockBroker Sample doesn't notify

James

External

Since: Mar 02, 2005
Posts: 9

(Msg. 6) Posted: Mon Jun 25, 2007 1:12 pm Post subject: Re: SQL-NS 2005 StockBroker Sample doesn't notify [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Buy the book from Amazon, the CD is in the back. It would be illegal for me to send you the code without Shya getting his royalty JIM "gkorobkov" wrote in message On Jun 12, 8:31 pm, "James" wrote: > From Ch.3 of Shyam Pather's SQL-NS book, Excuse me. Where I can get or download source code for this book? (Microsoft® SQL Server 2000 Notification Services by Pather Shyam) Please, if it possibe could you send it on my e-mail Best regards George Korobkov. >> Stay informed about: SQL-NS 2005 StockBroker Sample doesn't notify

James

External

Since: Mar 02, 2005
Posts: 9

(Msg. 7) Posted: Tue Jul 17, 2007 12:37 pm Post subject: Re: SQL-NS 2005 StockBroker Sample doesn't notify [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Joe, again, this is straight from the BOOKs CD. I only execute exactly what the book says. Buy the book, and follow the instructions yourself and you will see what I mean, then we will be talking apples thanks, JIM "Joe Webb" wrote in message > On Wed, 20 Jun 2007 13:47:06 -0500, james wrote: > >> Thank you for the reply. I made the folder public etc... but still >> nothing. >> I am running the 1st sample from the book's CD, so everything is supposed >> to >> just work as far as subscribers... they are all setup by Shyam's code. >> >> Thanks again >> >> JIM >> >> "Joe Webb" wrote in message >> >>> On Tue, 12 Jun 2007 15:24:36 -0500, James wrote: >>> >>>> This is what I see in the NotificationBatchesStatusCodes table >>>> >>>> 0 Undone >>>> 1 Generating >>>> 2 Generated >>>> 3 Creating distributor work items >>>> 4 Created distributor work items >>>> 5 Failed to generate >>>> NULL NULL >>>> >>>> >>>> JIM >>>> >>>> >>>> "James" wrote in message >>>> >>>>> From Ch.3 of Shyam Pather's SQL-NS book, I have followed the >>>>> instructions >>>>> exactly as stated in the book, I get success on the TEST and setup_all >>>>> and >>>>> I get no errors when aI start the service as described on pg. 69-70. >>>>> I >>>>> run the Test.sql file that inserts records in the StockBroker >>>>> database, >>>>> and it runs without any errors. However, the file >>>>> 'FileNotifications.txt' >>>>> is NOT written to no matter hopw long I wait. What gives? >>>>> >>>>> >>>>> >>>>> Thanks, >>>>> >>>>> >>>>> >>>>> James Klett >>>>> >>>>> jimklett @ mathias-die . com >>>>> >>>>> >>>>> >>> >>> Double check to make sure you have subscribers, subscriber devices, and >>> subscriptions set up. That's the most common problem for the symptoms >>> you've described. >>> >>> Also, you may want to ensure that the service account has write >>> permissions for the output folder. >>> >>> HTH... >>> >>> >>> -- >>> Joe Webb >>> SQL Server MVP >>> http://www.sqlns.com > > > Check the tables to make sure you do indeed have subscribers, > subscriptions, and subscriberdevices. You can also check to see if there > are notifications that have been produced by not delivered. > > HTH... > > Joe > > > -- > Joe Webb > SQL Server MVP > http://www.sqlns.com >> Stay informed about: SQL-NS 2005 StockBroker Sample doesn't notify

James

External

Since: Mar 02, 2005
Posts: 9

(Msg. 8) Posted: Tue Jul 17, 2007 12:37 pm Post subject: Re: SQL-NS 2005 StockBroker Sample doesn't notify [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

I do own your book too JIM "Joe Webb" wrote in message > On Wed, 20 Jun 2007 13:47:06 -0500, james wrote: > >> Thank you for the reply. I made the folder public etc... but still >> nothing. >> I am running the 1st sample from the book's CD, so everything is supposed >> to >> just work as far as subscribers... they are all setup by Shyam's code. >> >> Thanks again >> >> JIM >> >> "Joe Webb" wrote in message >> >>> On Tue, 12 Jun 2007 15:24:36 -0500, James wrote: >>> >>>> This is what I see in the NotificationBatchesStatusCodes table >>>> >>>> 0 Undone >>>> 1 Generating >>>> 2 Generated >>>> 3 Creating distributor work items >>>> 4 Created distributor work items >>>> 5 Failed to generate >>>> NULL NULL >>>> >>>> >>>> JIM >>>> >>>> >>>> "James" wrote in message >>>> >>>>> From Ch.3 of Shyam Pather's SQL-NS book, I have followed the >>>>> instructions >>>>> exactly as stated in the book, I get success on the TEST and setup_all >>>>> and >>>>> I get no errors when aI start the service as described on pg. 69-70. >>>>> I >>>>> run the Test.sql file that inserts records in the StockBroker >>>>> database, >>>>> and it runs without any errors. However, the file >>>>> 'FileNotifications.txt' >>>>> is NOT written to no matter hopw long I wait. What gives? >>>>> >>>>> >>>>> >>>>> Thanks, >>>>> >>>>> >>>>> >>>>> James Klett >>>>> >>>>> jimklett @ mathias-die . com >>>>> >>>>> >>>>> >>> >>> Double check to make sure you have subscribers, subscriber devices, and >>> subscriptions set up. That's the most common problem for the symptoms >>> you've described. >>> >>> Also, you may want to ensure that the service account has write >>> permissions for the output folder. >>> >>> HTH... >>> >>> >>> -- >>> Joe Webb >>> SQL Server MVP >>> http://www.sqlns.com > > > Check the tables to make sure you do indeed have subscribers, > subscriptions, and subscriberdevices. You can also check to see if there > are notifications that have been produced by not delivered. > > HTH... > > Joe > > > -- > Joe Webb > SQL Server MVP > http://www.sqlns.com >> Stay informed about: SQL-NS 2005 StockBroker Sample doesn't notify

Joe Webb1

External

Since: Apr 28, 2004
Posts: 408

(Msg. 9) Posted: Tue Jul 17, 2007 1:42 pm Post subject: Re: SQL-NS 2005 StockBroker Sample doesn't notify [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

On Tue, 17 Jul 2007 12:37:59 -0500, James wrote: > I do own your book too > > > JIM > > "Joe Webb" wrote in message > >> On Wed, 20 Jun 2007 13:47:06 -0500, james wrote: >> >>> Thank you for the reply. I made the folder public etc... but still >>> nothing. >>> I am running the 1st sample from the book's CD, so everything is supposed >>> to >>> just work as far as subscribers... they are all setup by Shyam's code. >>> >>> Thanks again >>> >>> JIM >>> >>> "Joe Webb" wrote in message >>> >>>> On Tue, 12 Jun 2007 15:24:36 -0500, James wrote: >>>> >>>>> This is what I see in the NotificationBatchesStatusCodes table >>>>> >>>>> 0 Undone >>>>> 1 Generating >>>>> 2 Generated >>>>> 3 Creating distributor work items >>>>> 4 Created distributor work items >>>>> 5 Failed to generate >>>>> NULL NULL >>>>> >>>>> >>>>> JIM >>>>> >>>>> >>>>> "James" wrote in message >>>>> >>>>>> From Ch.3 of Shyam Pather's SQL-NS book, I have followed the >>>>>> instructions >>>>>> exactly as stated in the book, I get success on the TEST and setup_all >>>>>> and >>>>>> I get no errors when aI start the service as described on pg. 69-70. >>>>>> I >>>>>> run the Test.sql file that inserts records in the StockBroker >>>>>> database, >>>>>> and it runs without any errors. However, the file >>>>>> 'FileNotifications.txt' >>>>>> is NOT written to no matter hopw long I wait. What gives? >>>>>> >>>>>> >>>>>> >>>>>> Thanks, >>>>>> >>>>>> >>>>>> >>>>>> James Klett >>>>>> >>>>>> jimklett @ mathias-die . com >>>>>> >>>>>> >>>>>> >>>> >>>> Double check to make sure you have subscribers, subscriber devices, and >>>> subscriptions set up. That's the most common problem for the symptoms >>>> you've described. >>>> >>>> Also, you may want to ensure that the service account has write >>>> permissions for the output folder. >>>> >>>> HTH... >>>> >>>> >>>> -- >>>> Joe Webb >>>> SQL Server MVP >>>> http://www.sqlns.com >> >> >> Check the tables to make sure you do indeed have subscribers, >> subscriptions, and subscriberdevices. You can also check to see if there >> are notifications that have been produced by not delivered. >> >> HTH... >> >> Joe >> >> >> -- >> Joe Webb >> SQL Server MVP >> http://www.sqlns.com Thanks! I hope you've found the book helpful. -- Joe Webb SQL Server MVP http://www.sqlns.com >> Stay informed about: SQL-NS 2005 StockBroker Sample doesn't notify

Joe Webb1

External

Since: Apr 28, 2004
Posts: 408

(Msg. 10) Posted: Tue Jul 17, 2007 1:47 pm Post subject: Re: SQL-NS 2005 StockBroker Sample doesn't notify [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

On Tue, 17 Jul 2007 12:37:00 -0500, James wrote: > Joe, again, this is straight from the BOOKs CD. I only execute exactly what > the book says. Buy the book, and follow the instructions yourself and you > will see what I mean, then we will be talking apples > > thanks, > > JIM > > > "Joe Webb" wrote in message > >> On Wed, 20 Jun 2007 13:47:06 -0500, james wrote: >> >>> Thank you for the reply. I made the folder public etc... but still >>> nothing. >>> I am running the 1st sample from the book's CD, so everything is supposed >>> to >>> just work as far as subscribers... they are all setup by Shyam's code. >>> >>> Thanks again >>> >>> JIM >>> >>> "Joe Webb" wrote in message >>> >>>> On Tue, 12 Jun 2007 15:24:36 -0500, James wrote: >>>> >>>>> This is what I see in the NotificationBatchesStatusCodes table >>>>> >>>>> 0 Undone >>>>> 1 Generating >>>>> 2 Generated >>>>> 3 Creating distributor work items >>>>> 4 Created distributor work items >>>>> 5 Failed to generate >>>>> NULL NULL >>>>> >>>>> >>>>> JIM >>>>> >>>>> >>>>> "James" wrote in message >>>>> >>>>>> From Ch.3 of Shyam Pather's SQL-NS book, I have followed the >>>>>> instructions >>>>>> exactly as stated in the book, I get success on the TEST and setup_all >>>>>> and >>>>>> I get no errors when aI start the service as described on pg. 69-70. >>>>>> I >>>>>> run the Test.sql file that inserts records in the StockBroker >>>>>> database, >>>>>> and it runs without any errors. However, the file >>>>>> 'FileNotifications.txt' >>>>>> is NOT written to no matter hopw long I wait. What gives? >>>>>> >>>>>> >>>>>> >>>>>> Thanks, >>>>>> >>>>>> >>>>>> >>>>>> James Klett >>>>>> >>>>>> jimklett @ mathias-die . com >>>>>> >>>>>> >>>>>> >>>> >>>> Double check to make sure you have subscribers, subscriber devices, and >>>> subscriptions set up. That's the most common problem for the symptoms >>>> you've described. >>>> >>>> Also, you may want to ensure that the service account has write >>>> permissions for the output folder. >>>> >>>> HTH... >>>> >>>> >>>> -- >>>> Joe Webb >>>> SQL Server MVP >>>> http://www.sqlns.com >> >> >> Check the tables to make sure you do indeed have subscribers, >> subscriptions, and subscriberdevices. You can also check to see if there >> are notifications that have been produced by not delivered. >> >> HTH... >> >> Joe >> >> >> -- >> Joe Webb >> SQL Server MVP >> http://www.sqlns.com James - I understand. But since it's not working as expected, I'm just trying to offer a troubleshooting approach that may indicate why it's failing to live up to expectations. Besides, I think it learning why something didn't work is a whole lot more edifying than rotely following an example that succeeds. -- Joe Webb SQL Server MVP http://www.sqlns.com >> Stay informed about: SQL-NS 2005 StockBroker Sample doesn't notify

Display posts from previous:

Related Topics:

How can I use Notification Services to notify my applicati.. - Hello. I'd like to use SQL 2005 Notification Services to notify my .Net application about some events. In few words it will look like that: - my application starts and subscribes to some events - notification service notify my application about some...

Stock Sample Problem - Hi, I am attempting to build the Stock_VB solution file but I get the error: Error 1 Error creating assembly manifest: Error reading key file 'C:\Program Files\Microsoft SQL Server\90\Samples\Notification Services\Stock\samplekey.snk' -- The system..

NS API Question - Is it possible to have an arseembly in SQL 2005 to expose the NS API? The idea is to have interfaces exposed as web services from SQL 2005 directly that allow for the management of NS subscriptions. This would allow the existing ASP.Net 1.1 code to cal...

Clean out??? - I was asked to look into a problem a customer was having , Turned out they moved SMTP server and in the process the generator got disabled. This was back in May. So I have that all squared away and now I'm looking for a quick way to clear out the..

sql mail integration - i have configured sql mail in sql server 2000. the mailid is also successfully getting tested. but when i execute the xp_sendmail command i get the following error Server: Msg 18025, Level 16, State 1, Line 0 xp_sendmail: failed with mail error..

	Database Forums (Home) -> Notification Services	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum