Error executing Flow Forensics report on host

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

After NFA upgrade the FF stop to work and send the messages:
Error executing Flow Forensics report on host

ReportService::Report Service:
NetQoS.ReporterAnalyzer.i18n.i18nException: Error executing Flow Forensics report on host x.x.x.x.

Authentication to host 'x.x.x.x' for user 'archive' using method 'mysql_native_password' failed with message: Access denied for user 'archive'@'%' to database '<dbName>'
MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host 'x.x.x.x' for user 'archive' using method 'mysql_native_password' failed with message: Access denied for user 'archive'@'%' to database '<dbName>' ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Access denied for user 'archive'@'%' to database '<dbName>'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
 

Environment

9.3

Cause

Upgrade lost the user 'archive' permission on 'nsas' database

Resolution

1) logon on Harvester machine

2) Stop all NFA Services

3) Have access to the "nsas" database in MySQL, run the following commands on the harvester Command Prompt:
mysql -u root mysql -P3307
grant all on <dbName>.* to 'archive'@'%';
exit;

4) Start all NFA Services