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