-
Title
How to increase the amount of rows of user defined collections (UDC)? -
Description
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
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
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.