Skip to Content
0

SFTP adapter picking files once but two messages creating with difference of miliseconds.

Mar 18, 2017 at 07:15 AM

147

avatar image

Hi experts!!!

I have been observing strange behavior of my SFTP sender adapter as it is picking one file and creating two different message id's with same content with difference of milliseconds.

My scenario is SFTP to JDBC, 1 file i placed in sftp server for which two messages are creating in DB with same contents.

I have upgraded new patch 31 of SFTP adapter & also enabled 'removeProcessedFiles' parameter in advanced tab for duplicate checks with 'DuplicateMessageContent' folder in sftp server, but PI itself internally generating two message id's for single file and generating multiple message id's.

Please suggest solution if any one has came across with same issue.

Regards,

Samir.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Andrzej Filusz Mar 21, 2017 at 08:27 AM
1

Hi Samir,

The note that describes that problem is new - from last month:

2424450 - Message processed twice at Sender Channel in SFTP Adapter

So if you are pretty sure that you have the latest patch/the permissions are correct and the problem still occurs then I would send a customer message to SAP.

Regards,

Andrzej

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Andrzej,

I have deployed latest SFTP SP004 level 31 also i have checked permissions as well, still this problem is occurring in timely intervals.

Regards,

Samir.

0
Iñaki Vila Mar 20, 2017 at 03:36 PM
0

Hi Samir,

Have you tried with the parameter duplicateCheckPersist?. The value is in minutes.

1744700 - SFTP Adapter - duplicateCheckPersist Attribute

Regards.

Share
10 |10000 characters needed characters left characters exceeded
Samir Lambe Mar 21, 2017 at 06:15 AM
0

Hi Inaki,

duplicateCheckPersist option will check only duplicate files, if same file again appears in sftp server it won't process it. But in my scenario am placing only 1 file in sftp server apart from that no other file am placing, here file is picking once but system is generating 2 different message id's with same contents in message monitoring.

Regards,

Samir.

Share
10 |10000 characters needed characters left characters exceeded
Iñaki Vila Mar 21, 2017 at 07:16 AM
0

Hi Samir,

You can talk with the endpoint developer to change the way they are writting the file, i mean meantime the writind is doing it the file can be named XXX.temp and in the last moment they rename the file, therefore the PI only take the renamed file. I think the problem could be that the PI is taking the file that is not complete written.

Regards.

Share
10 |10000 characters needed characters left characters exceeded