ODI OdiSftpGet Fails With "Invalid Absolute URI" when Remote Host Is on Windows

(Doc ID 2421907.1)

Last updated on JULY 16, 2018

Applies to:

Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

Using the OdiSftpGet tool to transfer files from a Windows environment to Linux.

The following failure is received when the tool is executed from an Oracle Data Integrator (ODI) installation on Linux:

org.apache.commons.vfs2.FileSystemException: Invalid absolute URI"sftp://hostname.domainG:/temp/".
  at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:61)
  at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:693)
  at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:621)
  at com.sunopsis.dwg.tools.filecopy.RemoteFileCopy.copy(RemoteFileCopy.java:447)
  at com.sunopsis.dwg.tools.SftpGet.actionExecute(SftpGet.java:47)
  at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:235)
  at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:902)
  at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:583)
  at ...
Caused by: org.apache.commons.vfs2.FileSystemException: Port number is missing from URI"sftp://hostname.domainG:/temp/".
  at org.apache.commons.vfs2.provider.HostFileNameParser.extractPort(HostFileNameParser.java:245)
  at org.apache.commons.vfs2.provider.HostFileNameParser.extractToPath(HostFileNameParser.java:150)
  at org.apache.commons.vfs2.provider.URLFileNameParser.parseUri(URLFileNameParser.java:50)
  at org.apache.commons.vfs2.provider.AbstractFileProvider.parseUri(AbstractFileProvider.java:188)
  at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:57)
  ... 24 more

Changes

 

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