NFA Upgrade Migrator Failure: Can't Connect to MySQL due to JRE libraries missing

Products

• Network Flow Analysis
• Network Observability

Issue/Introduction

While upgrading NetOps Network Flow Analysis you may run into an issue where the Migrator may fail due to issues with connecting to the MySQL database according to the migrator.log:

2025-xx-xx 14:27:45.669 INFO [main] [com.ca.im.migrator.TheSet.migrate(Unknown Source)] - Target version='25.4.1.14' root='D:\CA\NFA'
2025-xx-xx 14:27:45.683 INFO [main] [com.ca.im.migrator.TheSet.makeMovie(Unknown Source)] - Making new movie
2025-xx-xx 14:27:45.684 INFO [main] [com.ca.im.migrator.business.SqlPropInspector.exists(Unknown Source)] - dbConnInfo.getHost: null dbConnInfo.getName: reporter dbConnInfo.getPort: 3308 dbConnInfo.getUser: root selectExistsSql: select 1
2025-xx-xx 14:27:45.801 WARN [main] [com.ca.im.migrator.business.SqlPropInspector.exists(Unknown Source)] - Exception: com.mysql.cj.jdbc.exceptions.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.
2025-06-06 14:27:45.802 FATAL [main] [com.ca.im.migrator.TheSet.migrate(Unknown Source)] - Unhandled exception
com.ca.im.migrator.exceptions.MigratorException: Cannot determine whether prop exists
 at com.ca.im.migrator.business.SqlPropInspector.exists(Unknown Source) ~[migrator.jar:?]
 at com.ca.im.migrator.TheSet.makeMovie(Unknown Source) ~[migrator.jar:?]
 at com.ca.im.migrator.TheSet.migrate(Unknown Source) ~[migrator.jar:?]
 at com.ca.im.migrator.MigratorApp.main(Unknown Source) ~[migrator.jar:?]
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

When trying to start the MySQL database, you would notice that it fails to start:

If you try to run: "java -version" from a command line, you would get the below error:

Environment

NFA Window/Linux

Resolution

1. Download the JRE modules file attached to the bottom of this document and copy the file to the affected server in the D:\CA\NFA\jre\lib directory.

2. Running: "java -version" should return a proper value now.

3. Next steps are to start CA MySQL and NetQoS MySQL (Harvester only).

4. Open a CMD line with root or admin privledges and chage directories to: D:\CA\NFA\migrator directory.

5. Run: runMigrator.vbs or runMigrator.sh (Linux)

6. Confirm the bottom of D:\CA\NFA\migrator\migrator.log shows exiting with a code 0 and that the version you are trying to install has been inserted intot he database.

7. Move the D:\CA\NFA\migrator\console_movie.xml (collector_movie.xml if Harvester) to the D:\CA\NFA\migrator\ directory and rename the file with .old at the end.

8. Continue on with the upgrade installer if you had not let it continue earlier.