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

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

book

Article ID: 97981

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

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:
       https://ftp.broadcom.com/user/downloads/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.