Question related to FILE SENDER handling of recordsets

[Former Member]

Hi

We have a File->RFC SAP scenario

We are reading files using FTP File adapter. Splitting messages 100 messages per recordset. QOS is EXACTLY ONCE!

If we have a huge file - lets say 100.000 records.

The adapter starts reading and gets to 50.000th record and FTP server (SENDER) crashes.

My question is which one of the below scenarios is true (if any):

A)

are those 50.000 records now processed, and in "chunks" of 100's beeing routed to the SAP system and processed?

What then, if the FTP server comes up again, how does it know where in the file it has reached???

B)

Or is it so, that PI reads the file and persists the messages (in 100's) and only when it has reached the end of the file it then

starts to call the SAP system via RFC adapter.

If it does NOT reach the end of file (ie FTPserver crashes...) then ALL messages (so the 50.000) are marked as erronoeus and will NOT be processed to SAP RFC?

I hope it is B, but please help

[former_member181962 · Accepted solution]

Hi Bohamo,

Even if it is big file, all the records will be picked up at once (XI Picks one file at a time).

So even if the FTP crashes after you pick it up, then also XI will have all the 100000 records ready to be processed.

After the file adapter has the 1000000 records ready, then it will process chunks of 100 records each.

YOu will have one RFC call per 100 records of information (1000 RFC calls for the whole file).

Regards,

Ravi Kanth Talagana