topic Re: tFTPPut "Invalid User" error in Talend Studio

tFTPPut "Invalid User" error

Anonymous — Tue, 24 Jun 2014 08:53:52 GMT

Hi guys,
I have created a simple job following the tutorial here: https://help.talend.com/search/all?query=tFTPPut&content-lang=en .
Now the connection part is successful. No problem there.
But at the next part -- tFTPPut -- I am getting an error:
Exception in component tFTPPut_1
3: Invalid user
at com.jcraft.jsch.ChannelSftp.throwStatusError(ChannelSftp.java:2297)
at com.jcraft.jsch.ChannelSftp.glob_remote(ChannelSftp.java:2137)
at com.jcraft.jsch.ChannelSftp.put(ChannelSftp.java:307)
at edi_on_nav.test_0_1.TEST.tFTPPut_1Process(TEST.java:586)
at edi_on_nav.test_0_1.TEST.tFTPConnection_1Process(TEST.java:428)
at edi_on_nav.test_0_1.TEST.runJobInTOS(TEST.java:1010)
at edi_on_nav.test_0_1.TEST.main(TEST.java:875)

What exactly is this "Invalid User" message?

Re: tFTPPut "Invalid User" error

Anonymous — Tue, 24 Jun 2014 09:00:37 GMT

Hi Cihan,
Whether user has a write access to remote directory?
Can you try using ftp client?
Can you try giving exact file name for upload?
If you want to upload all xml files, try using tFileList with file mask as *.xml and then use tFTPPut component to upload files.
Thanks
Vaibhav

Re: tFTPPut "Invalid User" error

Anonymous — Tue, 24 Jun 2014 09:02:53 GMT

Thanks for the very fast reply. I'll try your suggestions and update the post when I get results.

Re: tFTPPut "Invalid User" error

Anonymous — Tue, 24 Jun 2014 09:38:54 GMT

OK, so I have two different users: one is for uploading files, the other for downloading.
The one with tFTPPut still returns the "Invalid User" error, but I get no such errors with tFTPGet. Does this mean that I can read/download/get files but not upload them onto the server?
By the way, tFTPGet seems to run successfully and I get messages like 3 execs finished, 1 exec finished etc. But I don't see any files actually on my computer. Nothing really gets downloaded, which is odd.
I am unable to try a different FTP client at the moment. I don't have the rights to install anything on this machine.
Exact filename didn't make a difference unfortunately...
Any other tips for me?
Thanks!

Re: tFTPPut "Invalid User" error

Anonymous — Tue, 24 Jun 2014 09:53:21 GMT

You don't need a client to check ftp with that user...
you can use ftp url inside file browser to test the file upload and download with the user credentials available
there is a command line ftp as well to test the same
Vaibhav

Re: tFTPPut "Invalid User" error

Anonymous — Tue, 24 Jun 2014 11:14:29 GMT

Sorry, I made a mistake! This is an SFTP connection, so windows explorer doesn't work.
I've just downloaded a tool named Swish and tried an SFTP connection with it. I got a message saying that my user probably didn't have access to the folders I need.
Do components like tFTPPut or Get need any other adjustments to use them with SFTP? I couldn't see any difference in the documentation.

Re: tFTPPut "Invalid User" error

Anonymous — Tue, 24 Jun 2014 11:17:32 GMT

only port number is different for ftp and sftp.
I think you identified an issue.
Vaibhav

Re: tFTPPut "Invalid User" error

Anonymous — Tue, 24 Jun 2014 14:42:21 GMT

OK, a colleague just proved with another piece of software that he can actually connect to the sftp server and send files, etc...
I used the Java Debug option while running the job and, even though I know nothing about Java, I saw this:
"Exception in component tFTPPut_1
4:
at com.jcraft.jsch.ChannelSftp._stat(ChannelSftp.java:1760)
at com.jcraft.jsch.ChannelSftp._stat(ChannelSftp.java:1767)
at com.jcraft.jsch.ChannelSftp.stat(ChannelSftp.java:1724)
at edi_on_nav.test_0_1.TEST.tFTPPut_1Process(TEST.java:593)
at edi_on_nav.test_0_1.TEST.tFTPConnection_2Process(TEST.java:401)
at edi_on_nav.test_0_1.TEST.runJobInTOS(TEST.java:853)
at edi_on_nav.test_0_1.TEST.main(TEST.java:742)
Caused by: java.io.IOException: Pipe closed
at java.io.PipedInputStream.read(Unknown Source)
at java.io.PipedInputStream.read(Unknown Source)
at com.jcraft.jsch.ChannelSftp.fill(ChannelSftp.java:2333)
at com.jcraft.jsch.ChannelSftp.header(ChannelSftp.java:2359)
at com.jcraft.jsch.ChannelSftp._stat(ChannelSftp.java:1741)
... 6 more"
I googled the error message and there was an explanation in StackOverflow: "It is caused by something causing the connection to close. (It is probably not your application that closed the connection, because that would have resulted in a different exception.)"
Any of the developers out there that can help me out? Thanks in advance.