Recordset per message not working

[Former Member]

Hi,

I am having a file to RFC scenario.

Smaller text files of 5 MB can be processed without any issue.

(After it is coverted from text format into XML in communication channel, it gets roughly five times the original text file size. That means that this XML message will have size of 25 MB in XI.)

The text file which is giving the error has got a size of 19 MB. Error message: Could not insert message into database. Internal driver error (pipe closed)

I have tried to use 'record per message' option to split the file. Giving a value of 100 there. Totally there are 500 records.

But I am seeing the message in the communication chennel log like given below.

"Send binary file "cost_report.dat" from ftp server "6.23.43.6:/Information/ERP/upload/", size 83981954 bytes with QoS EO"

From this I am concluding that file is not getting split according to 'recordset per message' settings. XI is trying to read the entire file.

Why is the this setting not working?

Or will XI split the file all at once and after that only the split happens?

Kindly help.

Thanks,

[Former Member]

Hi,

Try to give your sender comm. channel the following values:

Content Conversion:

Recordset Structure: Row,5000

Recordset per Message: 1

It will divide your file into 5000 records and generate new messages.