oracle.apps.fnd.framework.OAException: Illegal method call because there is no database connection.
However, we were able to log in when I bounced the applications. I think this might be a temporary solution. What I need
is a permanent solution by identifying the cause o the problem and solving it.
I did my search and what I found is below . If you have come across this error before and your workaround worked successfully
then you are welcome to share your experience here.
Causes according the article below:
http://ora-players.blogspot.com/2011/08/oracleappsfndframeworkoaexception.html
1)
The root cause of the issue is that there was no database connection available to service your request.
2)
The most likely cause of that issue is that we are leaking JDBC connections.
3)
However it can also occur when the database is overloaded and unable to process our request quickly enough.
Regarding to the causes above:
1)
There was a database connection
at the time of error (Database , DB listener, Apps listener were up and running).
2)
I w
ent to system administration
-->
Diagnostic -->
AOL/J Database Connection Pool Status
Then
AOL/J Database Connection Pool Status
page appears with some statistics:
leaked connections : 82
locked connections: 16
Double clicking on "leaked connections" shows some exception message as below :
AOL/J Database Connection Pool Status
April 27, 2016 3:02:12 PM AST
Top of Form
oracle.apps.fnd.security.LeakedConnectionException 1, 0x100124f, 2016-04-27+08:34:46.227+0300, Thread[AJPRequestHandler-HTTPThreadGroup-3,5,HTTPThreadGroup]

oracle.apps.fnd.framework.OAException: Illegal method call because there is no database connection.
However, we were able to log in when I bounced the applications. I think this might be a temporary solution. What I need
is a permanent solution by identifying the cause o the problem and solving it.
I did my search and what I found is below . If you have come across this error before and your workaround worked successfully
then you are welcome to share your experience here.
Causes according the article below:
http://ora-players.blogspot.com/2011/08/oracleappsfndframeworkoaexception.html
1)
The root cause of the issue is that there was no database connection available to service your request.
2)
The most likely cause of that issue is that we are leaking JDBC connections.
3)
However it can also occur when the database is overloaded and unable to process our request quickly enough.
Regarding to the causes above:
1)
There was a database connection
at the time of error (Database , DB listener, Apps listener were up and running).
2)
I w
ent to system administration
-->
Diagnostic -->
AOL/J Database Connection Pool Status
Then
AOL/J Database Connection Pool Status
page appears with some statistics:
leaked connections : 82
locked connections: 16
Double clicking on "leaked connections" shows some exception message as below :
AOL/J Database Connection Pool Status
April 27, 2016 3:02:12 PM AST
Top of Form
oracle.apps.fnd.security.LeakedConnectionException 1, 0x100124f, 2016-04-27+08:34:46.227+0300, Thread[AJPRequestHandler-HTTPThreadGroup-3,5,HTTPThreadGroup] at oracle.apps.fnd.security.CallStack.getInstance(CallStack.java:109) at oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:990) at oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:973) at oracle.apps.fnd.common.AppsContext.checkDedicated(AppsContext.java:500) at oracle.apps.fnd.common.AppsContext.connectionBorrowed(AppsContext.java:481) at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1724) at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2314) at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2251) at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2108) at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1918) at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1762) at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1775) at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1453) at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:170) at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500) at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:362) at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:211) at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:171) at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148) 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:602) at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:579) at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:533) at oracle.apps.fnd.common.AppsContext.(AppsContext.java:301) at oracle.apps.fnd.common.WebAppsContext.(WebAppsContext.java:1147) at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:352) at oracle.apps.fnd.framework.webui.OAServerDelegate.getWebAppsContext(OAServerDelegate.java:1689) at oracle.apps.fnd.framework.webui.OAServerDelegate.getIcxCookieName(OAServerDelegate.java:573) at oracle.apps.fnd.framework.webui.OAJSPHelper.getIcxCookieName(OAJSPHelper.java:216) at oracle.apps.fnd.framework.webui.OAJSPHelper.getIcxCookie(OAJSPHelper.java:294) at undefined._OALogout._jspService(_OALogout.java:221) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234) at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29) at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:619)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.