Using the new 10.5 APMSQL Server feature the MOM log shows "AGCSmartstoreControllerImpl: Maximum number of connections reached: 5". Which property controls this connection limit.

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• INTROSCOPE

Issue/Introduction

Using the new APMSQL Server feature in 10.5 the MOM log shows:

AGCSmartstoreControllerImpl: Maximum number of connections reached: 5

Environment

APM 10.5.x

Resolution

In the EM/MOM IntroscopeEnterpriseManager.properties file is the new property "introscope.enterprisemanager.restapi.sql.connectionLimit" which defaults to a value of 5 i.e.

# If value of this property is set to positive number then

# APM Data SQL rest api will be limited to number of paralel connections.

# Otherwise transfer is unlimited.

# Default value: 5

#introscope.enterprisemanager.restapi.sql.connectionLimit=5

Uncomment the property & increase it, or set to 0 to allow unlimited connections.

 

Where there is a cluster, the property needs to be updated on the MOM and all collectors

Additional Information

Release Notes > 10.5 features > CA APMSQL