My Oracle Support Banner

"Java.lang.NullPointerException During Extract Data" Signalled from LKM SAP ERP to Oracle (SQLLDR) when Using an ODI J2EE Agent (Doc ID 2194491.1)

Last updated on SEPTEMBER 11, 2018

Applies to:

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

Symptoms

The LKM SAP ERP to Oracle (SQLLDR) is used for extracting data from the SAP system.

The sapjco3.jar and libsapjco3.so were copied to the <ODI_HOME>/sdk/lib and to the <DOMAIN_HOME>/lib directories.

In ODI 12.2.1.1, when executing a Mapping with the Collocated Agent everything is fine.

With the J2EE-Agent the execution throws the following exception:
 

ODI-1217: Session SESSION_NAME (56308) fails with return code ODI-1298.
ODI-1226: Step RUN_STEP fails after 1 attempt(s).
ODI-1227: Task SERIAL-MAP_MAIN- fails on the source connection .
ODI-1298: Serial task "SERIAL-MAP_MAIN- (40)" failed because child task "SERIAL-CHILD_TASK (50)" is in error.
ODI-1298: Serial task "SERIAL-CHILD_TASK (50)" failed because child task "Extract Data-LKM SAP ERP to Oracle (SQLLDR) ****- (170)" is in error.
Caused By: java.lang.NullPointerException
at oracle.odi.sap.km._OdiSapAbapExecute.execute(_OdiSapAbapExecute.java:964)
at com.sunopsis.dwg.function.SnpsOpenToolFunction.actionExecute(SnpsOpenToolFunction.java:47)
at com.sunopsis.dwg.function.SnpsOpenToolFunction.execute(SnpsOpenToolFunction.java:148)
at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:902)
at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:583)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:18)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)
at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2231)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:612)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:719)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:801)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)




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


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