Migrator Error in NFA after 9.3.1 Harvester Install because of hidden G Registry folder directory

Document ID : KB000031057
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

Migrator Error in NFA after Harvester Install.

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. 

Resolution:

1. Uninstall NFA following ALL of the steps in the NFA installation guide https://wiki.ca.com/display/NFA931/Uninstalling%20the%20Software

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

3. Reboot the server.

4. Reinstall the NFA Harvester.

 

Root 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.

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.