NFA 22.2.6 Migrator Error: Database 'backup' doesn't exist Migrator Error
search cancel

NFA 22.2.6 Migrator Error: Database 'backup' doesn't exist Migrator Error


Article ID: 260916


Updated On:


DX NetOps CA Network Flow Analysis (NetQos / NFA)


While trying to upgrade to NFA Console 22.2.6 or higher you may run into a Migrator error.

When observing the end of the x:/CA/NFA/migrator/migrator.log file you may notice:

2023-02-28 08:35:10.417 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.SQLSyntaxErrorException: Database 'backup' doesn't exist
 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.ClientPreparedStatement.executeInternal( ~[migrator.jar:?]
 at com.mysql.cj.jdbc.ClientPreparedStatement.execute( ~[migrator.jar:?]
 at Source) ~[migrator.jar:?]
 at Source) ~[migrator.jar:?]
 ... 4 more



Release : 22.2.6 only


At some point in time a database named 'backup' was introduced but never used. The migrator script does not account for if the database doesn't exist. To prevent this from occurring prior to the upgrade attempt please see: 


1. First you need to patch the migrator.jar file with patch:

2. Open a CMD prompt as administrator and type:

  1. mysql -uroot -proot@123
  2. create database backup;
  3. exit

3. Now change directories to x:/CA/NFA/migrator.

4. Type in: runMigrator.vbs

5. Observe the x:/CA/NFA/migrator/migrator.log to see if it makes it past the original error and completes with an exit code of 0. 

6. If there is an exit code of 0, copy the x:/CA/NFA/console_movie.xml to x:/CA/NFA/migrator and rename the file to old_console_movie_22.2.6.xml

7. If there is another error and exit code of 1, please open a support case with Broadcom.

Additional Information

This issue will be resolved for NFA 22.2.7+