SQL PI errors "Cannot get a connection, pool error Timeout waiting for idle object​" in agent log files (4227767)

An error in found in the agent logs not being able to get the collection when submitting data to the PI repository.

DMV sampler log timeout errors may occur about once every 30 minutes in agent logs. It runs fine every one second at other times and may not indicate a data gap or loss. Errors occurring sporadically may be deemed unimportant and can be "ignored"

RESOLUTION 1

Restart the Agent Manager

RESOLUTION 2 :

Enhancement FOG-347 was created to add a new hidden Agent Status Property (ASP) value to reduce the number of open sessions in the monitored instance has been added in Foglight 6.0 and higher.
 

Run this groovy script in the Script Console to change PI Sampler's query timeout at the database agent level.

• Do not set the "queryTimeout" value to more than 20
• Enter the agent name in the agentName field.

/**  The below variables are available to scripts:
*  scope              - the selected topology object in    parent page, null if   it   does not represent
*  specificTimeRange  -  the current specific time range from time range selector
*  functionHelper     - the FunctionHelper instance for getting other information, see the Web Component Framework Documentation
*  log                - a   Log instance
*  server             - the ServerAnchor instance to retrieve public service, see the Service Layer Documentation
*  out                -  the output stream
*/

/**
*  Change PI Sampler's query timeout
**/

configService =    server.get("ConfigService");
agentService = server.get("AgentService");

//input agent name
agentName =    " ";

//Set query timeout to 10
queryTimeout =    "10";

output=""

def modifyAgentPropertiesPrimary() {

	def primary = configService.getAgentInstancePrimaryAsp(agent.getAgentNamespace(), agent.getTypeId(), agent.getId());
	primary.setValueByString("paecQueryTimeoutSeconds", queryTimeout);configService.saveConfig(primary);
	output =    "Query timeout: "+primary.getString("paecQueryTimeoutSeconds")+" seconds"
}

def getAgentByName() {
	agents =    agentService.findByName(agentName);
	if   ((agents != null) && (agents.size() > 0)) {
		return agents.get(0);
	}   else {
		return null;
	}
}

agent =    getAgentByName();
if   (agent != null){
	modifyAgentPropertiesPrimary();
}   else  {
	return "Agent '" +    agentName +    "'   not found" ;
}
return output;

RESOLUTION 3

Enhancement FOG-3662 has been logged to reduce the frequency of logging DMV Sample failures in future releases of the SQL Server, MySQL PI, Azure SQL, and Oracle cartridges.

RESOLUTION 4

Try to reduce the number of open sessions in the monitored instance.