Last updated on JUNE 09, 2016
Applies to:Oracle Data Integrator - Version 184.108.40.206.0 to 220.127.116.11.99 [Release 11gR1]
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms