We have an issue with the alert engine. Every day or two, we start getting these errors every 5 seconds. The only way to fix it is to restart the alert engine service and it is fine for another day or two. Any help would be great.
2007-12-29 20:40:27,845 [MainTaskThread] ERROR All - Error in SetupMainDBConnection System.NullReferenceException: Object reference not set to an instance of an object.
at System.Data.SqlClient.SqlCommand.Unprepare(Boolean isClosing)
at System.Data.SqlClient.SqlInternalConnectionTds.ClearPreparedCommands()
at System.Data.SqlClient.SqlInternalConnection.CloseConnection(DbConnection owningObject, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Close()
at System.Data.SqlClient.SqlConnection.Dispose(Boolean disposing)
at System.ComponentModel.Component.Dispose()
at AlertingEngine.SWAlertingEngine.SetupMainDBConnection()
