topic How to resolve the 'too many rows in result' in Nuxeo Forum

How to resolve the 'too many rows in result'

Dominic_Bérubé — Fri, 27 Sep 2013 22:16:15 GMT

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

Re: How to resolve the 'too many rows in result'

Dominic_Bérubé — Mon, 30 Sep 2013 19:45:51 GMT

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.

Re: How to resolve the 'too many rows in result'

Florent_Guillau — Tue, 01 Oct 2013 11:55:57 GMT

Note that changing the templates directly is not recommended as they're part of the Nuxeo distribution and may be overwritten on upgrade. You should create [custom templates](http