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]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1789

  • "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]
  • via Oracle Community by 598438, 1 year ago
    other instances) I found was in server.xml , which did not have the Files as entries. But then I thought server.xml is only used when you want to extend any objects. However I deleted the server.xml (bounced webserver &oc4j) and tried , still the same error. Any idea what could be wrong or Am I missing something. Thanks and Regards Hari ERROR STACK ------------
  • via Oracle Community by 737382, 1 year ago
    Message not found. Application: null, Message Name: Developer Mode Error - The database connection in the AppsContext object associated with the root application module's transaction has changed while the application module was in use. Cause: This
  • Stack trace

    • 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.<init>(AppsContext.java:301) at oracle.apps.fnd.common.WebAppsContext.<init>(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 _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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.