Issue/Problem/Symptoms:
Error deleting flow forensics report:
Error message: "Server Error in '/RA' application"
“Duplicate entry '1' for key 'PRIMARY'”
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.