ODI 12c Mapping Execution Error "oracle.odi.km.exception.OdiKMException: oracle.odi.km.exception.OdiKMException: ODIKM-STDKM-10012: Load Error"

(Doc ID 2364714.1)

Last updated on MARCH 02, 2018

Applies to:

Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator - Version 12.2.1.0.0 and later
Data Integration Platform Cloud - Version 17.3.5 and later
Information in this document applies to any platform.

Symptoms

After upgrading Oracle Data Integrator (ODI), on premise Version example: upgrade from 12.2.1.0.0 to ODI 12.2.1.2.6, a mapping that was running without any issues previously now throws the exception below:

[2018-01-23T13:34:34.528-05:00] [ODI_server1] [ERROR] [ODI-1217] [oracle.odi.agent] [tid: 78201] [userId: <anonymous>] [ecid: 0000xxxxxxxxxxxxxxxxxxxxxxxxx00001,0:3848:200:28] [APP: oraclediagent] [partition-name: DOMAIN] [tenant-name: GLOBAL] [oracle.odi.runtime.MrepExtId: 1#########9] [oracle.odi.runtime.AgentName: OracleDIAgent] [oracle.odi.runtime.ExecPhase: ExecuteTask] [oracle.odi.runtime.OdiUser: ODI_User] [oracle.odi.runtime.WrepName: WORKREPD] [oracle.odi.runtime.ScenarioName: NAME_LOAD_DATA] [oracle.odi.runtime.ScenarioVer: 001] [oracle.odi.runtime.EntityGuid: 8##x##x#-x75x-x6x#-xx2x-05993x#88exx] [oracle.odi.runtime.SessName: NAME_LOAD_DATA] [oracle.odi.runtime.SessId: 1328] [oracle.odi.runtime.SessStep: 19/Load NAME 2018-19 Duplicates 2/1] [oracle.odi.runtime.SessTask: 19.110/Call sqlldr,LKM File to Oracle (SQLLDR),null] [oracle.odi.runtime.ExecHierarchy: 1328] Session NAME_LOAD_DATA (1328) fails with return code ODI-1298.[[
ODI-1217: Session NAME_LOAD_DATA (1328) fails with return code ODI-1298.
ODI-1226: Step Load NAME 2018-19 Duplicates 2 fails after 1 attempt(s).
ODI-1227: Task SERIAL-MAP_MAIN- fails on the source connection <Empty Value>.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (40)" failed because child task "SERIAL-EU-NAME_Raw_Files_UNIT (50)" is in error.
ODI-1298: Serial task "SERIAL-EU-NAME_Raw_Files_UNIT (50)" failed because child task "Call sqlldr-LKM File to Oracle (SQLLDR)- (110)" is in error.
ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 18, in <module>
  at sun.reflect.GeneratedConstructorAccessor3087.newInstance(Unknown Source)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:163)
oracle.odi.km.exception.OdiKMException: oracle.odi.km.exception.OdiKMException: ODIKM-STDKM-10012: Load Error: See /tmp/XXXXXXXX.log and /tmp/XXXXXXX.out for details
  at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:396)
  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:247)
  at oracle.odi.runtime.agent.execution.interpreter.SessionTaskScriptingInterpretor.scripting(SessionTaskScriptingInterpretor.java:190)
  at oracle.odi.runtime.agent.execution.SessionTask.scripting(SessionTask.java:105)
  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:49)
  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:21)
  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)
  ...
Caused by: Traceback (most recent call last):
File "<string>", line 18, in <module>
  at sun.reflect.GeneratedConstructorAccessor3087.newInstance(Unknown Source)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:163)

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms