How to increase the amount of rows of user defined collections (UDC)? (4252593)

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:
---
ECHO    ERROR [FglAM:IncomingMessage[4]-6517] com.quest.qsi.fason.oracle.collection.processor.DBORMIFirstSuccessProcessor - Failed to run MyDatabase instance in CUSTOM_QUERY_FIELDS collection.
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?

CAUSE 1

A unique key has not been defined for the query result.

CAUSE 2

The maximum number of rows retrieved has been set to the default value of 100.

RESOLUTION 1

To retrieve more than one rows in a User Defined Collection

Set a unique key for the required fields

RESOLUTION 2

To increase the maximum number of retrieved rows

Set the amount of rows in the ASP of the agent like described below:

OPTION 1

• Go to the Database Overview dashboard
• Select the problematic agent and click on "Settings | Administration"
• Click on "User-defined Collections" on the left hand side
• On top you will find "Maximum number of retrieved rows; 100"; click on it to change the row limitation
  

OPTION 2

• Open "Administration | Agents | Agent Status"
• Select the agent, where you want to change the parameter
• Click on "Modify the private properties for this agent"
• Go to "Custom Collection Details"
• Change the parameter "Maximum rows to submit for Custom collection"
  
• Click on "Save"

Be aware that it will put additional load on the agent and the server if value will be increased. Select a reasonable value.