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 28, 2016

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

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

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=MyHost" "-USER=MyUser" "-LOCAL_DIR=C:\temp" "-REMOTE_DIR=/tmp" "-STOP_ON_FTP_ERROR=YES" "-COMPRESSION=NO" "-STRICT_HOSTKEY_CHECKING=YES"
get sftp_get_test.txt

   or

OdiSftpPut "-HOST=v" "-USER=MyUser" "-LOCAL_DIR=C:\temp" "-LOCAL_FILE=sftp_get_test.txt" "-REMOTE_DIR=/tmp" "-REMOTE_FILE=sftp_get_test.txt" "-CREATE_REMOTE_DIR=YES" "-COMPRESSION=NO" "-STRICT_HOSTKEY_CHECKING=YES"

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