This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 39%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 31%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Could you try running Get-SCOMNotificationSubscription -Name Subscription0fcd96f4_f38f_47c0_b753_a0cf3e810l8a ?
Hi CyrAz,
Thank you for sharing the command.
Can you please let us know what could be the issue for this alert "Alert subscription data source module encountered errors while running " and the event id is 11402 .
Regards,
Ravi Shankar
Maybe ¯_(ツ)_/¯
I gave you the command to identify what subscription was causing the event.
Also the error message says "Cannot continue the execution because the session is in the kill state", which points towards some kind of issue with the SQL database.
Any other errors that could be related to that?
Hi CyrAz,
Thank you for the update.
Apart from the event id I mentioned in my first post no other events triggered.
Regards,
Ravi shankar
Ok :)
>Alert subscription data source module was unable to find alerts that match the subscription because of database errors.
One of the possible reasons may be the alert created and then closed in a very short period of time such that the subscription cannnot find the corresponding alert.
Roger