cancel
Showing results for 
Search instead for 
Did you mean: 

SFTP adapter sending data not work stable

wu_feng2
Explorer
0 Kudos

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?

Accepted Solutions (0)

Answers (3)

Answers (3)

r_herrmann
Active Contributor
0 Kudos

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. [...]"

wu_feng2
Explorer
0 Kudos

Hi Raffael,

The version in system is named as 1.005.20180720105641.0000. And I did the java prog calling sftp with jsch-0.1.55.

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

Thank you anyway.

vicky20691
Active Contributor
0 Kudos

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

wu_feng2
Explorer
0 Kudos

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.

sugata_bagchi2
Active Contributor
0 Kudos

What is your encoding and are you using FCC?

Thanks

Sugata

wu_feng2
Explorer
0 Kudos

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.