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
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
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?
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.
Retrieving data ...