Upgrade NFA Console doesn't update NFA version in Netops Portal or in reporter.revision_history table

Products

• Network Flow Analysis

Issue/Introduction

We just finished trying to upgrade NFA.  After letting it reboot it still shows the old NFA version number on the web portal. 


When logging into the Console server, the reporter.revision_history table still shows the old version, e.g.:

mysql -unetqos -pnetqos 
mysql> select * from reporter.revision_history;

 

The migrator.log file ends with "Return Code 1" instead of 0, and contains errors such as:

 

2023-08-15 15:06:03.973 INFO [main] [com.ca.im.migrator.TheSet.migrate(Unknown Source)] - Target version='22.2.11.12' root='D:\NFA'
2023-08-15 15:06:04.004 INFO [main] [com.ca.im.migrator.business.Library.getMovie(Unknown Source)] - Loading movie file D:/NFA\console_movie.xml
2023-08-15 15:06:04.118 INFO [main] [com.ca.im.migrator.business.Projector.play(Unknown Source)] - Playing back movie console_movie
2023-08-15 15:06:04.118 INFO [main] [com.ca.im.migrator.business.Projector.play(Unknown Source)] - Frame #7: [SqlAction database=reporter port=3308 sql='ALTER DATABASE `backup` CHARACTER SET utf8mb4']
2023-08-15 15:06:04.493 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
2023-08-15 15:06:04.508 INFO [main] [com.ca.im.migrator.business.Library.putMovie(Unknown Source)] - Writing movie file D:\NFA\console_movie.xml
2023-08-15 15:06:04.555 INFO [main] [com.ca.im.migrator.MigratorApp.main(Unknown Source)] - Exiting with code 1

Environment

NFA Console upgrade

Cause

Old "console_movie.xml" file leftover from a previous install was still present in the \NFA\ directory

Resolution

Try manually completing the upgrade using the following procedure:

- Open a cmd prompt in the <installdir\Migrator> directory and run the runMigrator.vbs script via CMD prompt as an Administrator.
- Wait a few minutes and check the <installdir\Migrator\migrator.log> file to see if it finished with "Exiting with code 0."
   
If you see this, the Migrator task is complete. check the NFA version in the database again by running:
mysql reporter -unetqos -pnetqos
select * from revision_history;

If the upgrade is successful, this should return the correct NEW version.

Reboot the NFA Console, and the upgrade should be complete.

After the upgrade is complete, check the \CA\NFA\ directory to see if it still contains a file called Console_movie.xml. 

If it does, rename this to old_console_movie.xml and move it to the  \CA\NFA\Migrator\ directory. Otherwise, the problem might return again during the next upgrade.