I am receiving the following event log entry every minute on the system running Network Performance Monitor. We have the SQL server on a different box. I have tried restarting all services to include the SQL service. Does anyone know how to resolve this issue? How do you increase SQL timeouts for the NetPerfMon DB?
Source: AlertingEngine
Type: Information
2007-08-21 10:54:45,413 [AlertCheckingThread] WARN Error - Error in UpdateRowsThatAreReset() -
EXCEPTION STACK: --> The multi-part identifier "Nodes.NodeID" could not be bound. : .Net SqlClient Data Provider : 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();;;
