My Oracle Support Banner

Unable to Get Database Connection Error on Manage DVM Page in RFI (Doc ID 2680153.1)

Last updated on SEPTEMBER 08, 2020

Applies to:

Oracle Retail Integration Cloud Service - Version 19.0 and later
Information in this document applies to any platform.

Symptoms

Unable to Get Database Connection error on Manage DVM page in RFI. See the error message below:

...
2020-06-10 15:23:21,466 [[ACTIVE] ExecuteThread: '20' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG com.oracle.retail.rfi.dataaccess.dao.BaseOracleDao - EXECUTING : update RFI_XREF_DVM set CATEGORY_TYPE = ?, CATEGORY_TYPE_DESC = ?, RETL_ID = ?, EXT_SYSTEM_ID = ?, EXT_SYSTEM = ? where COMMON_ID = ?[PAYMENT_TERMS_XREF][Payment Terms][10040][1 NET 30][CFIN][200]
2020-06-10 15:23:21,466 [[ACTIVE] ExecuteThread: '20' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG com.oracle.retail.rfi.dataaccess.DataSourceThreadLocalConnFactory - getThreadLocalConnection started
2020-06-10 15:23:21,467 [[ACTIVE] ExecuteThread: '20' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG com.oracle.retail.rfi.dataaccess.DataSourceThreadLocalConnFactory - getThreadLocalConnection datasource found: weblogic.jdbc.common.internal.RmiDataSource@5a7bd9c0
2020-06-10 15:23:31,470 [[ACTIVE] ExecuteThread: '20' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR com.oracle.retail.rfi.dataaccess.DataSourceThreadLocalConnFactory - error in getThreadLocalConnection
java.sql.SQLException: Cannot obtain XAConnection
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1655) ~[com.bea.core.datasource6.jar:12.2.1.3]
...
Caused by: java.sql.SQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool RfiDataSource to allocate to applications, please increase the size of the pool and retry..
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:646)
...

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.