DLP Detection - FileReader fails to start after an upgrade to a Maintenance Pack version

Products

• Data Loss Prevention
• Data Loss Prevention Network Discover

Issue/Introduction

After an upgrade of a DLP detection server or Maintenance Pack (MP) version application, Filereader fails to start.

 

Environment

DLP 15.x

Cause

The Filereader service is unable to lock or create the above folders in order to initialize itself. 

In the FileReader log, you can see the following entries which say that the service was unable to start:

Class: org.hibernate.engine.jdbc.spi.SqlExceptionHelper
Method: logExceptions
Level: SEVERE
Message:  Cannot create PoolableConnectionFactory (DERBY SQL error: ERRORCODE: 40000, SQLSTATE: XJ041, SQLERRMC: Failed to create database 'RemediationResiliencyStorage', see the next exception for details.::SQLSTATE: XBM0A)

Class: com.vontu.messaging.FileReaderSetup
Method: initialize
Level: SEVERE
Message:  (DETECTION.3) Failed to initialize Detection
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in com.vontu.config.jpapersistence.JpaPersistenceSpringConfiguration: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.GenericJDBCException: Unable to open JDBC Connection for DDL execution

OR

Class: org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator
Method: initiateService
Level: WARNING
Message: HHH000342: Could not obtain connection to query metadata : Cannot create PoolableConnectionFactory (DERBY SQL error: ERRORCODE: 40000, SQLSTATE: XJ041, SQLERRMC: Failed to create database 'DiscoverFilterStorage', see the next exception for details.::SQLSTATE: XBM0A)

OR

Level: SEVERE
Message:  (DETECTION.3) Failed to initialize Detection
java.lang.ExceptionInInitializerError.....

....Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (DERBY SQL error: ERRORCODE: 40000, SQLSTATE: XJ041, SQLERRMC: Failed to create database 'CatalogEntryStorage', see the next exception for details.::SQLSTATE: XBM0A)

Resolution

1. Stop the "SymantecDLPDetectionServerService" on the Detection Server
2. Rename the "RemediationResiliencyStorage" or "DiscoverFilterStorage" or "CatalogEntryStorage" to ".bak" in \ProgramData\Symantec\DataLossPrevention\DetectionServer\<version>\scan\catalog\* 
3. Start the "SymantecDLPDetectionServerService" on the Detection Server
4. Check the status of the server in the Enforce Console