Skip to Content
author's profile photo Wu Feng
0
Wu Feng

SFTP adapter sending data not work stable

Posted on Sep 18, 2019 at 02:37 PM 132 Views

Hi guys，

I used the SFTP adapter to send data to SFTP server.

When we test it with several thousand records, got a strange problem, that is:

after message mapping, I could see the file content is well; however, the file content is not correct

in the target sftp server, about every one thousand records, generating one line of unreadable record.

Would you like to help me out?

1.png (26.8 kB)
2.png (25.9 kB)
3.png (40.6 kB)
3.png (32.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Sugata Bagchi Majumder
    Sugata Bagchi Majumder
    Posted on Sep 18, 2019 at 04:17 PM
    0

    What is your encoding and are you using FCC?

    Thanks

    Sugata

    Add a comment
    10|10000 characters needed characters exceeded

    • Wu Feng
      Sep 19, 2019 at 08:58 AM

      Hi Sugata,

      We use UTF-8 encoding, and even without FCC( convert it into the target format in Message Mapping step), the result is the same.

      From below screenshot of source content, you can see that, there is no special language character set.

      I had done another two test action:

      1. With the same test data, before the data being sent, I delete the first 1100 records.

      The result is that it is at line 1117, the same line as without deleting.

      2. I download file content from the log of AM step, and upload it to SFTP server with tool FileZilla, and download it with chrome browser.

      The result is the file content is correct.

      **********updated on 20190920

      Newly test， I can put the test data to the sftp server correctly in message mapping step via Java coding to call to SFTP server directly.

      So, from the test, I can figure out that, it was not the SFTP server or network, but the SFTP adapter causing such an issue.

      The release version of PO we are using is NW750EXT_11_REL.


      1.png (21.9 kB)
  • author's profile photo Vikas Kumar Singh
    Vikas Kumar Singh
    Posted on Oct 09, 2019 at 11:33 AM
    0

    Hi,

    Just to be sure can you also do one more test, try with receiver file channel rather than sftp channel and place file in nFS directory and see if you get the same characters or good result.

    Regards,

    Vikas

    Add a comment
    10|10000 characters needed characters exceeded

    • Wu Feng
      Oct 21, 2019 at 01:23 AM

      Hi Vikas,

      I had done test with File adapter , saving file in local directory, and then reading it to send to SFTP server. The file content in local directory is correct.

      I'm waiting for basis team to upgrade the component version.

      Thank you anyway.

  • author's profile photo Raffael Herrmann
    Raffael Herrmann
    Posted on Oct 09, 2019 at 07:50 PM
    0

    Can you figure out which version of the JSch library is used in the SFTP adapter? Up to version 0.1.52 there was a bug, which sounds like the behaviour you're experiencing.

    From the changelog (http://www.jcraft.com/jsch/ChangeLog):
    "[...] [bugfix] sftp-put may send the garbage data in some rare case. [...]"

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.