Submit a ticketCall us
Home > Success Center > Netflow Traffic Analyzer (NTA) > Error: Cannot find the object dbo.NetFlowDetail_1234_1234567 because it does not exist or you do not have permissions

Error: Cannot find the object dbo.NetFlowDetail_1234_1234567 because it does not exist or you do not have permissions

Updated January 19, 2017

Overview

An error similar to the following appears when compacting or reindexing a database on the NetFlowDetail tables:

Error: Cannot find the object "dbo.NetFlowDetail_1234_1234567" because it does not exist or you do not have permissions.

Environment

All NTA versions

Cause 

The reason for this error is each these NetflowDetail tables store only 15 minutes of uncompressed data per interface (You can actually see the interface ID in the table name - the other number is a timestamp). The netflow service is almost constantly creating and removing these tables as it receives data. It removes the table as it compresses the data in that table to store it as compressed historical netflow statistics.


When you run a reindex against all tables, it typically enumerates all tables at the start of the procedure, then works its way down the list and reindexes each table one at a time. By the time it gets to the NetflowDetail tables, there's a very good chance one or more tables have already been deleted again.


If you want to run the reindex cleanly against all tables with that command, I would suggest stopping the netflow service first - this will stop these tables from changing while the reindex is running. Ideally, you should have stopped all Orion services, to ensure that any locks placed on tables during the reindex doesn't affect your Orion services.

Resolution

You can ignore this error, as it will happen if you try to run a reindex (or a compact/repair in database manager) against every table when the netflow service is running.

 

Last modified
18:06, 18 Jan 2017

Tags

Classifications

Public