My NFA upgrade fails due to migrator failure with error like (Errcode: 13 - Permission denied)

Document ID : KB000073545
Last Modified Date : 15/03/2018
Show Technical Document Details
Issue:
When running the Upgrade, you may see a Migrator failure, which indicates the database schema failed to fully update.
You may also see this issue when trying to work around a migrator failure and running the RunMigrator.vbs manually.

By checking the \CA\NFA\Migrator\logs\Migrator.log file shows an error like below:
INFO Projector::play() - Frame #36: [SqlAction database=harvester port=3308 sql='alter table trap_definitions add column TimeFilterStart_new int unsigned not null'] 2018/03/14 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: Error on rename of '.\harvester\#sql-624_2b.frm' to '.\harvester\trap_definitions.frm' (Errcode: 13 - Permission denied)
Cause:
This is likely caused by permission errors or anti-virus software.
Resolution:
1. If possible shut down antivirus while the upgrade is running or at least ensure the full \CA\NFA directory is excluded from any anti virus scan.

2. Ensure the user you are logged in with has full control over all \CA\NFA directories and sub directories.

3. Launch a CMD prompt with "Run as Administrator" 
User-added image

4. Change directory to the \CA\NFA\Migrator directory and run "runMigrator.vbs"