MysqlCSE Crashing causing reports to fail

book

Article ID: 210095

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

We are seeing our MysqlCSE crash on one or more harvesters.

We are also seeing Flow Forensics / Analysis reports failing to complete

Cause

Corrupt data in the /CA/NFA/Netflow/datafiles/HarvsterArchive folder

Environment

Release : 20.2

Component : NQRPTA - REPORTERANALYZER

Resolution

The root cause of the issue is corrupt data / invalid fields being sent from devices/routers to NFA. This is stored for a short time in the HarvesterArchive folder where it will be used for Flow Forensics reports. Bad data will cause the FF reports to crash the MysqlCSE service and cause some/all reports to fail

 

Purge all .nfa files in the HarvesterArchive directory. Monitor for functioning reports.

 

If issue persists, contact Broadcom support.