ReSearch This KB – Alert subscription data source module encountered errors while running

Alert: Alert subscription data source module encountered errors while running

Management Pack Name:  System Center Core Monitoring

Management Pack Version: 7.0.9538.0

Rule or Monitor: Rule

Rule or Monitor Name: Health Service Modules Alert Subscription DataSource Module Availability Rule

Rule or Monitor Notes: This is an alert indicating that an alert subscription could not be checked to see if alerts match a subscription to database connectivity errors.

Alert subscription data source module encountered errors while running: Alert subscription data source module was unable to find alerts that match the subscription because of database errors.
The following error(s) were encountered: Exception Message: ExecuteScalar requires an open and available Connection. The connection’s current state is closed.

Issue: In our environment this alert is occurring once a day and the timing is directly related to when the SQL server which hosts the OperationsManager database is being backed up.

Resolution: For our environment, we used Tao Yang’s OpsMgr Self Maintenance Management pack (http://blog.tyang.org/2013/03/03/opsmgr-self-maintenance-management-pack/) to close any alerts from rules which are more than one day old. This allows us to still see the alerts when they occur but doesn’t leave a large number of them in the Operations Manager console.

Another option would be to disable this rule, however, if connectivity is lost to the database for a longer period of time then we would not be alerted of that condition.

In the longer term – this rule should be redesigned as a monitor so that the alert will auto-close when alert subscription criteria is able to be checked successfully.

2 thoughts on “ReSearch This KB – Alert subscription data source module encountered errors while running

Leave a Reply