Speed up 3TConverter.ps1 2-Tier Conversion script

Document ID : KB000010923
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Running the 3TConverter.ps1 script to convert an existing 3-Tier NFA environment to 2-Tier in preparation for an NFA upgrade. If the existing 3-Tier environment has existed for several years prior to the upgrade attempt, there may be a large number of empty subdirectories left behind in the ReaperArchive15 directory on the DSA machine. These can potentially slow down the amount of time that it takes for the conversion script to begin the process of migrating files from the DSA to the Harvester.

Background:

The "CA NFA Data Retention" service on the DSA machine deletes the 15-minute resolution data files that are older than one year. However, after the files are deleted the empty subdirectories that contained the files are not removed. After the DSA runs for several years, the ReaperArchive15 directory may end up containing a large number of empty subdirectories.

Environment:
NFA 9.3.3 / 9.3.6 / 9.3.7 Windows Server 2008 /2012
Instructions:

We can sometimes speed up the 3TConverter.ps1 script by removing the empty subdirectories from the ReaperArchive15 directory on the DSA machine. One way to do this is to use Powershell commands. For example:

(Note: Since this is a "delete" command, we would strongly recommend making sure the DSA's ReaperArchive15 folder is backed up before proceeding.)

The command must be run in a powershell window. Be sure to cd to the parent directory containing the empty directories you want to delete on the DSA:

<install_path>\Netflow\datafiles\ReaperArchive15

 

Make sure Powershell 3.0 or 4.0 is installed. If you need to upgrade the Powershell version, you should also install the appropriate MySQL connector for Powershell 3.0+:

https://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-6.9.9.msi

The following powershell command will remove empty directories in the working directory: 

dir -Directory -Recurse | where {($_ | dir).Count -eq 0} | rmdir 

 

Then, proceed with the 3TConverter.ps1 script as described in the NFA documentation:

https://docops.ca.com/ca-network-flow-analysis/9-3-3/en/upgrading/upgrade-ca-network-flow-analysis/converting-from-a-three-tier-to-a-two-tier-architecture

 

 

Additional Information:

See also the following Tech Docs for other issues with the 3TConverter.ps1 script:

NFA 3 to 2-Tier Migration will not execute

NFA 3 to 2-Tier Migration fails with lack of resources error