NFA 9.5.0 Harvester Migrator Failure: Frame 233

Document ID : KB000117604
Last Modified Date : 16/10/2018
Show Technical Document Details
Issue:
While upgrading NFA Harvester to 9.5.0 you may run into a migrator failure on frame 233.

For NFA 9.3.8 Frame 233 error: KB000099912

The error will be in the <installdir/migrator/migrator.log> and look like:

2018/10/11 14:52:39 INFO  Projector::play() - Frame #233: [SqlAction database=mysql port=3307 sql='CREATE FUNCTION v6_type RETURNS INTEGER SONAME 'nqUDF64.dll''] 
2018/10/11 14:52:39 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: java.sql.SQLException: Function 'v6_type' already exists
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)
    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/10/11 14:52:39 INFO  Library::putMovie() - Writing movie file D:\CA\NFA\collector_movie.xml 
2018/10/11 14:52:39 INFO  MigratorApp::main() - Exiting with code 1 
Resolution:
  1. Edit the <installdir/collector_movie.xml> and edit the top line from <movie nextFrame="233"> to <movie nextFrame="250"> and save it. If this does not save due to a "access is denied" error, open notepad as an administrator and open the 'collector_movie.xml' file and make the changes.
  2. Open a CMD prompt as an Administrator and got o this directory: <installdir/migrator>.
  3. Type in: RunMigrator.vbs and press enter.