SCOM – “Alert subscription data source module encountered errors while running”

confused

Life is like a box of chocolates you never know what you are gonna get. This famous sentence is very true for the IT business also.

Recently I had been configuring subscription using a PowerShell script and command channel for a customer environment. The day after, the customer called, that he has lots of alerts “Alert subscription data source module encountered errors while running”…

image

A first analysis showed that the alerts were starting around at 8:00 pm and ended some time after 11:00 pm. After some more investigation by checking the (auto) closed alerts, I found out that the Operations Manager database connection was lost at 11:00 pm. Other alerts and the alert description itself made me think and I was almost sure that there was some network issues or the database server went down for some reason. The customer did also some internal investigation and finally sent me a screenshot from the virtual environment…

 image

After looking at the picture and the Date Time column, the picture showed that the infrastructure team was taking a snapshots every few hours and merging the VM snapshots of the SCOM SQL Server VM. During the remove/merge process there were clear interruptions that lead to a interruptive SQL Server (connection). This problem led to the fact that the notifications could not be sent properly and left the SCOM server itself in a semi-functional state. After restarting the SCOM services, the system recovered and worked as expected.

Be aware of this fact when virtualizing SQL Servers!

1 Comment

  1. Pingback: SCOM link - IT Consult

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s