Thwack » SolarWinds » Orion Network Performance Monitor » Incorrect syntax in nightly maintenance

in More Search Options

Incorrect syntax in nightly maintenance

Last post 08-11-2007 11:57 AM by WINNT. 3 replies.
Page 1 of 1 (4 items)
Sort Posts:

  • 08-10-2007 10:14 PM

    • WINNT
    • Top 75 Contributor
      •
    • Joined on 06-22-2004
    • USA
    • Posts 99
    • Points 580

    Incorrect syntax in nightly maintenance

    Reply

    Is anyone else getting this error in their swdebugMaintenance.log file?

     (Yes, I have submitted a ticket to support).

    2007-08-10 22:52:00,663 [5] INFO  SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Finializing maintenance for  VolumeUsage
    2007-08-10 22:52:00,679 [5] 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-10 22:52:00,694 [5] INFO  SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Database Maintenance Complete.
    Filed under: , , ,
    • Post Points: 5

  • 08-11-2007 6:23 AM In reply to

    Re: Incorrect syntax in nightly maintenance

    SolarWinds.Orion.Core.Data.zip
    Reply

     There is a fix for this. You will need to register this .dll

    Instructions:

    Stop all the Orion services.

    Replace the SolarWinds.Orion.Core.Data.dll in C:\Program Files\SolarWinds\Orion with the one in the attached zip file.

    Start everything back up again.

     

    When database maintenance runs again, it should work this time.

     

     

     

     

    Mark Wiggans
    Thwack Moderator
    • Post Points: 3

  • 08-11-2007 8:13 AM In reply to

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

    Re: Incorrect syntax in nightly maintenance

    Reply

    Yes, same error here, you are not alone...

    That DLL file fixes it :)

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

    Live Solid. Bank Solid.
    • Post Points: 1

  • 08-11-2007 11:57 AM In reply to

    • WINNT
    • Top 75 Contributor
      •
    • Joined on 06-22-2004
    • USA
    • Posts 99
    • Points 580

    Re: Incorrect syntax in nightly maintenance

    Reply

    Thanks!  That did the trick!  

    • Post Points: 1
Page 1 of 1 (4 items)