"ODI-1590: The execution of the script failed" Encountered Loading a Flat File Using LKM File to Oracle (SQLLDR) (Doc ID 2502814.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

When using Oracle Data Integrator (ODI) to load a Flat File into an Oracle table using the loading knowledge module LKM File to Oracle (SQLLDR), the following error occurs.

ODI-1298: Serial task "<SERIAL_TASK_NAME>" failed because child task "<CHILD_TASK_NAME>" 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 "", line 18, in
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:163)

And while trying to launch SQLLDR from the machine where ODI Agent is installed, following Segmentation fault error is encountered.

$ sqlldr
Segmentation fault

Changes

Cause

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