Somehow I have some Orphaned Interfaces. Does anyone know how to clean that up?I'm assuming the SQL statement:UDPATE InterfacesDELETE *WHERE NodeID = '<NodeID of orphaned interfaces>'
I know I have some, because I have a custom field that defaults to NULL and shouldn't be empty unless no Node.
I also want to ensure that I cover all other data relating...
Any thoughts?Thanks
Larry, On your Orion server check the latest Maintenance log file, C:\Program Files\SolarWinds\Orion\swdebugMaintenance.log, for the following lines:
ERROR SolarWinds.Data.DatabaseMaintenance.NetworkElements - Failed to cleanup deleted network elements tables.System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'dbm_DeleteFromDeletedNodes'. 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 SolarWinds.Data.DatabaseMaintenance.NetworkElements.DeleteNetworkElements(String tableName, String storedProcName) at SolarWinds.Data.DatabaseMaintenance.NetworkElements.RemoveDeletedElements()2007-08-11 02:46:54,753 [1] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Database Maintenance Complete.
If they are there, then follow the simple instructions in this post: http://thwack.com/forums/p/4654/20153.aspx#20153
Sure Enough, it's there. Thanks for the heads up.