My Oracle Support Banner

"Could not connect to SFTP server at <REMOTE_HOST>" Error when Using OdiSftpPut API in ODI (Doc ID 2533120.1)

Last updated on JANUARY 08, 2025

Applies to:

Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator - Version 10.1.3.2.0 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Symptoms

When connecting to SFTP server using OdiSftpPut API in Oracle Data Integrator (ODI), the following error occurs:

org.apache.commons.vfs2.FileSystemException: Could not connect to SFTP server at "sftp://<REMOTE_HOST>".
  at org.apache.commons.vfs2.provider.sftp.SftpFileProvider.doCreateFileSystem(SftpFileProvider.java:107)
  at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.getFileSystem(AbstractOriginatingFileProvider.java:103)
  at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:81)
  at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:65)
  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:474)
  at com.sunopsis.dwg.tools.SftpPut.actionExecute(SftpPut.java:52)
  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)
  ...
Caused by: org.apache.commons.vfs2.FileSystemException: Could not connect to SFTP server at "<REMOTE_HOST>".
  at org.apache.commons.vfs2.provider.sftp.SftpClientFactory.createConnection(SftpClientFactory.java:230)
  at org.apache.commons.vfs2.provider.sftp.SftpFileProvider.doCreateFileSystem(SftpFileProvider.java:96)
  ... 33 more
Caused by: com.jcraft.jsch.JSchException: reject HostKey: <REMOTE_HOST>
  at com.jcraft.jsch.Session.checkHost(Session.java:781)
  at com.jcraft.jsch.Session.connect(Session.java:342)
  at com.jcraft.jsch.Session.connect(Session.java:183)
  at org.apache.commons.vfs2.provider.sftp.SftpClientFactory.createConnection(SftpClientFactory.java:226)
  ... 34 more

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!

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