My Oracle Support Banner

'Invalid argument for username/password' when Calling SQL*Loader Based Knowledge Modules in ODI Integration Interfaces (Doc ID 429772.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version to [Release 10gR3 to 11gR1]
Information in this document applies to any platform.
***   ***


When launching ODI Integration Interfaces that call SQL*Loader to populate Oracle tables from a flat file, the following message is displayed : 

error: SQL*Loader-101: Invalid argument for username/password

 In Operator, the Integration Interface fails on the "call SQLLDR via Jython" step with the message :

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

at org.apache.bsf.engines.jython.JythonEngine.exec(Unknown Source)
at com.sunopsis.dwg.codeinterpretor.k.a(
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(

This does not reflect the true error which is found in the <file_datastoreName>.log file.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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