WARN: Numbers of submitted rows [1000] have exceeded the configured limit (4379932)

When running database collections in any of the following types of cartridges

• Oracle Instance
• Oracle RAC
• Oracle ASM
• Oracle CRS
• MySQL PI
• DB2
• PostgreSQL PI
• Azure SQL agents

Users may encounter warning messages similar to:

WARN    [AGENTNAME-lowPriorityPool-3-[DBO_DatafilesStorage][DATETIME]] 
com.quest.qsi.fason.core.collection.processor.AbstractQueryProcessor - 
Numbers of submitted rows [1000] have exceeded the configured limit [1000] for processor [DBODataFileProcessor], 
collection [DBO_DatafilesStorage]. Submitting the first [1000] rows.

These messages indicate that the number of rows collected for a specific processor or collection has reached a maximum limit, and only the first 1000 rows are being processed. This may affect collections with many rows of output such as DBO_DatafilesStorage, DBO_Datafile_IO_Activity, or DBO_TablespacesStorage.

This warning is generated because the global parameter agmMaxRowsToSubmit is set to a value (e.g., 1000) that restricts the number of rows submitted per collection, regardless of the collection’s individual colMaxRows setting (which may be higher, such as 5000). When the number of rows returned by a query exceeds agmMaxRowsToSubmit, only the first 1000 rows are submitted, and the rest are ignored.

For example:

agmMaxRowsToSubmit=1000
colMaxRows=5000
    

In this case, the effective limit is 1000 rows, due to the global parameter.

1. Check the current value of agmMaxRowsToSubmit:
   Download and use the Query-agmMaxRowsToSubmit.groovy script from Supportlink. This script will return the current value for the specified agent. You must be logged into Supportlink to access and download the script.
   
   Instructions:
   • Download the script from Supportlink.
   • Open the script and set the agentName variable in line 3 to your target agent's name.
   • Run the script in the Foglight script console.
   • The script will display the current value of agmMaxRowsToSubmit for the specified agent.
2. Update the value of agmMaxRowsToSubmit if necessary:
   Download and use the Set-agmMaxRowsToSubmit.groovy script from Supportlink. This script allows you to set a higher value for agmMaxRowsToSubmit for your agent. You must be logged into Supportlink to access and download the script.
   
   Instructions:
   • Download the script from Supportlink.
   • Open the script and set the agentName variable on line 4 to your target agent's name.
   • Modify the agmMaxRowsToSubmit value in the script on line 9 to the desired row limit (e.g., 5000, 10000, 50000, etc.).
   • Run the script in the Foglight script console.
   • The script will update the value for your agent. Note: You may need to restart the agent for the change to take effect.
3. Recheck the current value of agmMaxRowsToSubmit:
   Use the Query-agmMaxRowsToSubmit.groovy script a second time to return the updated value for the specified agent. 

Note: The lower value between agmMaxRowsToSubmit and colMaxRows will always take precedence.

Supportlink Access: You must be logged in to Supportlink to download the provided scripts.