For hosted customers please raise a new case online and reference the title of this article.
For non-hosted:
It is recommended that the connection pool maximum capacity for the production Mosaic database data source should be set to 150.
If, however, you are a large user of Mosaic and see the following errors occur in the framework log then this should be increased
Error:
' weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool mosprodDS to allocate to applications, please increase the size of the pool and retry.'
It is recommended that the maximum capacity is increased in increments of 50 and then monitored over time. It is also worth noting that the data source connection pool can be exceeded as a result of STUCK threads. If this is the case, then an investigation into the cause of the STUCK threads should be carried out first.
How to increase the connection pool maximum capacity in Weblogic
In Weblogic navigate to Services - Data Sources from the left hand menu structure.
Select the data source for the Mosaic database with the JNDI Name OracleDS.
Click on the Connection Pool tab.
Change the value of the Maximum Capacity. For e.g. if it is set to 150 change to 200.
Click the Save button.
📌 Note: If Mosaic is load balanced i.e. more than one app server, then repeat the above on all app servers.