NFA 9.3.8 Flow Forensics fails with error executing flow forensics report on host x.x.x.x

Document ID : KB000097981
Last Modified Date : 24/05/2018
Show Technical Document Details
Issue:
Flow Forensics fails with  error executing flow forensics report on host x.x.x.x on NFA 9.3.8.
Environment:
NFA 9.3.8
Cause:
Corruption of the database on port 3307. 

The \CA\NFA\Netflow\data\oursql*.log file on your Harvesters shows the message below:
INFO - If you want more detailed logging for NFA CSE, please create the log file [E:\CA\NFA\\Netflow\logs\NFAStorageEngine.log] (and on Linux ensure that it is writable by the NFA user)

After creating that log file, then recycling the Netqos NQMysql Service, and running the report again, the problem still occurred and had the log messages like below:
[Warning] System table 'time_zone_name' is expected to be transactional.
[Warning] System table 'time_zone' is expected to be transactional.
[Warning] System table 'time_zone_transition_type' is expected to be transactional.
[Warning] System table 'time_zone_transition' is expected to be transactional.
[Warning] The use of InnoDB is mandatory since MySQL 5.7. The former options like '--innodb=0/1/OFF/ON' or '--skip-innodb' are ignored.
[Warning] The syntax 'avoid_temporal_upgrade' is deprecated and will be removed in a future release
[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

[ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRANSACTION','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
[ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
[ERROR] Column count of performance_schema.setup_actors is wrong. Expected 5, found 3. Created with MySQL 50622, now running 50719. Please use mysql_upgrade to fix this error.

[ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure
[ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure
 
Resolution:
You can recreate the databases that are on port 3307 by following the steps below:

1. Stop the Netqos NQMysql service on your Harvester(s).

2. Rename the \CA\NFA\Netflow\data directory to "orig_data".

3. Download the file below:
       ftp://ftp.ca.com/pub/netqos/product_patches/NFA/9.3.8/3307_data.zip

4. Unzip the file and copy the "data" folder within it to the \CA\NFA\Netflow\ directory.

5. Start the Netqos NQMysql service and run the Flow Forensics report again.