9.5 Problems

Question

Get this when accessing any nodes from admin nodes:

The Commmunication Object, System.ServiceModel.Security...blahblahblah

Nothing Shows in Netflow Traffic Analysis .....

Cannot view any Nodes from Web

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.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at SolarWinds.Orion.Common.SqlHelper.ExecuteDataTable(SqlCommand command, SqlConnection connection, DataTable dataTable)
   at SolarWinds.Orion.Web.DAL.SqlDAL.GetActiveAlerts(Nullable`1 nodeID, Boolean showAcknowledged)
   at Orion_NetPerfMon_Resources_NodeDetails_ActiveAlerts.OnLoad(EventArgs e)

John

FormerMember · Answer

And the fix for SQL Express is ----SQL Server 2000 database compatible level to SQL Server 2005
EXEC sp_dbcmptlevel [DATABASE], 90;
GO

FormerMember · Answer

I have the same issue after upgrading, errored saying failed to import maps etc. Problem is I'm using SQL express and the compitibility is greyed out.

screen_328.gif

dixonhughes · Answer

I had a similar screen after updating to 9.5.  At the end of the initial configuration I received the following error.

Incorrect syntax near 'External'. You may need to set the compatibility level of the current database to a higher value to enable this feature.
sp_dbcmptlevel

The install finished but pages would not come up and would look like your screen shot.  I found the link below in the knowledgebase and tried it and re-ran the configuration wizard.  It did a repair and the pages loaded correctly.

Don't know if you got any errors and the end of the install or not.  If not, the link below may not help but maybe running the configuration wizard and letting it do a repair might help.

http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=1154