NFA 22.2.6 Migrator Error: Access denied for user
search cancel

NFA 22.2.6 Migrator Error: Access denied for user


Article ID: 262706


Updated On:


CA Network Flow Analysis (NetQos / NFA) DX NetOps


While upgrading to Network Flow Analysis 22.2.6, you may run into a migrator failure. When trying to run the runMigrator.vbs or script again, you may notice this error when checking the <installdir>/CA/NFA/migrator/migrator.log:

2023-02-27 13:15:13.591 FATAL [main] [ Source)] - Error playing back movie Movie playback failed.
 at Source) ~[migrator.jar:?]
 at Source) ~[migrator.jar:?]
 at Source) ~[migrator.jar:?]
 at Source) ~[migrator.jar:?]
Caused by: SQL action failed
 at Source) ~[migrator.jar:?]
 ... 4 more
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)
 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException( ~[migrator.jar:?]
 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException( ~[migrator.jar:?]
 at com.mysql.cj.jdbc.ConnectionImpl.createNewIO( ~[migrator.jar:?]
 at com.mysql.cj.jdbc.ConnectionImpl.<init>( ~[migrator.jar:?]
 at com.mysql.cj.jdbc.ConnectionImpl.getInstance( ~[migrator.jar:?]
 at com.mysql.cj.jdbc.NonRegisteringDriver.connect( ~[migrator.jar:?]
 at java.sql.DriverManager.getConnection(Unknown Source) ~[java.sql:?]
 at java.sql.DriverManager.getConnection(Unknown Source) ~[java.sql:?]
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager( ~[migrator.jar:?]
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver( ~[migrator.jar:?]
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver( ~[migrator.jar:?]
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection( ~[migrator.jar:?]
 at Source) ~[migrator.jar:?]
 at Source) ~[migrator.jar:?]
 at Source) ~[migrator.jar:?]
 ... 4 more
2023-02-27 13:15:13.633 INFO [main] [ Source)] - Writing movie file D:\CA\NFA\console_movie.xml
2023-02-27 13:15:13.761 INFO [main] [ Source)] - Exiting with code 1



NFA 22.2.6 only.


With the upgrade to NFA 22.2.6 comes the upgrade from MySQL 5.7 to MySQL 8.0. MySQL 8.0 came a change that needed to be made in the migrator.jar file which the .vbs or .sh script references. This change was not found until after NFA 22.2.6 was shipped.


This fix is only needed if you need to re-run the runMigrator.vbs or script to complete an upgrade to NFA 22.2.6. This will be resolved in NFA 22.2.7+.

  1. Download the attached file: and copy it to the NFA server in need.
  2. Extract the contents and read the readme.txt included.
  3. To patch the migrator, it is as simply as replacing the <installdir>/CA/NFA/migrator/migrator.jar with the newly patched version.
  4. Once the file is replace, you can proceed to run the runMigrator.vbs or scripts as you normally would.


Attachments get_app