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

Last updated on DECEMBER 17, 2019

Applies to:

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 / Linux 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

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