4 Replies Latest reply on Oct 17, 2007 3:10 PM by gnewt

    NTA sys.tables invalid object after 2.2 and 8.5 upgrades

    gnewt

      After installing the latest 8.5 and 2.2 hotfixes, NetFlow reports for both devices and interfaces fail with:


      System.Exception: Unable to create TopApplicationsReport. ---> System.Data.SqlClient.SqlException: Invalid object name 'sys.tables'.
         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.SqlDataReader.ConsumeMetaData()
         at System.Data.SqlClient.SqlDataReader.get_MetaData()
         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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
         at System.Data.SqlClient.SqlCommand.ExecuteScalar()
         at SolarWinds.Netflow.Reporting.TopObjectsReport.TableExists(String query)
         at SolarWinds.Netflow.Reporting.TopApplicationsReport..ctor(Int32 rowCount, FilterCollection filters)


      Anyone else seeing this behavior before I log a support call?


      cheers ... gn