Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Alerts stopped working on NPM

On Wednesday, I updated the nodes table with a new Read-Only community string. Ever since the alert emails have stopped. Solarwinds log shows the following messages.

2011-08-02 15:57:29,281 [AlertCheckingThread] WARN Error - Error in UpdateRowsThatAreTriggered() - GetNetObjects

System.Data.SqlClient.SqlException: Ambiguous column name 'NodeID'.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 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()

I restarted the application but that did not fix the problem. Any ideas?

Find more posts tagged with

Accepted answers

All comments

Nandish

I believe updating the Nodes table directly would have caused the problem.there would be dependencies of the fields in this table with other tables in the database.

This error message "System.Data.SqlClient.SqlException: Ambiguous column name 'NodeID'." gives a hint of it.

I would recommend to open a support ticket to look into this deeper.

Daniel.Chambers

Did you update the SNMP string by using SQL? If that is the case, then you may have caused a problem with the Database and you may have added an extra column or something in? Do you have the SQL code that you used to change the Database (if you did it via SQL and not SolarWinds)?

But opening a support case may be best - or backing up your Database and then re-running the Configuration Wizard, as this may fix any Database issues (but if you have changed the table layout or anything, then it could potentially screw it up, so make sure you take a backup!)