Harverster Migrator Failure 9.3.3 to 9.3.8: Can't DROP 'PRIMARY'

Document ID : KB000093534
Last Modified Date : 30/04/2018
Show Technical Document Details
Issue:
While upgrading your NFA Harvester from 9.3.3 to 9.3.8 you may run into a migrator error.

check the migrator log <installdir>\migrator\migrator.log for this EXACT error:

2018/05/01 00:02:51 INFO  Projector::play() - Frame #30: [SqlAction database=harvester port=3308 sql='drop index `PRIMARY` on trap_definitions'] 
2018/05/01 00:02:51 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: Can't DROP 'PRIMARY'; check that column/key exists
    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:404)
    at com.mysql.jdbc.Util.getInstance(Util.java:387)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
    at com.ca.im.migrator.data.BaseDao.executeNonQuery(Unknown Source)
    ... 5 more
2018/05/01 00:02:51 INFO  Library::putMovie() - Writing movie file D:\netqos\collector_movie.xml 
2018/05/01 00:02:51 INFO  MigratorApp::main() - Exiting with code 1 
Environment:
CA NFA 9.3.3
CA NFA 9.3.8
Windows 2012
Red Hat Enterprise Linux 6.7, 6.8 or 7.3 
Resolution:
  1. DO NOT continue installation until issue has been resolved.
  2. Download ftp://ftp.ca.com/pub/netqos/supporttools/releasedtools/trap_definitions.sql
  3. Copy to Harvester with issue.
  4. Open a CMD prompt with administrator privileges from the directory where trap_definitions resides and type:
  • mysql harvester < trap_definitions.sql
  • cd <installdir>\migrator\
  • runMigrator.vbs 
  1. Once the script is complete, you can continue on with the upgrade.