Error deleting flow forensics report:
Error message: "Server Error in '/RA' application"
“Duplicate entry '1' for key 'PRIMARY'”
Windows 2008 R2 and 2012 R2
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.
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.
If the problem still persists after running above commands or if you face any additional problems during above commands, please contact CA Support.