My Oracle Support Banner

"ODIKM-STDKM-10012: Load command sqlldr ... produced error" and "sqlldr: command not found" Using ODI LKM File to Oracle (SQLLDR) (Doc ID 2502037.1)

Last updated on OCTOBER 17, 2019

Applies to:

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

Symptoms

When extracting data from a file to a table using the LKM File to Oracle (SQLLDR) knowledge module, the following error occurs:

ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
 File "", line 29, in sqlldr \'<USER>/<PASSWORD>@<SERVICE_NAME>\' control=\'<CONTROL_FILE>.ctl\' log=\'<CONTROL_FILE>.log\' produced error. See <CONTROL_FILE>.log and <CONTROL_FILE>.out for details
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  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 command sqlldr \'<USER>/<PASSWORD>@<SERVICE_NAME>\' control=\'<CONTROL_FILE>.ctl\' log=\'<CONTROL_FILE>.log\' produced error. See <CONTROL_FILE>.log and <CONTROL_FILE>.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)
  ...
Caused by: Traceback (most recent call last):
 File "", line 29, in sqlldr \'<USER>/<PASSWORD>@<SERVICE_NAME>\' control=\'<CONTROL_FILE>.ctl\' log=\'<CONTROL_FILE>.log\' produced error. See <CONTROL_FILE>.log and <CONTROL_FILE>.out for details
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  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 command sqlldr \'<USER>/<PASSWORD>@<SERVICE_NAME>\' control=\'<CONTROL_FILE>.ctl\' log=\'<CONTROL_FILE>.log\' produced error. See <CONTROL_FILE>.log and <CONTROL_FILE>.out for details
  at org.python.core.PyException.doRaise(PyException.java:219)
  at org.python.core.Py.makeException(Py.java:1166)
  at org.python.core.Py.makeException(Py.java:1170)
  ...

There may be a sqlldr output that contains the following:

/bin/sh: sqlldr: command not found

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
 Unix / Linux Operating System
 Windows Operating System
References


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