java.lang.NullPointerException is Received When Using The Secure FTP Palette of ODI Commands Without a Password (Doc ID 1959259.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

A NullPointerException is received when using any of the Oracle Data Integrator (ODI) secure FTP commands below without a password:

• OdiSftp
• OdiSftpGet
• OdiSftpPut
• OdiScpGet
• OdiScpPut

java.lang.NullPointerException
    at com.sunopsis.dwg.DwgObject.snpsDecode(DwgObject.java:4718)
    at com.sunopsis.dwg.DwgObject.snpsDecypher(DwgObject.java:4699)
    at com.sunopsis.dwg.tools.filecopy.RemoteFileCopy.getClearPassword(RemoteFileCopy.java:122)
    at com.sunopsis.dwg.tools.SftpPut.actionExecute(SftpPut.java:49)
    at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:209)
    at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:870)
    at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:551)
    at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)
    at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:18)
    at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
    at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:189)
    at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:111)
    at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:864)
    at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2024)
    at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:562)
    at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
    at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
    at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
    at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
    at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
    at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
    at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
    at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
    at java.lang.Thread.run(Thread.java:745)

For example:

OdiSftp "-HOST=<HOST>" "-USER=<USERNAME>" "-LOCAL_DIR=<DIR>" "-REMOTE_DIR=<DIR>" "-STOP_ON_FTP_ERROR=YES" "-COMPRESSION=NO" "-STRICT_HOSTKEY_CHECKING=YES"
get <FILENAME>

   or

OdiSftpPut "-HOST=<HOST>" "-USER=<USERNAME>" "-LOCAL_DIR=<DIR>" "-LOCAL_FILE=<FILENAME>" "-REMOTE_DIR=<DIR>" "-REMOTE_FILE=<FILENAME>" "-CREATE_REMOTE_DIR=YES" "-COMPRESSION=NO" "-STRICT_HOSTKEY_CHECKING=YES"

Changes

Cause

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