Sitemap

Amicuk Programming Answers

SFTP configuration using SFTP tool in ODI

-0001-11-30   Views:22

Advertisement

Does anyone has successfully done the SFTP inmplementation in ODI? I am trying to achieve the same and failingwith error: org.apache.commons.vfs.FileSystemException: Could not connect to SFTP server at "sftp://10.3.48.215/".      at org.apache.c

Does anyone has successfully done the SFTP inmplementation in ODI?
I am trying to achieve the same and failingwith error:
org.apache.commons.vfs.FileSystemException: Could not connect to SFTP server at "sftp://10.3.48.215/".
     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)
I have given the following Parameter while configuring it:
Remote Host:
Remote UserName:
Remote User Password:
Local Directory:
Remote Directory:
These all are mandatory field and I setup accordingly#
Please suggest.............
Thanks
Edited by: 842739 on 14-Jul-2011 04:22
Edited by: 842739 on 14-Jul-2011 04:22

The replay answer
Advertisement
Hi,
We have the same problem too with ODI version 11.1.1.3. We can connect from de host with sftp commands, but when we execute ODISftpput from the same host (via agent) it throws an exception:
Caused By: org.apache.commons.vfs.FileSystemException: Could not connect to SFTP server at "sftp://140.99.240.63/".
     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:438)
     at com.sunopsis.dwg.tools.SftpPut.actionExecute(SftpPut.java:49)
     at com.sunopsis.dwg.function.SnpsFunctionBase.execute(SnpsFunctionBase.java:273)
     at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3185)
     at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:1414)
     at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java:2785)
     at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2515)
     at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:534)
     at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:449)
     at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1954)
     at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:322)
     at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)
     at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:246)
     at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:237)
     at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:794)
     at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:114)
     at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
     at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.commons.vfs.FileSystemException: Could not connect to SFTP server at "150.100.250.63".
     at org.apache.commons.vfs.provider.sftp.SftpClientFactory.createConnection(SftpClientFactory.java:214)
     at org.apache.commons.vfs.provider.sftp.SftpFileProvider.doCreateFileSystem(SftpFileProvider.java:90)
     ... 22 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)
     ... 23 more
The execution code:
OdiSftpPut "-HOST=140.99.240.63" "-USER=userput" "-PASSWORD=dnfH66Ejn3aEwxoZ0H7i,bifvAy" "-LOCAL_DIR=/data/filesftp/ora" "-LOCAL_FILE=*.txt" "-REMOTE_DIR=/test/out" "-COMPRESSION=NO" "-STRICT_HOSTKEY_CHECKING=NO" "-TIMEOUT=60"
We need an urgent solution
Greetings
Jordi

Go to See the other 6 answers

SFTP configuration using SFTP tool in ODI

Category:DefaultRelease time:-0001-11-30Views:130

Does anyone has successfully done the SFTP inmplementation in ODI? I am trying to achieve the same and failingwith error: org.apache.commons.vfs.FileSystemException: Could not connect to SFTP server at "sftp://10.3.48.215/".      at org.apache.c[More]

Support for Software Configuration Management(SCM) Tools

Category:DefaultRelease time:-0001-11-30Views:130

Hi!, I am using JDevloper for my project. I want to maintain the versions of all files in the project.Also,if all are using one Workspace on network and someone updates a file then message box got dispalyed asking for reloading buffers again. So to a[More]

Configuration Data Transfer Tool

Category:DefaultRelease time:-0001-11-30Views:130

Hello all, I am working with my client to plan our ME Configuration and we are trying to determine how best to propagate the configuration from one system to another (i.e. DEV to QA to PROD).  I understand there is a new tool being developed for SAP[More]

What are the stpes to configure third party tools in BW

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, can you please send me any documents on "what are the stpes to configure third party tools in BW"Hi, 1> Define the RFC connection ;ex:-Define the IP address using SM59 2> Define the third pary sourcesystem 3>Assign it to infosou[More]

Invoking WSDL using OdiInvokeWebService tool in ODI and ORMB integration

Category:DefaultRelease time:-0001-11-30Views:130

I did  all the configuration to invoke WSDL through OdiInvokeWebService to get response in the XML file got the following issue when in request file i send the XML with request parameter got via a Advance feature of the OdiInvokeWebService  tool. inp[More]

Unable to configure ODBC data source through odi

Category:DefaultRelease time:2015-10-11Views:130

Hi, Let me explain the architecture first. We have three machines 1. OpenVMS machine on which connx server is running for RMS files, say SRC 2. Windows machine on which ODI Data Studio 11.1.1, Say WRKSTN, This has connx client installed 3. Target is[More]

Issue in configuring the Master Repository in ODI

Category:DefaultRelease time:2015-10-11Views:130

Hi, I just downloaded and installed ODI. I wanted to create Master Repository in Sql Server 2005 (service pack 2). I gave the following string for jdbc:sqlserver://<servername>:1433;selectMethod=cursor;databaseName=odimaster;integratedSecurity=false[More]

Is there any Reporting tool in ODI?

Category:DefaultRelease time:-0001-11-30Views:130

Hi My Senario is like , am transforing data from one data base to another (some amount of data). i want detailed information about how much data shoud be transfered and how much pending .some period of time like weekly report or daily reoprt i need .[More]

Advanced Configuration in Admin tool

Category:DefaultRelease time:-0001-11-30Views:130

Hello All, Can anybody point me to any documentation or white paper on how to do some advance configurations in the OBI EE Admin tool,like partitioning. Basically how can you improve performance by doing partitioning (in database ) in BI EE.You can i[More]

Log Configuration with config tool

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, In my application, I am using Logging. I have created  Location and Category controllers and it is working fine.My Application specific log files(destinations) are being updated correctly.Now my question are that: 1. Can we access my applicat[More]

How to install or configure new odbc driver in ODI

Category:DefaultRelease time:-0001-11-30Views:130

Hi I want to configure filemaker 11 in odi to do this i have an filemaker odbc driver. Will it be possible to configure this odbc file as new technology in ODI? If possible please let me know the procedure to do it. Thanks in advance Regards SandeepH[More]

Hot
Hi all, I have been struggling with a BSOD for the past 5 weeks and have scoured the web trying in vain to find someone else with the same issue. Environment: 8 x 2008 R2 SP1 Windows Servers (8Gb RAM, 25Gb HDD) with Remote Desktop Services Roles inst [More]
1. user excuted update and inset statement from sqlplus , please give me the flow in oracle architecture 2. user excuted commit and roll back also please give me the flow in oracle architecture ThanksAs Pierre Forstmann said answer can vary according [More]
I am trying to create a custom partner type 'ZP' for my service notifications. This i would like to assign to my partner function 'ZX'. In iw51 when i am creating a service notification under the 'tasks' tab when i set the 'task processor' as 'ZX' i [More]
Hey everybody hows it going? Any help you could give me would be greatly appreciated! Here is my problem. I am working off a template and have been able to do everything I want so far but ive run into a problem. Check my site to follow along Shine Me [More]
Can any one tell me what SAML assertion is all about?? and I just want to try out sample steps pertaining to SAML assertion in my policy editor. So Can any one of you kindly tell me a simple use case that you have tried out with SAML assertion. In th [More]
Hi community I just upgraded 3gs to IOS6.  During original upgrade, iTunes became non respondant which forced me to crash it.  then the phone power cycled continually as the IOS upgrade hadn't completed. I had to factory reset the phone and verify th [More]
What is the best iphone model to buyThe one you like the best, and which works will with the carrier you wish to use in the area you mainly plan to use it in.Read other 3 answers [More]
Hi Experts, I have a step in Process chain for activation of a request in DSO. But its failing frequently with error message "Background process BCTL_* terminated due to missing confirmation*". I tried to remove the step from process chain and r [More]
Hi All, I am currently trying to deploy my web project to weblogic. I am using netbeans - weblogic integration to deploy. However the deployment fails with the following message. I have provided correct password of weblogic in netbeans to login Any h [More]
We are upgrading from 4.6C to ECC 6.0 and we have detected a problem with texts in sales orders. The problem is easy to explain, after entering a text with more than one line, when you enter again in transaction VA02 (or VA03) and display the text, y [More]