My Oracle Support Banner

ODI 12c Receives Intermittent "Could not load JDBC driver class" Error During Executions (Doc ID 2541193.1)

Last updated on APRIL 14, 2021

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 and later
Information in this document applies to any platform.

Symptoms

Executions of Oracle Data Integrator (ODI) 12c objects fail intermittently, and the following error message is received:

...
Caused By: java.sql.SQLException: ODI-40757: An exception occurred while reading the file
  at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.readDocument(SnpsXmlFile.java:540)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.synchronizeFromFile(SnpsXmlFile.java:705)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.(SnpsXmlFile.java:125)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlSchema.(SnpsXmlSchema.java:530)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.createNewSchema(SnpsXmlSchemaManager.java:316)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.getSchemaFromProperties(SnpsXmlSchemaManager.java:293)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlDriver.connect(SnpsXmlDriver.java:142)
  at oracle.odi.jdbc.driver.file.complex.ComplexFileDriver.connect(ComplexFileDriver.java:82)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:412)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:385)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:352)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:331)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:110)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
  at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87)
  at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
  at com.sunopsis.sql.SnpsConnection.createConnection(SnpsConnection.java:530)

At the same time, the following could be found in the ODI Agent log file:

[oracle.odi.runtime.ExecHierarchy: <SESSIONID>] Unexpected error while configuring DataSource[[java.lang.IllegalArgumentException: Could not load JDBC driver class [oracle.odi.jdbc.driver.file.complex.ComplexFileDriver]

Note that the error may also happen with the FileDriver class.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.