search cancel

Known Issue: SQLPreindexer issue with Data Loss Prevention 15.1 and above.

book

Article ID: 175344

calendar_today

Updated On:

Products

Data Loss Prevention Enforce Data Loss Prevention Network Discover

Issue/Introduction

When using SqlPreindexer of Symantec Data Loss Prevention (DLP) 15.1 and above to remotely index oracle Database, following exception is shown in verbose output. 

SqlPreindexer [email protected]//xxx.xxx.xxx.xxx:1521/protect -username=protect -
password=xxxxxxx -query="select policyid, version from policy" -verbose | 
remoteEDmIndexer -profile=C:\customerdata.edm -result=C:\ -verbose

Unable to perform query
oracle/jdbc/pool/OracleDataSource
java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource
        at java.lang.ClassLoader.defineClass1(Native Method)
        at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
        at 
java.security.SecureClassLoader.defineClass(SecureClassLoader.java:14
2)
        at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)
        at java.net.URLClassLoader.access$100(URLClassLoader.java:73)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:368)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:362)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:361)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        at 
com.vontu.util.jdbc.DatabaseConnectionFactory.createConnection(Databa
seConnectionFactory.java:57)
        at 
com.vontu.externalindexer.sql.SqlPreindexFormatter.connect(SqlPreinde
xFormatter.java:47)
        at 
com.vontu.externalindexer.sql.SqlPreindexUtility.run(SqlPreindexUtili
ty.java:87)
        at 
com.vontu.externalindexer.sql.SqlPreindexUtility.main(SqlPreindexUtil
ity.java:306)
Caused by: java.lang.ClassNotFoundException: 
oracle.jdbc.pool.OracleDataSource
        at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        ... 16 more

Environment

Data Loss Prevention (DLP) 15.1 and above.

Resolution

Symantec Corporation is committed to product quality and satisfied customers.  This issue is currently being considered by Symantec Corporation to be addressed in a Future Release of the product.  Please be sure to subscribe to this document as any changes to the status of the issue will be reflected here. Following Workaround can be used to resolve this issue. 

  • Copy ojdbc7-12.1.0.2.0.jar from C:\Program Files\Symantec\DataLossPrevention\Server Platform Common\15.5\Protect\lib\jar to C:\Program Files\Symantec\DataLossPrevention\Indexers\15.5\Protect\lib\jar
  • Rename ojdbc7-12.1.0.2.0.jar to ojdbc7.jar
  • re-run the tool which should now be able to connect to oracle DB and create the indexes.