Incident deletion fails with no errors

Products

• Data Loss Prevention
• Data Loss Prevention Enforce
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

Incident deletion fails with no errors presented.

If you look within the oracle alert log you see: ORA-08102: index key not found, obj#, file, block ()

Cause

• No errors present in tomcat logs or within the console. 
  INFO [com.vontu.manager] Incident deletion started. Incident deletion started

INFO [com.vontu.manager] Incident deletion failed. Incident deletion failed
• ORA-08102 is present in the oracle alert log. 
  • ORA-08102 is an indicator that the index for a table, such as MESSAGECOMPONENT,  is non-functional.

Resolution

• If you have Oracle Standard Edition contact Broadcom support for assistance. 
• If you have Oracle Enterprise Edition contact Oracle Enterprise support for assistance. 
  
  The index and/or entire table may need to be rebuilt.