How to resolve the 'too many rows in result'

Question

I'm getting the SizeLimitExceededException when I'm calling the UserManager.getUserIds() method as soon as I get over 50 users.

Here's the stack trace:

[org.nuxeo.ecm.platform.usermanager.providers.UsersPageProvider] too many rows in result: 51
org.nuxeo.ecm.directory.SizeLimitExceededException: too many rows in result: 51
at org.nuxeo.ecm.directory.sql.SQLSession.query(SQLSession.java:709)

So I was wondering where I can change the config to avoid that exception, because I really need to get the list of all user id in the database.

I'm using prosgresql and Nuxeo 5.4.2

Thanks,

Dom

Dominic_Bérubé · Accepted Answer

I found it, it's a config, as I expected.

To change the template of the config file, go to : [your Nuxeo installation folder]	emplates\common\config\default-sql-directories-bundle.xml and change the 'querySizeLimit' value for the 'userDirectory' section.