MII - Connections - Pool size error

[former_member607139]

Hi, In the MII Menu Data Services -> Connections there is a pool size parameter

Currently an MII transaction (BLS) that is using that connection is showing this error about the Pool size limit being reached:

[Transaction: -1] APPRISE_QNOTE_PUBLISHER/PUBLISH_QNOTE_JOB.trx - error : SAP_JCo_Start_Session_0 : Connection pool pm4app01.jdnet.deere.com:410:60:EN:mjmepp0_mii is exhausted. The current pool size limit (max connections) is 5 connections.

So, I think the solution for the error is increasing the pool size of the connection, but I just want to verify if you know the implications of that, I mean, do you know if I increase the pool size limit could that affect other things? for example the performance of the server or something like that? and what would be a recommended number for the pool size?

[agentry_src]

There is an upper limit to the number of pool connections (100-200 most frequently in my experience). Most people run into problems by setting the max pool size too high. I suggest that you check the settings in Java for the system to see how many connections are available. But in general, I think setting the max to 10 (or 20 if you still have problems) is pretty safe to do.

Cheers, Mike