Just got done with the upgrade from 8.5 > 9.1 > 9.5 Here's a few notes:
Before:
Orion V.8.5.1
Legacy Application Monitor (I believe this is the problem)
APM V.1.0
Then:
Uninstall Legacy application Monitor in order to install 9.1
Install 9.1, run through config etc
Install APM V.2.5 to upgrade 1.0, but then end up applying sp5 to 9.1
Installed APM V.2.5 on NPM 9.1 SP5
Finally:
Ended up Installing NPM 9.5 and installing SP2
Looking at the database, the Applications table and the ApplicationStatistics table are still in there...
This error shows up on ALL pages that try to use NodeDetails.aspx:
System.Data.SqlClient.SqlException: Invalid object name 'NPM_NV_WL_CONTROLLERS_V'.
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.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at SolarWinds.Orion.Common.SqlHelper.ExecuteReader(SqlCommand command, SqlConnection connection)
at SolarWinds.NPM.BL.ListOfNPMData`1.GetCountFromDB()
at Orion_NetPerfMon_Controls_NodeLink.setValues()
at Orion_NetPerfMon_Controls_NodeLink.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
I have already set the compatibility level to 90...This is referenced in SW Support Case # 106152
