Hello Team,
Currently in production environment, we are getting below error message on most frequently basis. Just above below error message, there is an message for PS_TXN table appears as mentioned below. Can you help us know the suggested solution for this issue? Do we need to increase connection pool size of data source? Also, do we need to clear PS_TXN table on periodic basis? Any help appreciated.
Environment details :
Weblogic 12c
Oracle ADF 12.2.1
"ApplicationDS" pool size : Max capacity : 15, Initial Capacity : 1 Minimum capacity : 1, statement cache size : 10.
Error Message :
"No resources available in the pool "ApplicationDS" to allocate to applications, please increase the size of the pool"
PS_TXN message:
"could not retrieve row from table PS_TXN collection id 2,485,128 persistence id 1"