My Oracle Support Banner

When Value of Method odiRef.getOption("<VALUE>") Is Set to Exactly "true" or "false" the Non-Boolean KM Option is Substituted to '1' or '0' (Doc ID 2493591.1)

Last updated on MAY 18, 2020

Applies to:

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

Symptoms

In Oracle Data Integrator (ODI) 12c, when the value of the method odiRef.getOption("<VALUE>") is set to "true" or "false", the non-boolean KM option is substituted to '1' or '0', respectively.

It is expected that a non-Boolean KM option must return the exact value for which it has been set.

For example, in the "LKM File to Oracle (SQLLDR)", if the LOAD_DIRECT option is set to "true", the control file (ex. C_0DEFAULT.ctl) shows "DIRECT=1" instead of "DIRECT=true".

This results in the following 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 29, in <MODULE> sqlldr '<SRCUSER1>/<PASSWORD>' control='E:\work\122131_filekm/C_0DEFAULT.ctl' log='E:\work\122131_filekm/C_0DEFAULT.log' produced error. See E:\work\122131_filekm/C_0DEFAULT.log and E:\work\122131_filekm/C_0DEFAULT.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 '<SRCUSER1>/<PASSWORD>' control='E:\work\122131_filekm/C_0DEFAULT.ctl' log='E:\work\122131_filekm/C_0DEFAULT.log'
produced error. See E:\work\122131_filekm/C_0DEFAULT.log and E:\work\122131_filekm/C_0DEFAULT.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:115)
  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:216)
  at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:127)
  ...
Caused by: Traceback (most recent call last):
File "<STRING>", line 29, in <MODULE> sqlldr '<SRCUSER1>/<PASSWORD>' control='E:\work\122131_filekm/C_0DEFAULT.ctl' log='E:\work\122131_filekm/C_0DEFAULT.log' produced error. See E:\work\122131_filekm/C_0DEFAULT.log and E:\work\122131_filekm/C_0DEFAULT.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 '<SRCUSER1>/<PASSWORD>' control='E:\work\122131_filekm/C_0DEFAULT.ctl' log='E:\work\122131_filekm/C_0DEFAULT.log' produced error. See E:\work\122131_filekm/C_0DEFAULT.log and E:\work\122131_filekm/C_0DEFAULT.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)
  at org.python.core.Py.makeException(Py.java:1174)
  at org.python.pycode._pyx0.f$0(<string>:64)
  at org.python.pycode._pyx0.call_function(<string>)
  at org.python.core.PyTableCode.call(PyTableCode.java:165)
  at org.python.core.PyCode.call(PyCode.java:18)
  at org.python.core.Py.runCode(Py.java:1204)
  at org.python.core.Py.exec(Py.java:1248)
  at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)
  at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)
... 21 more

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.