CSV lookup plugins failing after upgrade to 25.1: No suitable driver found

Products

• Data Loss Prevention Core Package

Issue/Introduction

After upgrading to 25.1 the following error is returned when lookup plugins are executed.

 

Thread: 35 SEVERE [com.symantec.dlp.incidentdomainservices.workflow.attributes.AttributeLookupLoader] Error loading plugin [Custom Attributes]

Cause:

java.lang.reflect.InvocationTargetExceptionjava.lang.reflect.InvocationTargetException

        at java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(Unknown Source)

        at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Unknown Source)

 

Caused by: java.sql.SQLException: No suitable driver found for jdbc:derby:CSV_LOOKUP_DATABASE; create=true

        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)

        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)

        at com.vontu.lookup.csv.DerbyConnector.createDatabase(DerbyConnector.java:130)

 

java.sql.SQLException: No suitable driver found for jdbc:derby:CSV_LOOKUP_DATABASE; create=truejava.sql.SQLException: No suitable driver found for jdbc:derby:CSV_LOOKUP_DATABASE; create=true

        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)

        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)

        at com.vontu.lookup.csv.DerbyConnector.createDatabase(DerbyConnector.java:130)

Environment

rhel 8.x 

upgraded from 16.x to 25.1 

Cause

When the install of 25.1 was executed some of the beta rpms was in the same directory. This caused some of the rpms to install the wrong versions 

Resolution

uninstall all DLP 25.1 rpms 

rpm -e $(rpm -qa | grep symantec*)

delete any beta RPMs from the file system. 

reinstall DLP using the reinstallation resources