Recordset per message not working

[Former Member]

Hi All,

I got a scenario where i need to read a file of more than 1mb which has got around 6000 records.i want to read 100 records at a time and have mentioned

"Recordset per message-100"

in the file configuration.But still i am seeing a xml message of 6000 records in the XI.

This is the configuration part for the file"

Recordset Name:Record

Recordset structure:Row1,*

Recordset per message:100

Row1.fieldNames:FirstName,LastName,MiddleName,City,Place,State,Country

Row1.fieldSeparator:£

Row1.processConfiguration:FromConfiguration

Row1.endSeparator:'nl'

the xml message i get now

i need to process only 100 records at a time...

Any Help greatly appreciated...

Thanks,

Aravind

[Former Member · Accepted solution]

Can you try with these parameters ?

Recordset Name:Record

Recordset structure:Row1,100

Recordset per message:1

[Former Member · Accepted solution]

Hi Renjith,

Recordset Name:Record

<b>Recordset structure:Row1,100</b>

Recordset per message:1

if i try out as you said,i am getting only the first 100 message processed and it skips the following lines...my file has got 6000 records..

[Former Member · Accepted solution]

Hi,

Can you please try this...

Recordset Name:Record

Recordset structure:Row1,*

Recordset Sequence: Ascending

Recordset per message:100

But i assume you might get an xml like this...

<MT>

<Record>

<Row1>

</Row1>

</Record>

<Record>

<Row1>

</Row1>

</Record>

<Record>

<Row1>

</Row1>

</Record>

...

100 records...

</MT>

Thanks,

Renjith

[Former Member]

Have you tried:

Recordset structure:Row1,1

Recordset per message:100

Regards,

Jin

[Former Member]

Hi All,

I had errors in the recieving side.Now it is working fine.

this is my final configuration.

Recordset Name:Record

Recordset structure:Row1,100

Recordset per message:1

Thanks for your contribution.

[prabhu_s2]

1. Recordset name <b>recordset</b>

Recordset structure <b>recordset,*</b>

or

2. if you have currently defined your recordset structure as "Substr,*", use "Substr,1" instead.

or

You may check the File Allocation Size limits with the XI Admin / Network / Basis team

[Former Member]

Hi Prabhu,

I tried your solution,still the same,it processes first 100 records and skips the following lines...<b>only my first 100 records gets processed again and again.</b>

How do i continues processing the file from 101-200 lines and thereafter till 6000 lines?

[prabhu_s2]

any errors u see after the processing of the first set...may be u need to check on thois also....take the second set of data and test it in the IR