NFA not showing netflow data. Harvester-wrapper.log shows Table 'harvester.port_definitions' doesn't exist

Products

• Network Flow Analysis

Issue/Introduction

Harvesters are not showing data after an upgrade to NFA 9.3.8.  The Harvester-wrapper.log file is showing the following error:

INFO | jvm 1 | 2018/11/15 19:10:00 | 7:10:00 PM - [SEVERE ] - Error refreshing in memory router and interface cache from the database 
INFO | jvm 1 | 2018/11/15 19:10:00 | com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'harvester.port_definitions' doesn't exist 
 

Environment

NFA 9.3.8

Resolution

NOTE: The following commands are for NFA 9.3.8. Other NFA versions may require different commands to create the missing table.

We can use the following procedure to re-create the table that is missing on the Harvester: 

1) Go to the \NFA\MySql\data\harvester directory and delete any "port_definitions.* files" present there. 

2) Go into the Harvester database in mysql: 
mysql harvester 

3) Run the following commands to create the missing port_definitions table: 
CREATE TABLE `port_definitions` ( 
`PortType` char(3) NOT NULL default 'TCP', 
`StartPort` int(10) unsigned NOT NULL default '0', 
`EndPort` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY (`PortType`, `StartPort`, `EndPort`) 
) ENGINE=InnoDB; 

4) Exit from MySQL, and restart all NFA services on the Harvester machine