question

shankar431-9012 avatar image
0 Votes"
shankar431-9012 asked RogerXue-3369 answered

Alert Subscription Availability monitor related alerts are receiving in SCOM 2019

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

msc-operations-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CyrAz avatar image
0 Votes"
CyrAz answered CyrAz commented

Could you try running Get-SCOMNotificationSubscription -Name Subscription0fcd96f4_f38f_47c0_b753_a0cf3e810l8a ?

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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?

0 Votes 0 ·

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

0 Votes 0 ·
Show more comments
RogerXue-3369 avatar image
0 Votes"
RogerXue-3369 answered

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.