Sitemap

Amicuk Programming Answers

SFTP configuration using SFTP tool in ODI

-0001-11-30   Views:21

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
Still cannot reliably use Iplayer. It has improved but still not correct. Can anyone help. Stats below FAQ 1. Best Effort Test:  -provides background information. Download  Speed 1.97 Mbps 0 Mbps 2 Mbps Max Achievable Speed  Download speedachieved du [More]
I use OneDrive on my iPhone 5s to back up my photos and videos. When I try to view the videos on my Dell XPS Windows 8.1 machine, I run into trouble.  When I use Windows Live Photo Gallery, it crashes whenever I try to view one of the videos. If I op [More]
It's connected to the wifi, has a strong signal and should be working. I have a second Apple Tv in a different room that I don't have any problems with. This one is close to the router, and is used regularly. It also kicks me out of watching shows ra [More]
Dear All, I would like to know whether the Material included in Easy Cost Planning be updated in Project Builder strucure. Is there any BAPI to upload material component?I do think, that there is no functionality in standard to include the materiai i [More]
I have just uninstalled CS3 and CS4 using the uninstaller and now my computer is saying some components of CS5 need reinstalling and to go to the reinstaller to do that. How do I find the reinstaller the programme was originally downloaded from the A [More]
During recent maintainence activity , a table was exported & imported , deleted , truncated & dropped.After the activity an user lost its privilege on the table and a job related to this table has been failing with the below error SQL*Loader-926: [More]
Just got 1.1 beta yesterday and am trying the new XLS feature. Exported a table to XLS from one user and am trying to import it into another user. Selected all columns in Columns tab, replaced the "Do Not Insert" with column names in Data Types [More]
Does anyone have any recommendations for a program that would replace SystemWorks? What I'm looking for is either one or more programs that would: Recover deleted files, DeFrag, and maybe even an AntiVirus (you never know).MegaByte wrote: Does anyone [More]
Message says Adobe FLash Player 11.6 r602 has stopped working. A probelm caused the program to stop working correctly.  Windows will close the program and notify you if a solution is available. This message has interferred with just about all web sit [More]
Hi Experts, We are having SRM 7 EHP 2, ECC 6 EHP 5. Central contracts are created in SRM & distributed to ECC. When Shopping cart is created referring a contract item {with discount of 20% (01RP) on price 300 $ (01CT)}. The followon document PO creat [More]