100 Limit on Repeater action block

[former_member1041989]

Hi Experts,

I am reading one coulmn value from internal SQL table in SAP MII 12.2 by using repeater action block.

I am getting the data for only 100 rows.

Is there any limit on repeater to fetch 100 rows only ??

Can this be increase more ? I have approx 225 rows to read !!

Thanks a lot

[former_member204240 · Accepted solution]

Hi,

Check your query template,

Go to template categories, where you see general folder click on that, you see Row Count, input there as much you want, generally by default it is set to 100.

It helps.

Regards,

Rao

[former_member211944]

Hi Gaurang,

Put a tracer under repeater and trace the 'ItemCount' link of the repeater.

This will show the number of repetitions the repeater will do on the X-path mentioned in the repeater.

Thus will tell you how many rows were read.

Regards,

Rohit Negi.

[agentry_src]

Hi Gaurang,

You may want to check the output of the data you are repeating against.  The default for most queries is to set Rows = 100 so open ended queries do not bog down your MII or datasource.  This limitation is pretty common in a number of MII action blocks so check for it in any other action blocks in your transaction.

Regards, Mike