Skip to Content

Split single file into multiple in SAP PI

error-filepick.png

Hi Experts,

My scenario is as follows;

Firstly, the flow is IDoc to FIle where around 40.000 IDocs are processed and written in a file.I have used module parameters here to generate a flat file for all the records.The file is huge around 700 MB

Secondly,the file is picked by Sender file adapter in second ICo and further processed using FCC and it is inserted into database at one go using JDBC adapter.

This scenario was working fine before but now the huge file is not getting picked by the file sender channel and I am getting error as attached.

Can anyone let me know whether there is any process to split the file after it is converted to one single flat file and before the next sender channel picks the file.

I have tried the below:

1)Chunk mode- This is not working since my second ICo has mapping involved

2)Zip and Unzip of file

3)Maximum bytes in Advance Tab

Awaiting for the reply.

Thanks in advance!!!

Regards,

Neethu

error-filepick.png (26.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 29, 2016 at 05:44 AM

    Neetu,

    Try maintaining a limited number of records for FCC with parameter : "Records Set Per Message" in FCC.

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2016 at 05:23 AM

    Hi Evgeniy,

    Yes I am using append to add records to the existing file.

    Regards,

    Neethu

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2016 at 05:40 AM

    Hi,

    Adding to the above the first mapping has only few fields mapped and the Data records has all the fields concatenated and mapped to single field at the receiver.

    Thanks!!!

    Regards,

    Neethu

    Add comment
    10|10000 characters needed characters exceeded