Is there a way, to increase the amount of retrieved rows of user defined collections? Currently it is limited to 100 rows?
User Defined collections are not displaying all of the rows collected by the query.
In the log file the following error appears and the dashboard does not show any data:
java.lang.RuntimeException: java.lang.RuntimeException: Failed to execute collection [CUSTOM_QUERY_FIELDS], reason= the query returned 15639 rows, thereby exceeding the maximum number of returned rows allowed for a user-defined collection, which is 100
Why is there only one row shown in the UDC output when there are many rows in the table?
A unique key has not been defined for the query result.
The maximum number of rows retrieved has been set to the default value of 100.
Set a unique key for the required fields
Set the amount of rows in the ASP of the agent like described below:
Be aware that it will put additional load on the agent and the server if value will be increased. Select a reasonable value.
© 2020 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad