How to change drive and path of an NFA installation and retain data.
search cancel

How to change drive and path of an NFA installation and retain data.


Article ID: 29426


Updated On:


CA Network Flow Analysis (NetQos / NFA)


How to change drive path of an NFA installation and retain data.





1)Backup the necessary databases and files as per the documentation:
2) Uninstall NFA software via Control Panel->Add/Remove Programs.


3) Delete the hidden folder/file below(Console only):


C:\Program Files\Zero G Registry\.com.zerog.registry.xml


4) Delete any left over folders in the old Path like "C:\NFA"


5) Delete the Registry Key 'HKLM/Software/Wow6432Node/NetQos' if still present.


6) (On Console only) Open IIS and expand Sites->Default site and delete the RA, ProxyServices, ReporterDataSource, and ReporterWebService sites. 

7) Re-install the same version of the appropriate NFA software to the new drive path and restore your database.
8) Stop the "NetQos Mysql" service from Windows Services.
9) Restore the backup's you made in step 1 following the steps from the documentation:
 10) There will be several database changes needed to update the correct path as documented below.
The example queries below for each server assume you were moving the installation directory from "C:\NFA" to "D:\NFA":
On the NFA Console Server:
Open a command prompt and login to the 'reporter' database:
mysql -P3308 reporter -unetqos -pnetqos
The run the queries below for each table.
For the 'parameter_descriptions' table:
update parameter_descriptions set defaultvalue='D:/CA/NFA/Reporter/datashare' where parameter='datasharepath';
update  parameter_descriptions set defaultvalue='D:/CA/NFA/reporter/web' where parameter='csvRoot';
update parameter_descriptions set defaultvalue='D:/CA/NFA/tzinfo' where parameter='tzinfodir';
update parameter_descriptions set defaultvalue='D:/CA/NFA/reporter/web' where parameter='webroot';
For the 'system_settings' table:

update system_settings set value='D:/CA/NFA/Reporter/datashare'
 where parameter='datasharepath';
update system_settings set value='D:/CA/NFA/' where parameter='nqhome';
update system_settings set value='D:/CA/NFA/reporter/web' where parameter='csvRoot';
update system_settings set value='D:/CA/NFA/tzinfo' where parameter='tzinfodir';
update system_settings set value='D:/CA/NFA/reporter/NetQoS.ReporterAnalyzer.WebSite/web' where parameter='webroot';

For the 'general' table:
update general set value='D:/CA/NFA/Reporter/xsl/email' where attribute='emailtemplatepath';
On the NFA Harvester:
Login to the Harvester database with the command:
mysql -P3308 harvester -unetqos -pnetqos
The run the queries below for each table.
For the 'parameter_descriptions' table:
update parameter_descriptions set defaultvalue='D:/CA/NFA/Netflow' where parameter='harvesterInstallRoot';
update parameter_descriptions set defaultvalue='D:/CA/NFA/tzinfo' where parameter='tzInfoDir';
update parameter_descriptions set defaultvalue='D:/CA/NFA//Netflow//Logs//RealTimeReaperErrors%04d-%02d-%02d.log' where parameter='RealtimeReaper_ErrorLogFile';

For the 'extended_parameters_values' table:

update extended_parameters_values set value='D:/CA/NFA//Netflow//Logs//RealtimeReaperErrors%04d-%02d-%02d.log' where id='97';

update extended_parameters_values set value='D:/CA/NFA//Netflow//Logs//RealtimeReaperExceptions%04d-%02d-%02d.log' where id='114';

update extended_parameters_values set value='D:/CA/NFA//Netflow//Logs//StorageEngineErrors%04d-%02d-%02d.log' where id='127';

For the 'data_retention.settings' table:

use data_retention;

update settings set value='D:/CA/NFA/Netflow' where name='installRoot';


11) Start All "CA NFA *" and "Netqos *" services and make sure all start up.

**If one of the services fail to start up, verify all of the SQL statements above completed without error, and check the Log file for the service that will not start**