Migrator error during reinstall NFA

Document ID : KB000031057
Last Modified Date : 21/08/2018
Show Technical Document Details
Issue:

Migrator Error in NFA after Harvester or Console Installation.  

You may encounter this error with NFA Harvester after an uninstall and reinstall attempt.

The Harvester installation fails with a migrator error in the migrator.log showing specifically this:
 

2015/06/04 14:06:13 INFO DriverManagerDataSource::setDriverClassName() - Loaded JDBC driver: com.mysql.jdbc.Driver
2015/06/04 14:06:15 WARN SqlPropInspector::exists() - Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. message: Communications link failure
 
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2015/06/04 14:06:15 FATAL TheSet::migrate() - Unhandled exception com.ca.im.migrator.exceptions.MigratorException: Cannot determine whether prop exists
at com.ca.im.migrator.business.SqlPropInspector.exists(Unknown Source)

This happens because the Mysql service doesn't get properly installed during the re-installation, because the installation detects that it may already be installed. 

Cause:
If the hidden directory C:\Program Files/Zero G Registry folder is still installed it can prevent services from getting installed during the reinstall, like MySQL for instance.
Resolution:

1. Uninstall NFA following ALL of the steps in the NFA Guide https://docops.ca.com/ca-network-flow-analysis/9-5-0/en/installing/uninstalling-the-software/.

2. Delete the hidden zero g registry directory from: C:\Program Files\Zero G Registry folder.

3. Delete the \CA\ directory.

3. Reboot the server.

4. Reinstall the NFA Harvester.

Additional Information:

Note: Also be aware, the uninstaller does not remove the IIS settings so if you reinstall the product in a directory different from the first installation, the installer will fail.

Note: The "Migrator" is the process that lays down the database tables and schema, so despite the name it also runs during a clean install.