My Oracle Support Banner

After having Applied ODI 12.2.1.4.200618 Bundle Patch a "java.lang.NullPointerException" Message is Received when Executing a Mapping that Loads Data from / to File Datastore (Doc ID 2693573.1)

Last updated on JULY 22, 2020

Applies to:

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

Symptoms

An Oracle Data Integrator (ODI) 12.2.1.4 Mapping that reads data from a source FILE Datastore (or loads data into a target FILE Datastore) can be successfully executed.

After having applied the 12.2.1.4.200618 bundle patch on the ODI home, the execution of same Mapping fails, and the following error is received:

java.lang.NullPointerException
  at com.sunopsis.jdbc.driver.file.FileStatement.close(FileStatement.java:44)
  at com.sunopsis.sql.SnpsConnection.isClosed(SnpsConnection.java:1122)
  at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java:633)
  at oracle.odi.runtime.agent.execution.SessionExecutor.changeIsolationLevel(SessionExecutor.java:1076)
  at oracle.odi.runtime.agent.execution.AbstractSessionTask.createSrcTargetConnectionsInFixedOrder(AbstractSessionTask.java:1777)
  at oracle.odi.runtime.agent.execution.AbstractSessionTask.getCollectDwgConnectConnection(AbstractSessionTask.java:781)
  at oracle.odi.runtime.agent.execution.AbstractSessionTask.getCollectDwgConnectConnection(AbstractSessionTask.java:752)
  at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:158)
  at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:129)
  at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
  at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2224)
  at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)

 

Such error is not received when using an ODI on Marketplace 12.2.1.4.200618 instance.

For reproducing the issue, one must have patched a previous ODI on Marketplace instance, or on-premise installation.

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
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.