ODI Mappings / Integration Interfaces Using "LKM File to Oracle (SQLLDR)" Execution Fails On Unix (Doc ID 424112.1)

Last updated on MARCH 22, 2017

Applies to:

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

Symptoms

An Oracle Data Integrator (ODI) 12c Mapping / 11g Integration Interface loading a file into an Oracle table using SQL*Loader fails when executed on Unix systems and following message is signaled:

org.apache.bsf.BSFException: exception from Jython: Traceback (innermost last):
File "", line 3, in ?
OS command has signalled errors

  at org.apache.bsf.engines.jython.JythonEngine.exec(Unknown Source)
  at com.sunopsis.dwg.codeinterpretor.k.a(k.java)
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java)
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(SnpSessTaskSql.java)
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(SnpSessTaskSql.java)
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
  at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(SnpSessTaskSqlC.java)
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
  at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
  at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
  at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.java)
  at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
  at com.sunopsis.dwg.cmd.e.i(e.java)
  at com.sunopsis.dwg.cmd.h.y(h.java)
  at com.sunopsis.dwg.cmd.e.run(e.java)
  at java.lang.Thread.run(Thread.java:534)

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