Hello Team,
We received the alert as "Alert subscription data source module encountered errors while running" in SCOM 2019.
upon checking the Event iD we see the event id as 11402 and the description is as below, we required to know how can we check which Subscription has the issue by looking at the event Details.
Event Details
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: Cannot continue the execution because the session is in the kill state. A severe error occurred on the current command. The results, if any, should be discarded. One or more workflows were affected by this. Workflow name: Subscription0fcd96f4_f38f_47c0_b753_a0cf3e810l8a Instance name: Alert Notification Subscription Server Instance ID: {E94r3FAD-53BC-TK-5278-5A6E949F2430} Management group: SCOM group
Regards,
Ravi shankar