Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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: 13 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