cancel
Showing results for 
Search instead for 
Did you mean: 

Upper Limit on Rowcount

Former Member
0 Kudos
357

Hi All

We recently had an issue where the interface need to transfer 145000 rows but MII transferred only 120000 rows, that figure rings a bell about the upper limit on rowcount that MII query template has. Is that the max no of rows that MII can pick?

Thanks

Rupesh

View Entire Topic
Former Member
0 Kudos

Rupesh,

if you are using MII 12.1 >= SP10 or MII 12.2 >= SP4, then you can change the limit of the RowCount

from 120.000 to xxx.xxx under AdminMenu -> System Management -> System Properties -> Maximum Rowcount.

Please keep in mind, that increasing of the parameter will slow down the query.

BR

Pedro

former_member204240
Active Participant
0 Kudos

Hi Pedro, Its nice to know that we can change the limit.

But is this is limited only to certain versions and SP that you have mentioned?

Former Member
0 Kudos

Padma,

the possibility of changing the Maximum Rowcount is added to MII with the SP mention above.

BR

Pedro

former_member204240
Active Participant
0 Kudos

Okay, I was really not knowing this.Thanks for the update.