'org.apache.bsf.BSFException: exception from Jython' Signalled When Executing SQL*Loader or Other Oracle Client Programs with ODI 11g Agent Configured With OPMN (Doc ID 1518438.1)

Last updated on JUNE 09, 2016

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 to 11.1.1.9.99 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

When executing ODI 11g Scenario/Interface with a Standalone Agent setup as an OPMN service which implements a bulk load operating calling Oracle SQL*Loader from one of the LKMs available like LKM File to Oracle (SQLLDR), or LKM SAP ERP to Oracle (SQLLDR) it fails at the step that calls sqlldr with the following message (note that the line 22 below may differ depending on what LKM is in use, the SAP one will show line 14): 

where SourceFile.txt is the name of the text file being loaded, and its corresponding SourceFile.log is the log generated, if any; most likely the log file will NOT be generated.

When the same bulk load Scenario is executed from ODI using the same Standalone Agent but started manually outside OPMN, it runs correctly (as long as the environment ORACLE_HOME is setup in the system).

The same behavior can be seen when trying to execute any Oracle program (like SQL*Plus) from ODI using an Agent deployed as a Service via OPMN.

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