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 Community | Mussa | 7 months ago
  1. 0

    oracle.apps.fnd.framework.OAException: Illegal method call because there is no database connection.

    Oracle Community | 7 months ago | Mussa
    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]
  2. 0

    Network adaptor error

    Oracle Community | 9 years ago | 424818
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: Io exception: The Network Adapter could not establish the connection;
  3. 0

    JBO-25002: Definition of type ApplicationModule not found

    Oracle Community | 8 years ago | 598438
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25002: Definition company.oracle.apps.xxscp.lov.server.BufferStockLovAM of type ApplicationModule not found after deploying to a Quality instance. 1. Class files & XML files have been deployed . 2. I have Bounced the server as well as the oc4j container after the installation. 3. The file permissions are good . All files as well as directories have 755 . The same files work in jdeveloper and in other instances. This happens for files in a particular directory. $JAVA_TOP/<company>/oracle/apps/xxscp/lov/server All files in other directories like $JAVA_TOP/<company>/oracle/apps/xxscp/<module>/server $JAVA_TOP/<company>/oracle/apps/xxscp/<module>/webui are getting picked up. the only difference (in comparison to 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 ------------
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error-Application: null, Message Name: Developer Mode Error

    Oracle Community | 7 years ago | 737382
    oracle.apps.fnd.framework.OAException: 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 could have been caused if application code called releaseJDBCConnection() on the AppsContext object. Note that the AppsContext's JDBC connection is referenced and used by the application module's transaction. Action: Check your application code and remove calls to releaseJDBCConnection() if the AppsContext was handled out from OADBTransactionImpl.getAppsContext(). (This developer mode check cannot detect the release event, if the same connection instance got checked out again.).
  6. 0

    Error-Application: null, Message Name: Developer Mode Error

    Oracle Community | 7 years ago | 737382
    oracle.apps.fnd.framework.OAException: 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 could have been caused if application code called releaseJDBCConnection() on the AppsContext object. Note that the AppsContext's JDBC connection is referenced and used by the application module's transaction. Action: Check your application code and remove calls to releaseJDBCConnection() if the AppsContext was handled out from OADBTransactionImpl.getAppsContext(). (This developer mode check cannot detect the release event, if the same connection instance got checked out again.)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAJSPHelper.getIcxCookie
      1. oracle.apps.fnd.security.CallStack.getInstance(CallStack.java:109)
      2. oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:990)
      3. oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:973)
      4. oracle.apps.fnd.common.AppsContext.checkDedicated(AppsContext.java:500)
      5. oracle.apps.fnd.common.AppsContext.connectionBorrowed(AppsContext.java:481)
      6. oracle.apps.fnd.common.Context.borrowConnection(Context.java:1724)
      7. oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2314)
      8. oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2251)
      9. oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2108)
      10. oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1918)
      11. oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1762)
      12. oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1775)
      13. oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1453)
      14. oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:170)
      15. oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)
      16. oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:362)
      17. oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:211)
      18. oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:171)
      19. oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)
      20. oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1294)
      21. oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1149)
      22. oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1118)
      23. oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1085)
      24. oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1072)
      25. oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)
      26. oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:602)
      27. oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:579)
      28. oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:533)
      29. oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:301)
      30. oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:1147)
      31. oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:352)
      32. oracle.apps.fnd.framework.webui.OAServerDelegate.getWebAppsContext(OAServerDelegate.java:1689)
      33. oracle.apps.fnd.framework.webui.OAServerDelegate.getIcxCookieName(OAServerDelegate.java:573)
      34. oracle.apps.fnd.framework.webui.OAJSPHelper.getIcxCookieName(OAJSPHelper.java:216)
      35. oracle.apps.fnd.framework.webui.OAJSPHelper.getIcxCookie(OAJSPHelper.java:294)
      35 frames
    3. Unknown
      _OALogout._jspService
      1. _OALogout._jspService(_OALogout.java:221)
      1 frame
    4. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    5. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    7. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    8. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    9. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    10. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    11. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    12. oracle.oc4j.network
      ServerSocketAcceptHandler$AcceptHandlerHorse.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      2. oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
      3. oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
      4. oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
      4 frames
    13. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    14. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame