in More Search Options

SQL Help - cleaning orphaned Interfaces

Last post 08-13-2007 11:57 AM by njoylif. 2 replies.
Page 1 of 1 (3 items)
Sort Posts:
  • 08-10-2007 9:26 PM

    • njoylif
    • Top 50 Contributor
    • Joined on 07-03-2007
    • Atlanta, GA
    • Posts 201
    • Points 419

    SQL Help - cleaning orphaned Interfaces

    Somehow I have some Orphaned Interfaces.  Does anyone know how to clean that up?
    I'm assuming the SQL statement:
    UDPATE Interfaces
    DELETE *
    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 J. Rice
    RelayHealth
    Network Architect
    678-984-1686
    Filed under: , ,
    • Post Points: 3
  • 08-11-2007 10:55 AM In reply to

    • jtimes
    • Top 25 Contributor
    • Joined on 09-15-2005
    • Atlanta Georgia
    • Posts 359
    • Points 2,548

    Re: SQL Help - cleaning orphaned Interfaces

    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

     

    John J. Times
    Systems Management & Automation
    Enterprise Technology Infrastructure
    SunTrust Banks Inc.

    Live Solid. Bank Solid.
    • Post Points: 3
  • 08-13-2007 11:57 AM In reply to

    • njoylif
    • Top 50 Contributor
    • Joined on 07-03-2007
    • Atlanta, GA
    • Posts 201
    • Points 419

    Re: SQL Help - cleaning orphaned Interfaces

    Sure Enough, it's there.  Thanks for the heads up.

    Larry J. Rice
    RelayHealth
    Network Architect
    678-984-1686
    • Post Points: 1
Page 1 of 1 (3 items)