Connection Leak when enabling the auditing in 12.2.7
(Doc ID 2465067.1)
Last updated on JUNE 21, 2023
Applies to:
Oracle E-Business Suite Performance - Version 12.2.7 and laterInformation in this document applies to any platform.
Symptoms
Oacore logs shows below exception :
Caused By: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1289)
at oracle.apps.fnd.security.DBConnObjWLSDSPool.borrowObjectX(DBConnObjWLSDSPool.java:173)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:597)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:400)
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.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:185)
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1504)
at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:366)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(Unknown Source)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(Unknown Source)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(Unknown Source)
at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1294)
at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1149)
at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1118)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1085)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1072)
at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)
at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:611)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:588)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:542)
at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:304)
at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:946)
at oracle.apps.fnd.common.ThreadContext.getWebAppsContext(ThreadContext.java:146)
at oracle.apps.fnd.security.ResourceAudit.<init>(ResourceAudit.java:144)
at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:157)
Changes
This issue started with E-Business suite 12.2.7 and higher.
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 |