Solarwinds log full of information messages

Question

Hi all,

i am seeing between 2 and 5 messages per second written to the SolarWinds.net log in computer management as follows.  is anyone else seeing this?  is it a problem i shoudl be worried about?

it was present before the upgrade to 9.5...

Event Type: Information
Event Source: AlertingEngine
Event Category: None
Event ID: 0
Date:  22/06/2009
Time:  11:49:52 am
User:  N/A
Computer: BT3NPM
Description:
2009-06-22 11:49:52,181 [AlertCheckingThread] WARN  Error - Error in UpdateRowsThatAreReset() - 
System.Data.SqlClient.SqlException: Ambiguous column name 'NodeID'.
Ambiguous column name 'NodeID'.
Ambiguous column name 'NodeID'.
Ambiguous column name 'NodeID'.
Ambiguous column name 'NodeID'.
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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at AlertingEngine.CheckAlert.UpdateRowsThatAreReset()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Yann · Answer

One of the alert might be causing the issue.

Try the following to identify it.

Start > All Programs > SolarWinds Orion > System Manager

Click on Alerts. Select the Advanced Alerts tab.

Check the option "Disable all Actions for All Advanced Alerts".

Click on Configure Advanced Alerts. Disable all the alerts and enable them one by one while checking the SolarWinds.Net event log.

See if one alert could be the root cause of these information events.

Once finished the test uncheck "Disable all Actions for All Advanced Alerts".

Thanks,

Yann

FormerMember · Answer

hi there,

I do have this hotfix installed.  that said, this issue was prsetn before the 9.5 upgrade anyway...

cheers

dan

Yann · Answer

Hi,

Please check if the HotFix solves your issue.

Thanks,

Yann