Unable to save an incident filter report. Error: Unexpected server error occurred. Please refer to log for details.

Products

• Data Loss Prevention

Issue/Introduction

You created an incident filter report and when you save it, you are getting the error: "Unexpected server error occurred. Please refer to log for details."

In the Localhost log, you will see the error:

File: Enforce\logs\tomcat\localhost.2024-01-03.log
Date: 1/3/2024 7:26:37 AM
Thread: 121
Level: ERROR
Source: org.hibernate.engine.jdbc.spi.SqlExceptionHelper
Message: ORA-00001: unique constraint (PROTECT.REPORTFILTER_PK) violated

And, in the manager_jdbc log, you will see the below error:

File: Enforce\logs\debug\manager_jdbc_0.log
Date: 1/3/2024 7:19:21 AM
Level: SEVERE
Thread: 17
Session: 1
EventType: Failed
Id: 74
Caller: com.vontu.manager.spring.ManagerContextLoaderListener.configureAndRefreshWebApplicationContext(48), query failed: ORA-00955: name is already used by an existing object
Time: 
Message: 
    create global temporary table HT_DocSource (infoSourceId number(19,0) not null) 
        on commit delete rows;

Environment

Symantec Data Loss Prevention 16.0.x

Resolution

When creating an incident filter report, always use a name not used before with another report before saving.