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

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


Article ID: 18237


Updated On:


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



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.


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.

  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.


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