NFA 9.5.0 Harvester Migrator Failure: Frame 233

Document ID : KB000117604
Last Modified Date : 16/10/2018
Show Technical Document Details
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 Movie playback failed.
    at Source)
    at Source)
    at Source)
    at Source)
Caused by: SQL action failed
    at Source)
    ... 4 more
Caused by: java.sql.SQLException: Function 'v6_type' already exists
    at com.mysql.jdbc.SQLError.createSQLException(
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(
    at com.mysql.jdbc.MysqlIO.sendCommand(
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
    at com.mysql.jdbc.ConnectionImpl.execSQL(
    at com.mysql.jdbc.PreparedStatement.executeInternal(
    at com.mysql.jdbc.PreparedStatement.execute(
    at 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 
  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.