Harvester upgrade from 9.0.161 to NFA 9.1.3 fails with Migrator Failed Unknown table engine 'RPR15'

Products

• CA Application Delivery Analysis MTP (NetQoS / ADA)
• CA Infrastructure Performance

Issue/Introduction

Description:

Harvester upgrade from 9.0.161 to 9.1.3 fails during migrator.

The migrator.log file shows the error below:

INFO Projector::play() - Frame #100: [SqlAction database=archive15 port=3307 sql='create table protocol_traffic 
( 'router' int unsigned not null, 'interface' int unsigned not null, 'timestamp' int unsigned not null, 'protocol' 
int unsigned not null, 'inoctets' float not null, 'outoctets' float not null, index routerInterfaceTimeIndex 
('router', 'interface', 'timestamp') ) engine=RPR15'] 
FATAL TheSet::play() - Error playing back movie 
com.ca.im.migrator.exceptions.MigratorException: Movie playback failed.
at com.ca.im.migrator.business.Projector.play(Unknown Source)
at com.ca.im.migrator.TheSet.play(Unknown Source)
at com.ca.im.migrator.TheSet.migrate(Unknown Source)
at com.ca.im.migrator.MigratorApp.main(Unknown Source)
Caused by: com.ca.im.migrator.exceptions.SqlActionExecutionException: SQL action failed
at com.ca.im.migrator.business.action.SqlAction.execute(Unknown Source)
... 4 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table engine 'RPR15'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)
at com.ca.im.migrator.data.BaseDao.executeNonQuery(Unknown Source)
... 5 more
INFO Library::putMovie() - Writing movie file D:\NETQOS\collector_movie.xml 
INFO MigratorApp::main() - Exiting with code 1 

This will happen if during the upgrade of the Harvester if the installer cannot shutdown the Reaper Service in a reasonable amount of time.

Being that the Reaper service is still running, the installer will fail to replace the netqossql51.exe file in the D:\NetQos\NetFlow\bin directory with the updated file.

This new binary file is needed for the migrator to complete all of its MySql scripts.

Solution:

To resolve this follow the steps below:

1. You need to make sure the 9.1.3 version of the 'netqossql51.exe' is copied over the older version in the D:\NetQos\NetFlow\bin directory.
   
   
   • You can copy and replace the file from another Harvester where the upgrade succeeded.
     
     
   • Or if you do not have any Harvesters which the upgrade completed without error you can download the 'netqossql51.exe' file from the FTP link below:
     
     https://ftp.broadcom.com/user/downloads/pub/netqos/products/NFA/9.1.3/9.1.3_netqossqld51.zip
     
     Just Unzip the file on to your Harvesters and copy the 'netqossql51.exe' over the exiting file in the D:\NetQos\NetFlow\bin directory.
     
     
2. Once you replace the file you will need to run the Migrator manually so that all of the MySql updates can complete.
   
   The migrator will pick up where it left off.
   
   To run the migrator manually Open the Command Prompt and rerun the \<Install_Dir>\migrator\runMigrator.vbs script and check then check the \<Install_Dir>\migrator\migrator.log file to see if the migrator completes with exit code 0.
   
   
3. Verify you can start the 'CA NFA Reaper Service' and all other CA NFA services on the Harvester.

Environment

Release: RAIB1H99000-9.1-Network Flow Analysis-Interface Bundle-Hardware
Component: