Speed up 3TConverter.ps1 2-Tier Conversion script
Article ID: 10923
Updated On:
Products
Issue/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.
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
Resolution
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:
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
Feedback
