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

Products

• DX NetOps
• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

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] [com.ca.im.migrator.TheSet.play(Unknown Source)] - Error playing back movie
com.ca.im.migrator.exceptions.MigratorException: Movie playback failed.
 at com.ca.im.migrator.business.Projector.play(Unknown Source) ~[migrator.jar:?]
 at com.ca.im.migrator.TheSet.play(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.ca.im.migrator.exceptions.SqlActionExecutionException: SQL action failed
 at com.ca.im.migrator.business.action.SqlAction.execute(Unknown Source) ~[migrator.jar:?]
 ... 4 more
Caused by: java.sql.SQLSyntaxErrorException: Database 'backup' doesn't exist
 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[migrator.jar:?]
 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[migrator.jar:?]
 at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[migrator.jar:?]
 at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) ~[migrator.jar:?]
 at com.ca.im.migrator.data.BaseDao.executeNonQuery(Unknown Source) ~[migrator.jar:?]
 at com.ca.im.migrator.business.action.SqlAction.execute(Unknown Source) ~[migrator.jar:?]
 ... 4 more

 

Environment

Release : 22.2.6 only

Cause

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:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/network-flow-analysis/22-2/upgrading.html 

Resolution

1. First you need to patch the migrator.jar file with patch: NFA_22.2.6_PTF_002.zip

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+