DX Unified Infrastructure Management

Hello! I having some problems with a fresh install of Netqos NFA, one harvester server and another with console+dsa.

Versions:

Harvester 9.2

Network Flow Analysis 9.2.0 (build133)

NPC 6.2 (build 103)

There is no visualization of data bigger than 2 hours, I know is something about DSA DB There is data incoming in D:\CA\NFA\Netflow\datafiles\ReaperArchive15 and other directories inside D:\CA\NFA\Netflow\datafiles\

I check dsaLoaderErrors-2018-08-09.log and I have this

messages 09:47:33

Severity 2 - Query failed: call sp_get_interfaces_for_dsa_with_id('1'). 09:47:33

Severity 2 - Load aborted. We'll try to connect to the console again in a minute. 09:47:33

Severity 2 - The list of interfaces for this dsa isn't available. Aborting load of data.

and in pumpservice-wrapper.log

INFO | jvm 1 | 2018/08/09 09:17:17 | 9:17:17 AM - [INFO] - Received 1533816900-10.***.***.211_proto.rpr from 10.***.***.212 INFO | jvm 1 | 2018/08/09 09:17:17 | 9:17:17 AM - [DEBUG] - Fetching file 1533816900-10.x.x.211_tos.rpr from 10.***.***.212:8080//datashare/1 to d:/CA/NFA/Netflow/datafiles/loaderInput INFO | jvm 1 | 2018/08/09 09:17:17 | 9:17:17 AM - [DEBUG] - Deleting file 1533816900-10.***.***.211_tos.rpr from 10.***.***.212:8080//datashare/1 INFO | jvm 1 | 2018/08/09 09:17:17 | 9:17:17 AM - [INFO] - Received 1533816900-10.***.***.211_tos.rpr from 10.***.***.212 INFO | jvm 1 | 2018/08/09 10:04:03 | 10:04:03 AM - [INFO] - Received listing of 0 files from 10.***.***.212 INFO | jvm 1 | 2018/08/09 10:05:08 | 10:05:08 AM - [INFO] - Received listing of 0 files from 10.***.***.212 INFO | jvm 1 | 2018/08/09 10:05:48 | 10:05:48 AM - [INFO] - Loaded 1 channels INFO | jvm 1 | 2018/08/09 10:05:53 | 10:05:53 AM - [INFO] - Received listing of 0 files from 10.***.***.212 INFO | jvm 1 | 2018/08/09 10:06:58 | 10:06:58 AM - [INFO] - Received listing of 0 files from 10.***.***.212 INFO | jvm 1 | 2018/08/09 10:08:03 | 10:08:03 AM - [INFO] - Received listing of 0 files from 10.***.***.212 INFO | jvm 1 | 2018/08/09 10:09:08 | 10:09:08 AM - [INFO] - Received listing of 0 files from 10.***.***.212 INFO | jvm 1 | 2018/08/09 10:10:13 | 10:10:13 AM - [INFO] - Received listing of 0 files from 10.***.***.212 INFO | jvm 1 | 2018/08/09 10:10:54 | 10:10:54 AM - [INFO] - Loaded 1 channels

In RA the message is "no network flow analysis data-available"

thanks

Diego

NFA 9.2, is a very old, soon to be out of support release of NFA. There are also a lot of defects in this version that have been resolved in later releases. 

I would highly recommend uninstalling and installing a new environment with a later version of NFA.

If you are stuck on Windows 2008 servers, install a two tier 9.3.3 environment.

If you are able to get Windows 2012 servers, install 9.3.8 or 9.5.

Also NFA no longer supports 3 tier environments after 9.3.3, we now recommend using a 2 tier architecture, meaning the Harvester server stores all of the data, and there is no DSA.

The error you referenced, "Query failed: call sp_get_interfaces_for_dsa_with_id('1')" sounds like there is a missing stored procedure on the Console or DSA server.  

Stored procedures can be lost when migrating to a new server, and if you didn't backup and restore the mysql.proc table.

It could have also been a defect in this release.

If you go to the Console and DSA and run the following, what is the output?