Can't delete flow forensics report

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

 

 

Issue/Problem/Symptoms: 

Error deleting flow forensics report:

Error message: "Server Error in '/RA' application"

“Duplicate entry '1' for key 'PRIMARY'”

 

Cause

Reporter engine keeps tracks of deleted flow forensics report in database table, reporter. flowforensicsreport_definitions_deleted. There will be few orphan entries left in this table which is causing the error.

 

Environment

Release: RAIB1H99000-9.3-Network Flow Analysis-Interface Bundle-Hardware
Component:

Resolution

1. Login to NFA Console machine
2. Open command prompt
3. Run the below command

mysql reporter -unetqos -pnetqos -t -e "truncate flowforensicsreport_definitions_deleted"

4. Try deleting the report and it should go good now.

Additional Information

If the problem still persists after running above commands or if you face any additional problems during above commands, please contact CA Support.