Top SQL dashboard timeouts with error "Numbers of submitted rows [10000] have exceeded the configured limit [10000] for processor [DBSSTopSQLProcessor" (4289702)

Customer is experiencing a timeouts in the SQL drilldown page.

The following message was found in the FMS log during this time:

"Numbers of submitted rows [10000] have exceeded the configured limit [10000] for processor [DBSSTopSQLProcessor"

In the Top SQL Statements "Error. Check logs." is listed for each Top SQL statement in red.

Use the script below and check the agent name at the top of the script before running, this will raise the hidden parameter to 50,000 rows.

The agent name in the script should be adjusted to correctly reflect the agent being referenced.

def agentName="DBSS-testsystem-testinstance";
def props = [:];
props.put("agmMaxRowsToSubmit", "50000");

// get agent
def agentService = server.get("AgentService");
def agents = agentService.findByName(agentName);

if (agents.size()  
  primaryAsp.setValueByString(name, value);
}
configService.saveConfig(primaryAsp);

return "Done";