Notification Alert System crash after any unrelated error of OLE DB initialization - by ellight1

Status : 

 


3
0
Sign in
to vote
ID 775018 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 12/22/2012 7:32:38 AM
Access Restriction Public

Description

We using log error notification service: SQL Server Agent -> Alerts
Correspondingly logging errors (RAISERROR WITH LOG;) sends message by e-mail to admins

If anywhere, any provider with external context run fails on initialization, then alert system will fall off. And only system/service restart restores it.

At the same time other mechanisms, such as providers, e-mail etc. continues normal function (though some of them doesn't immediately, it depends)

Links for settings instructions:
http://support.microsoft.com/kb/2647989
http://msdn.microsoft.com/en-us/library/ms186358.aspx
http://msdn.microsoft.com/en-us/library/ms189982(v=sql.100).aspx

The use of an external context run is necessary due to problem providers with memory leaks and crashes (Oracle provider for example)
Sign in to post a comment.
Posted by Sethu Srinivasan on 2/3/2015 at 6:58 PM
Please install latest service pack and let us know if you still see this issue
http://www.microsoft.com/en-us/download/details.aspx?id=44271


Thanks
Sethu Srinivasan [MSFT]
SQL Server