Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Netflow Traffic Analyzer (NTA) > Connection to NTA Flow Storage Database has been lost

Connection to NTA Flow Storage Database has been lost

Created by Sterling Elliott, last modified by Andy Ng on May 09, 2017

Views: 158 Votes: 1 Revisions: 5

Updated: June 30, 2016

Overview

This article describes the issue when after installing NTA 4.2, you lose connection to the Fastbit or flow storage database.

 

Environment

NTA version 4.2

For scenario #2 - VMWare ESXi 6.0; SQL 2014 SP2 build 12.0.5000.0

Cause 

#1: The NTA module on the main NPM server is different then the one on the Fastbit or Flow storage DB.

 

#2: Performance issue on SQL and/or FSDB

Exceptions "NetFlowPacketWorkflowManager - Error flushing data" found in NTA.BusinessLayer.log

Resolution

#1: Upgrade the NTA module on NPM server to 4.2 using the same installer.

 

#2: To fix exceptions in NTA.BusinessLayer.log

-  Upgrade SQL Server from 2014 SP2 build 12.0.5000.0 to 2014 SP2 CU4 build 12.0.5540.0

- Backup Orion database (as an insurance)

- Stop Netflow service

- Run " TRUNCATE table dbo.NetFlowFastBitStringHeap" command in SQL Management Studio against Orion database,

- Start Netflow service,

 

Thereafter, optimize SQL:

a. Index defragmentation - here

b. SQL server optimization - here

c. On VMWare ESXi 6.0, it is well know to have dysfunction impacting FastBit remote flow storage.  Ensure that ESXi600-201509201-UG: Updates esx-base (2124716) applied on host of FSDB - details here

 

 

Last modified

Tags

Classifications

Public