Cannot add another Detection Server in System Administration

book

Article ID: 160715

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

After upgrading to V. 10, trying to add another detection server in System Overview results in a RSOD.

Error:   in the tomcat logs:

Caused by: org.apache.ojb.odmg.TransactionAbortedExceptionOJB: Can't commit objects:
* SQLException during execution of sql-statement:
* sql statement was 'INSERT INTO FileFilterFilePath (fileFilterFilePathID,fileFilterID,filePath) VALUES (?,?,?) '
* Exception message is [ORA-00001: unique constraint (PROTECT.FILEFILTERFILEPATH_PK) violated
]
* Vendor error code [1]
* SQL state code [23000=INTEGRITY CONSTRAINT VIOLATION]
* Target class is 'com.vontu.model.data.ojb.FileFilterFilePathImpl'
* PK of the target object is [fileFilterFilePathIDRef=371]
* Source object: fileFilterFilePathID: 371, fileFilterID: 185, fileFilter: fileFilterID: 185, endpointChannelID: 315, endpointChannel: aggregatorPort: 8000, aggregatorHost: 0.0.0.0, protocolFilterID: null, protocolFilter: null, , filterAction: Ignore, filterOrder: 1, checkFileSize: 0, fileSizeBytes: 512000, fileSizeOperator: GT, checkFilePath: 1, checkFileType: 0, , filePath: $RoamingAppData$\*,
 at org.apache.ojb.odmg.TransactionImpl.commit(TransactionImpl.java:719)
 at com.vontu.model.ojb.OJBSystem.commitTransaction(OJBSystem.java:327)

Resolution

This is a known issue with the V. 10 Instatller/Upgrader, etrack  1945954.

Please Apply Hotfix_10.0.0.18003 or the latest hotfix for 10.