DX Application Performance Management

Hi Team

Anyone has already seen this message in the EM logs (MOM) ?

 - AGCSmartstoreControllerImpl: Maximum number of connections reached: 5

Which is the property to increase this parameter?

Thanks and Regards

Antonello

Hi Antonello,

In the EM/MOM IntroscopeEnterpriseManager.properties file is the property "introscope.enterprisemanager.restapi.sql.connectionLimit" 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

It seems like it defaults to 5 when not set so please try to uncomment the property & increase it, or set to 0 which should mean unlimited based on above comments.

Hope that helps

Regards,

Lynn

Thanks for this.  I noticed in development that when testing I hit the limit of 5, I can get around this by killing the APMSQLServer process and starting it, even though I am not running queries in the background or even have a connection opened.

I don't know if the connections exist, but is there a timeout or a way that these connections could be killed after inactive use?

Hi Earl,

Please see this related thread: APMSQL - Broken connections 

The old/idle/zombie connection timeout may be controlled by the tcp/ip stack settings on the OS although in above thread user had to use tcpkill.

Regards,

Lynn