Could not get connection for pool SQLConnection

,
1

Hello All,

I am constantly seeing below error on IS server logs:
wm.art.ns:executeNotification - Could not get connection for pool SQLConnection

I am not able to find which adapter connection is causing this issue.
We are having adapter connections for different databases (SQL and Sybase)

Kindly assist.

Thanks & Regards,
Khushaboo Shandilya

2

Hi Khushaboo,

did you try to disable and reenable the notifications one by one to see when the messages disappears?

Are there any further messages in the logs which might indicate which connection is affected?

Regards,
Holger

3

Hello Holger,

Thank you for your message.

I do not see any futher messages on the logs except for below:
wm.art.ns:executeNotification - Could not get connection for pool SQLConnection

Regards,
Khushaboo Shandilya

4

Hi Khushaboo,

Can you share the pool settings for this connection (min, max etc.)

When min is set to 1 you might encounter a stale connection remaining in the pool which is not useable, but IS is not able to create new connections as there is still the stale one available.
Try to set min to 0 in this case and reenable the connection.
IS will destroy the stale connection in this case and then create a new one.

Regards,
Holger

5

Hi Khushaboo,

I agree with Holger and suggest the same it would resolve the current issue

Try to set minimum to 0 in this case and re-enable the JDBC connection should fix this issue (When DB is offline or goes to any unstable state)

HTH,
RMG

6

Thank you rmg and Holger and sincere apologies for delay in responding.

Both of you are right!
Min Pool Size was indeed set to 1.
I will change it to 0 and re-enable the connection!

Many thanks for the help and guidance.

7

Sounds good!