Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Network Performance Monitor (NPM) > Cannot find the object "NetFlowAccountLimitations" because it does not exist or you do not have permissions

Cannot find the object "NetFlowAccountLimitations" because it does not exist or you do not have permissions

Created by Eric Bryant, last modified by MindTouch on Jun 23, 2016

Views: 8 Votes: 0 Revisions: 5

Overview

The following error appears after upgrading NPM 10.x to 11.0.1 and/or upon isntallation of NPM 11.5.x.

ERROR DBConfigProcessor - Error while executing script - Cannot find the object "NetFlowAccountLimitations" because it does not exist or you do not have permissions..
 Error details: System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "NetFlowAccountLimitations" because it does not exist or you do not have permissions.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.ExecuteSqlBatch(IDbConnection connection, String sqlQuery, ConfigurationLogDelegate configLog)

Environment

Upgrade of NPM 11.5.x and later

Cause 

Upgrading from an old version of NPM/RC to NPM 11.5.x.

Resolution

  1. Open SQL Management Studio.
  2. Connect to Orion Database.
  3. Expand Database.
  4. Expand dbo.Limitations table.
  5. Expand Triggers folder.
  6. Delete tr_XXXXX (anything present under this folder).
  7. Run the Configuration Wizard.

 

Last modified
21:49, 22 Jun 2016

Tags

Classifications

Public