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 10.1.3.2.0 to 11.1.1.9.99 [Release 10gR3 to 11gR1]
Information in this document applies to any platform.
***   ***

Symptoms

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(k.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(SnpSessTaskSql.java)

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

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