12.2 E-Business Suite Applications Desktop Integrator User Activity Result In The Oacore Server Showing A Warning Status For The Managed Server (Doc ID 2303183.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

Oracle Applications Desktop Integrator - Version 12.2.4 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2 Web Applications Desktop Integrator, Installation Install/Upgrade related issues

 



The oacore service is returning a Warning status for the Managed Server during Web ADI user activity.

The following Warning message is written to the oacore_server1.out during usage of the WebADI integrators:

BEA-001153

<Jan 1, 2017 8:00:03 AM CDT> <Warning> <JDBC> <BEA-001153> <Forcibly releasing inactive/harvested connection "weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@" back into the data source connection pool "EBSDataSource", currently reserved by: java.lang.Exception
at weblogic.jdbc.common.internal.ConnectionEnv.setup(ConnectionEnv.java:366)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:373)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:339)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:469)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:363)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:125)
at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:469)
at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:553)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:513)

...............................

at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:354)
at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1758)
at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2425)
at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2362)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2218)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2028)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1816)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1829)
at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1492)
at oracle.apps.bne.utilities.oa.BneOASessionUtils.getResponsibilitiesNoSecurityGroups(BneOASessionUtils.java:1858)
at oracle.apps.bne.utilities.oa.BneOASessionUtils.getReponsibilities(BneOASessionUtils.java:1787)
at oracle.apps.bne.utilities.oa.BneOASessionUtils.getAllReponsibilities(BneOASessionUtils.java:1774)
at oracle.apps.bne.webui.pageflow.BneOALoginPage2.createPage(BneOALoginPage2.java:146)
at oracle.apps.bne.webui.pageflow.BneOALoginPage.renderPage(BneOALoginPage.java:382)
at oracle.apps.bne.webui.framework.BneBasePageController.createPageBody(BneBasePageController.java:557)
at oracle.apps.bne.webui.framework.BneBasePageController.handlePage(BneBasePageController.java:288)
at oracle.apps.bne.webui.BneApplicationService.handleRequest(Unknown Source)
at oracle.apps.bne.framework.BneBajaServlet.doRequest(BneBajaServlet.java:266)
at oracle.apps.bne.framework.BneBaseServlet.doGet(BneBaseServlet.java:82)

 
The issue can be reproduced at will with the following steps:
1. Check Managed Server
2. Seeing Warning State for Managed Server.


The issue has the following business impact:
Due to this issue, oacore in warning status.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms