Hide this message
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.
Updated January 19, 2017
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.
All NTA versions
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.
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.