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.

Document ID : KB000014426
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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
Answer:

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.

Additional Information: