When I attempt to upgrade NFA, it detects NFA on the wrong drive or directory.

Document ID : KB000073531
Last Modified Date : 22/05/2018
Show Technical Document Details
Issue:
When I attempt to upgrade NFA, it detects NFA on the wrong drive or directory.
Environment:
NFA all versions
Cause:
If you have migrated NFA from another server and it was installed on a different drive or directory and did not update the database to reflect the new drive or directory structure this problem can happen.  It can also happen if you originally installed NFA on one drive, then reinstalled on another drive. 
Resolution:
The steps below will resolve this issue:

1. Check the drive/directory mentioned during the upgrade for a :\Netqos\ or \CA\NFA\ folder, if it is on the wrong drive, delete it.

2. Open regedit and go to HKLM/Software/Wow6432Node/NetQos and make sure RAInstallDir and SSOInstallDir are both set to the correct drive and path.

3. Update the databases to the new drive and directory path.
On the NFA Console Server:
 Open a command prompt and login to the 'reporter' database:
mysql -P3308 reporter
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/tzinfo' where parameter='tzinfodir';
 
 
update parameter_descriptions set defaultvalue='D:/CA/NFA/reporter/web' where parameter='webroot';
 
update system_settings set value='D:/CA/NFA/Reporter/datashare' where parameter='datasharepath';
 
 
For the 'system_settings' table:
update system_settings set value='D:/CA/NFA/' where parameter='nqhome';
 
 
update system_settings set value='D:/CA/NFA/tzinfo' where parameter='tzinfodir';
 
 
update system_settings set value='D:/CA/NFA/reporter/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
 
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/tzinfo' where parameter='RealtimeReaper_ErrorLogFile';
For the 'extended_parameter_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';
 
If you migrated the Data Retention database which is optional:
Login to mysql on the Harvester servers with:
​mysql data_retention

Run the following update statement to update your installation directory:
update settings set value='D:/CA/NFA/Netflow" where name='installRoot';

For Older systems that still have a DSA server:
 
Login to the 'nqrptr' database with the command below:
mysql -P3308 nqrptr

Then update the 'settings' table with the queires below: 
update settings set value='D:/CA/NFA' where name='installRoot';

update settings set value='D:/CA/NFA/Netflow/logs/dsaLoaderErrors-%04d-%02d-%02d.log' where name'logFile';