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.

Hi,    We recently started getting these errors a couple times a day.   There are 12 of them in total.     We also have exactly 12 subscriptions.   Does this indicate some db issue causing all of these to fail?

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.



One or more workflows were affected by this.


Workflow name: Subscription8b108a3e_4e3d_4fd0_b67e_cbfc21cd10b8

Instance name: Alert Notification Subscription Server

Instance ID: {E07E3FAB-53BC-BC14-1634-5A6E949F9230}

Management group: OnLife Management

January 13th, 2014 11:19pm

Hi,

Do you have hotfixes applied?

http://blogs.technet.com/kevinholman/archive/2009/01/27/which-hotfixes-should-i-apply.aspx

Also, I found a relevant thread for your reference.

Alert subscription data source module encountered errors while running</u1:p>

http://social.technet.microsoft.com/Forums/systemcenter/en-US/50557249-7f97-4b67-9729-f7088202385b/alert-subscription-data-source-module-encountered-errors-while-running?forum=operationsmanagergeneral</u1:p>


Free Windows Admin Tool Kit Click here and download it now
January 14th, 2014 10:59pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics