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
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:
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`)
4) Exit from MySQL, and restart all NFA services on the Harvester machine