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'”

FF.png

Environment:  

Windows 2008 R2 and 2012 R2

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.

Resolution/Workaround:

1.   Login to NFA Console machine

2.   Open command prompt

3.   Run the below command

mysql reporter -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.

Environment

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