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

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

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)

Environment

Release: RAIB1H99000-9.3-Network Flow Analysis-Interface Bundle-Hardware
Component:

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.

**You should also give the <C:\Users\<username>\AppData\Local\Temp> directory Everyone (full privlegdes).**

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" 

4. Run the following command:
 
                mysql_upgrade -P3308 -u root

5.  Ensure that the command succeeds.

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

7. Check the \CA\NFA\migrator\migrator.log file to ensure that the script finished with exit code 0 and the version of NFA is updated.