Alertengine errors - need to delete and recreate a number of alerts

Team,

We receive the following error in the solarwinds.net event log. Working with support, we have deleted most of our alerts and recreated the alerts, yet the problem remains. Has anyone experienced this? It seems there must be a better way.

Thanks!

2010-03-29 08:23:52,496 [AlertCheckingThread] WARN Error - Error in UpdateRowsThatAreTriggered() - GetNetObjects

                                        System.InvalidOperationException: ExecuteReader: CommandText property has not been initialized

                                           at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)

                                           at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

                                           at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

                                           at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

                                           at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

                                           at AlertingEngine.CheckAlert.UpdateRowsThatAreTriggered()

Find more posts tagged with

alertengine_errors

Alerts

Accepted answers

All comments

Kartoon

Benbree,

It looks like there is a trigger condition in one of your advanced alerts that is causing this problem. I had a similar issue where I updated my custom properties and deleted an existing one which some of my advanced alerts were tied to. All I had to do was update my trigger condition and reset conditions and I was good to go and haven't received the error since. This actually happened today. My error was a bit more descriptive as it referenced my invalid column. Don't know if it's a version thing for that but I'm running Orion 9.5.1. But again this was my situation. Took only a couple of minutes to solve with looking at the diagnostics. But again for me it was my trigger condition and reset condition for 2 alerts that needed to be updated. Hope this helps.

sschoenh

Kartoon:

Thank you for steering me in the right direction. I disabled alerts in groups to help narrow down this alert I had occuring once a minute. Narrowed it down to a similar situation (in my case it was an alert doing nothing -- i.e. a test alert set to email only) and once i disabled it, but still available to click test, the events in the event viewer stopped.

aarongibby

We had the same problem. Unlike other UpdateRowsThatAreTriggered() errors, the key to this one was "ExecuteReader: CommandText property has not been initialized", which indicates that SQL is receiving and empty string when it expects valid text.

We had an alert that was enabled but had no trigger condition. Disabling the alert solved the problem.