Upgrade NFA Console From 9.3.8 to 9.5 Completes With Movie Has Already Ended message

Document ID : KB000117546
Last Modified Date : 15/10/2018
Show Technical Document Details
Issue:
We just finished trying to upgrade NFA from 9.3.8 to 9.5.0. The Harvesters looked like they completed successfully and the Console gave no errors. After letting it reboot it still shows 9.3.8 on the web portal and throws up the following errors:

- Unknown column 's.LastRealTime' in 'field list'

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at NetQoS.Data.MySqlDataComponentBase.ExecuteDataTable(MySqlConnection connection, String sql, DataTable table, DataParameter[] dataParameters)

at NetQoS.Data.MySqlDataComponentBase.ExecuteDataTable(MySqlConnection connection, String sql)

at NetQoS.Data.MySqlDataComponentBase.ExecuteDataTable(String sql)

at NetQoS.ReporterAnalyzer.Data.ReporterAnalyzer.SystemStatusDc.GetHarvestersStatus()

at NetQoS.ReporterAnalyzer.Business.SystemStatus.HarvesterStatus.Get()

at NetQoS.ReporterAnalyzer.Business.SystemStatus.GetHarvesterStatus()

at NetQoS.ReporterAnalyzer.WebService.SystemStatusWS.GetSystemStatus()



When logging into the Console server:

mysql> select * from reporter.revision_history;
+--------------+--------------+-------------+--------------+---------------------+------------------------------------------+-------------------+
| MajorVersion | MinorVersion | BuildNumber | HotfixNumber | InstallDate | Description | HotfixDescription |
+--------------+--------------+-------------+--------------+---------------------+------------------------------------------+-------------------+
| 9 | 3 | 122 | 6 | 2017-06-23 08:52:34 | CA Network Flow Analysis 9.3 (build 122) | HOTFIX 6 |
| 9 | 3 | 24 | 8 | 2018-07-17 17:47:11 | CA Network Flow Analysis 9.3 (build 24) | HOTFIX 8 |
+--------------+--------------+-------------+--------------+---------------------+------------------------------------------+-------------------+
2 rows in set (0.00 sec)
Environment:
NFA Console 9.5 upgrade from 9.3.8
Resolution:
Check the file CA\NFA\migrator\migrator.log for the following error:

2018/10/15 09:35:03 INFO TheSet::migrate() - Target version='9.5.0.101' root='D:\CA\NFA' 
2018/10/15 09:35:03 INFO Library::getMovie() - Loading movie file D:/CA/NFA\console_movie.xml 
2018/10/15 09:35:04 INFO Projector::play() - Movie has already ended. 
2018/10/15 09:35:04 INFO Library::putMovie() - Writing movie file D:\CA\NFA\console_movie.xml 
2018/10/15 09:35:04 INFO MigratorApp::main() - Exiting with code 0 



If this "Movie has already ended" message is present, 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
select * from revision_history;

If the upgrade is successful, this should return:
+--------------+--------------+-------------+--------------+-
| MajorVersion | MinorVersion | BuildNumber | HotfixNumber |
+--------------+--------------+-------------+--------------+-
| 9            | 5            | 101         | 0            |
+--------------+--------------+-------------+--------------+-

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