Unknown Error (9999) in Sourcefire IPS

[hmisc]

Hello,

I have Sourcefire Defense Center 750 (5.2.0.2), however facing the following error: Unknown Error (9999): Unable to execute INSERT INTO 'xxxx' SELECT * FROM 'firewall_policy_ip_rep'. Attached the screenshot.

It is triggered when I go to Policies > Access Control.

[Bogdan Nita]

I think you will need to contact TAC in order to solve this.
Error seems to indicate that the database table got partially corrupt and must be repaired.
I found the CSCvi61649 bug, that states that this could happen by power down of device while optimize process is running.

HTH

Bogdan