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.