1 Reply Latest reply on Jan 22, 2015 3:04 PM by umit

    SFTP Error in ODI11.1.1.6

    2796837

      Hi,


      I'm having some problems while try to use odiSFTPPut. When I try to execute the object, i got this error below:

       

      org.apache.commons.vfs.FileSystemException: Could not connect to SFTP server at "´XXXXXXXXXXXXXXXX"

       

      But when I log on the server and use the command below:

       

      sftp 138.69.241.19

       

      It works fine.


      I have given the following Parameter while configuring it.


      OdiSftpPut "-HOST=XXXXXXXXX" "-USER=XXXXXXXXXXXXX" "-PASSWORD=XXXXXXXXXXXXX" "-LOCAL_DIR=/opt/apps/oracle/" "-LOCAL_FILE=sampleftp.csv" "-REMOTE_DIR=/home/XXXXXXXXXXX" "-COMPRESSION=NO" "-STRICT_HOSTKEY_CHECKING=NO"


      Error Message:-


      org.apache.commons.vfs.FileSystemException: Could not connect to SFTP server at "XXXXXXXXXXXXXXXXXXXXXX".

        at org.apache.commons.vfs.provider.sftp.SftpFileProvider.doCreateFileSystem(SftpFileProvider.java:99)

        at org.apache.commons.vfs.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:81)

        at org.apache.commons.vfs.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:62)

        at org.apache.commons.vfs.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:641)

        at org.apache.commons.vfs.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:582)

        at com.sunopsis.dwg.tools.filecopy.RemoteFileCopy.copy(RemoteFileCopy.java:424)

        at com.sunopsis.dwg.tools.SftpPut.actionExecute(SftpPut.java:49)

        at com.sunopsis.dwg.function.SnpsFunctionBase.execute(SnpsFunctionBase.java:276)

        at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

        at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

        at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)

        at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)

        at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

        at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

        at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

        at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)

        at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)

        at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)

        at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:219)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)

        at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

        at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)

        at java.lang.Thread.run(Thread.java:662)

      Caused by: org.apache.commons.vfs.FileSystemException: Could not connect to SFTP server at "138.69.241.19".

        at org.apache.commons.vfs.provider.sftp.SftpClientFactory.createConnection(SftpClientFactory.java:241)

        at org.apache.commons.vfs.provider.sftp.SftpFileProvider.doCreateFileSystem(SftpFileProvider.java:90)

        ... 25 more

      Caused by: com.jcraft.jsch.JSchException: Auth fail

        at com.jcraft.jsch.Session.connect(Session.java:451)

        at com.jcraft.jsch.Session.connect(Session.java:149)

        at org.apache.commons.vfs.provider.sftp.SftpClientFactory.createConnection(SftpClientFactory.java:210)

        ... 26 more

       

       

      Could you please help me on this ASAP.

       

      Thanks and Regards,

      Valli.

       

      Message was edited by: PhHein Connection details removed