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

Document created by Christopher_Walsh Employee on Aug 7, 2014
Version 1Show Document
  • View in full screen mode

If your Harvester upgrade from 9.0.161 to 9.1.3 fails during migrator check the the migrator.log file in the \NetQos\migrator\ directory.

 

If you see the error below follow the solution in this post:

 

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:

      ftp://ftp.ca.com/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.

 

This solution can also be found on Support.ca.com here.

 

This document was generated from the following discussion: Tech Tip: Harvester upgrade from 9.0.161 to NFA 9.1.3 fails with Migrator Failed Unknown table engine 'RPR15'

Attachments

    Outcomes