Need to Process the file Sequential manner using SAP CPI SFTP Sender adapter

[sinhasouvik]

Hi All,

I have scenario where in SFTP folder there will be multiple files with naming convention like "EC_Dept_S9_070420063558.xml.pgp" .(Numeric part of the filename is date and Time stamp.)

We need to process the files in sequential manner based on the file name. Older file with older date and time will go first and then one after another.

How do I achieve this scenario? Do I need to configure anything in SAP CPI SFTP sender adapter to pick it up and process in sequential basis?

Regards,

Souvik

[advitramesh]

Hey Souvik,

Were you able to get a resolution for your issue. I believe the reason for files not getting picked up sequentially is because of the number of worker nodes in your SAP CPI tenant.

As per the SAP help below you can run into a situation in which messages that are later in the sorting order can overtake other messages which are currently being processed on a different worker. This disturbs the sequence of messages.

https://help.sap.com/docs/CLOUD_INTEGRATION/368c481cd6954bdfa5d0435479fd4eaf/2de9ee58737247969eb7dc9...

You amy want to handle this using a data store to store the file names/timestamps from the SFTP and you would need another iflow to read the data store by using the Poll Enricher to get the specific file from the SFTP Server

[sinhasouvik]

Thanks for your suggestion. We have managed to solve it.

Regards,

Souvik

[asoni]

Hi souvik_sinha,

Please check my blog on how I achieved the serialization of files here - https://blogs.sap.com/2022/08/25/serialize-files-transfer-with-sftp-adapter-in-cpi-using-general-spl...

Hopefully, it can help others with similar requirements who land on your question searching for a solution to achieve the serialization of files in SAP Integration Suite.

Thanks,

Ankit

[former_member841063]

Hi Souvik,

We have a similar requirement, would you please comment as to how the issue got resolved.

Thanks,

Nitin

[advitramesh]

Hey Souvik.

Can you please let me know the approach you used. We have a similar requirement and we are experiencing the same issues you experienced. I am keen to know if this can be handled with the standard functionality in SAP CPI

Thanks for your time

Regards

Advit

[Sriprasadsbhat]

Hello Souvik,

You can give a try with below parameters in SFTP sender adapters processing parameters.

• None: The sorting is specified by the STFP server

• File Name: Files are polled sorted by file name

• File Size: Files are polled sorted by file size

• Time Stamp: Files are polled sorted by the modification time stamp of the file

https://help.sap.com/viewer/368c481cd6954bdfa5d0435479fd4eaf/Cloud/en-US/2de9ee58737247969eb7dc9e68b...

Regards,

Sriprasad Shivaram Bhat

[sinhasouvik]

Hi sriprasadshivaramabhat ,

I have tried with all options expect file size, nothing is working for me. Please find the below screenshot from SFTP folder. I wanted to to process the EC_Dept_S9_310320063558.xml , this file first. But everytime orher one getting picked up and processed.

SFTP Folder:

File name pattern I am using to pick the file is EC_Dept_S9_*.xml

Any suggestion please.

Regards,

Souvik