How to resolve the 'too many rows in result'
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
I found it, it's a config, as I expected.
To change the template of the config file, go to : [your Nuxeo installation folder]\templates\common\config\default-sql-directories-bundle.xml and change the 'querySizeLimit' value for the 'userDirectory' section.