SOI console Internet connection pool error

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

POST Windows security patching SOI console is unresponsive and gives an empty error message

Logs show error below:

Error while getting transaction:The internal connection pool has reached its maximum size and no connection is currently available!

Environment

Release : 4.2

CA Service Operations Insight

Cause

This error usually happens on Issues with the DB connection pool, resources not released/reused quickly enough.

Resolution

Update to the latest patch level found here:

https://support.broadcom.com/web/ecx/support-content-notification/-/external/content/release-announcements/CA-Service-Operations-Insight-Solutions--Patches/6500?r=2

Increase the size of the connection pool limit in the 
<SOI_MANAGER_HOME>\tomcat\lib\hibernate.cfg.xml 

<!-- <property name="connection.pool_size">

The recommended size is 200.

Restart the SOI manager and components using our KB article below 

https://knowledge.broadcom.com/external/article?articleId=135251