Sitemap

Amicuk Programming Answers

SFTP configuration using SFTP tool in ODI

-0001-11-30   Views:23

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
i i had to install windows on my macbook pro retina with mac osx 10.10 to use 3d max on may work, now i want to access on my files on my external hard drive with mac format, i can view files but i can't use file or install any programmes also from ma [More]
For years I used Skype in high res mode (1280X720) with auto answer to look at the veiw from may vacation house window. This worked great. The picture quality was terrific and the connection was always stable. However, after I upgraded the Skype vers [More]
We have an HP Photosmart 2610 all-in-one, an AirPort Extreme base station, and a G-5 MacIntosh running OS 10.4.8. We can print when the all-in-one unit is connected directly to the Mac with USB cable, however, we are unable to print when the USB cabl [More]
I Have downloaded the 64 bit version of iTunes for my Sony running Windows 8.  Install went fine and I can get in to iTunes and see the music residing on this machine.  However, everytime that I try to run iTunes Match Windows crashes.  So frustratin [More]
I couldn't decide what category to choose, because my MacBook isn't "black and white". It is just white. The audio out port (marked with headphone symbol) is intermittent with headphones or speakers. I can't say what causes it. Unplugging / plug [More]
When I click on 'Help' in iMovie, 'Help' goes dark, but no menu drops down. I have never seen this happen in any other app. How can I fix this? Thanks, KlausI don't know how to fix your problem, but in the meantime, here is a web link to iMovie Help. [More]
How do I move photos from Mac to iPad?Connect the iPad to your Computer and sync with iTunes. Your iPad will appear in the "Devices" section in the iTunes Library Inspector. Select it and click the "Photos" tab. Choose which events and [More]
I am a new user to LabView. I am trying to program the FPGA on a 9144 Ethercat chassis with modules 9423 (Digital input), 9201 (Analog input), 9853 (CAN).  9144 is connected to a cRIO-9024.  There are more modules but if I can figure these out, the o [More]
I have 41 songs in a particular PLAYLIST and it plays the first one OK but when it advances to the next one it "runs" but there is no Audio. I have to manually stop , go back to the PLAYLIST and then select the next song...then it plays OK. Ther [More]
how to import Package org.jdesktop.swingx.autocomplete in my code its Giving error ,,, i am using Auto Complete Supprt For my Combo Box .......but i am unable to import the package containg nesseary classes like AutoCompleteSupport support = AutoComp [More]