I have two NS instances each with one application each. Each application
uses a hosted event provider (custom). The hosted event provider is
scheduled to run once a day shortly after midnight. Last night the event
providers returned an error from the Run method due to a timeout trying to
get data from the database to create the events. Now, the custom event
provider seems to be called continuously. I have gone so far as to nscontol
delete and then create with no success. Here is an excerpt from my
NSxxEventsEventsBatches table to give you an idea of what I mean:

113 1 732 1/29/2005 6:17:42 AM 1/29/2005 6:17:42 AM
114 1 722 1/30/2005 6:17:46 AM 1/30/2005 6:17:46 AM
115 1 325 1/31/2005 6:17:27 AM 1/31/2005 6:17:27 AM
116 1 411 2/1/2005 6:17:10 AM 2/1/2005 6:17:10 AM
117 1 411 2/1/2005 6:18:26 AM 2/1/2005 6:18:26 AM
118 1 411 2/1/2005 6:18:49 AM 2/1/2005 6:18:49 AM
119 1 411 2/1/2005 6:20:25 AM 2/1/2005 6:20:26 AM
....

These apps have been running since October so I don't think there is a bug.
Could something have gotten corrupted within the generator?

I wanted to add that I have a third instance/app that uses the same design
as described below. There are no errors in the error log for it, however, I
just noticed its also it is experiencing the same situation where events are
being loaded and event batches are being created even though it is set to
run once per day. Does this indicate that NSService is corrupt?

[quoted text, click to view]

Hi Bruce,

It seems a corruption, first we may suggest that you restart server. If it
doesn't help please follow the steps below and do some modifications

Run Notification Services Setup.
On the Program Maintenance page, do one of the following:
If you want to add or remove components, click Modify.
If you need to repair a Notification Services installation, click Repair.
Repair reinstalls and repairs the components you previously installed.

Modify or repair the installation using the instructions provided in
Installing Components.

Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Michael,

Thanks for the information. I basically arrived at the same conclusion and
rebooted the server which appears to have gotten everything back on
schedule. One of the lessons I learned through this experience was the
importance of trapping all errors in the Run method of one's
IScheduledEventProvider implementation! I had actually wanted the Terminate
method called when errors occured in my event provider because usually just
restarting the service seemed to work well and I could rely on having NS log
the error in the Event Log. This apparently is not a good idea. I'm a little
concerned, however, that an error in one instance/application can affect
another instance/application like this did. Is there anything I can do
through configuration/installation to make things more isolated?

Bruce



[quoted text, click to view]

Thanks for the help and advice Michael.

Bruce

Hi Bruce,

First of all, it's great to hear that you have resolved this issue by
restarting the server.

However, I understood that it seems difficult to trace the root cause of NS
corruptions, which might be cuased by codes or NS internal as Hosted Event
Provider will share the thread. I am not familiar with your scenario so
that here is only some general suggesions

1. Upgrade to latest Notification Services Pack
How to Obtain the Latest SQL Server 2000 Notification Server Service Pack
http://support.microsoft.com/?id=822348

2. If your applications depends on only one Notification Services
instances, you are encouraged to deploy only one application per NS
instances instead of multiple applications in one instance.

Refer Planning a Notification Services System in BOL for more information.

3. Have you checked Chapter Event Messages in BOL

Last but not the least, here is the PPT from our PM Patrice Truong about
how to troubleshooting & Debugging SQL Notification Services Applications
for your reference

Notification Services Presentations from the Microsoft Mobility Conference
http://www.microsoft.com/sql/NS/techinfo/confslides.asp

Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Bruce,

You are welcome!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.