1 Reply Latest reply on Dec 15, 2008 9:41 AM by PrazzyJay

    URGENT!! Error While Running Tutorial Test Page.

    613628
      Hi,

      We have been facing an issue while setting up the JDeveloper and running the test page.
      ERROR IS:

      Error Page

           
      Exception Details.
           
      oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = fnd; (Could not lookup message because there is no database connection)
      at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1142)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1794)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:463)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:384)
      at OA.jspService(OA.jsp:40)
      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
      at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
      at com.evermind.server.http.GetParametersRequestDispatcher.forward(GetParametersRequestDispatcher.java:189)
      at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:199)
      at OA.jspService(OA.jsp:45)
      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
      at java.lang.Thread.run(Thread.java:534)
      ## Detail 0 ##
      oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = fnd; (Could not lookup message because there is no database connection)
      at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getAppId(OAWebBeanFactoryImpl.java:3931)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:786)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:463)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:384)
      at OA.jspService(OA.jsp:40)
      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
      at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
      at com.evermind.server.http.GetParametersRequestDispatcher.forward(GetParametersRequestDispatcher.java:189)
      at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:199)
      at OA.jspService(OA.jsp:45)
      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
      at java.lang.Thread.run(Thread.java:534)
      oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = fnd; (Could not lookup message because there is no database connection)
      at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getAppId(OAWebBeanFactoryImpl.java:3931)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:786)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:463)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:384)
      at OA.jspService(OA.jsp:40)
      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
      at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
      at com.evermind.server.http.GetParametersRequestDispatcher.forward(GetParametersRequestDispatcher.java:189)
      at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:199)
      at OA.jspService(OA.jsp:45)
      at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
      at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
      at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
      at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
      at java.lang.Thread.run(Thread.java:534)

      =============================================================
      =============================================================

      The msgs that are coming up in the embedded oc4j log is:

      [Starting OC4J using the following ports: HTTP=8988, RMI=23891, JMS=9227.]

      C:\JDEV\jdevbin\jdk1.4.2\bin\javaw.exe -client -classpath C:\JDEV\jdevbin\j2ee\home\oc4j.jar;C:\JDEV\jdevbin\jdev\lib\jdev-oc4j.jar -Xbootclasspath/p:C:\JDEV\jdevbin\jdev\appslibrt\ojdbc14.jar;C:\JDEV\jdevbin\jdev\appslibrt\nls_charset12.zip -DFND_JDBC_STMT_CACHE_SIZE=200 -DCACHENODBINIT=true -DRUN_FROM_JDEV=true -mx256m -Dhttp.proxyHost=proxy.mtn.co.za -Dhttp.proxyPort=80 -Dhttp.nonProxyHosts=196.13.231.*|webmail.mtn.co.za|autodiscover.mtn.co.za|10.204.5.2|10.204.5.1|*.thecomputerpeople.co.za|virtual.thecomputerpeople.co.za|oms.thecomputerpeople.co.za|*.rentamobile.co.za|*.rentatomtom.co.za|*.mobilesolutions.co.za|*.yelloworld.co.za|*.yellostg.co.za|*.yellodev.co.za|10.217.200.91|eprowebserver.mtn.co.za|10.217.205.64|*.mtn.com|196.11.240.*|196.13.230.*|*.mtnactive.co.za|*.yellomtn.com|*.yellomtn.co.za|*.mtn.co.za -Xverify:none -Doracle.j2ee.dont.use.memory.archive=true -Doracle.j2ee.http.socket.timeout=500 com.evermind.server.OC4JServer -config C:\JDEV\jdevhome\jdev\system9.0.3.5.1312\oc4j-config\server.xml
      [waiting for the server to complete its initialization...]

      Ready message received from Oc4jNotifier.

      Embedded OC4J startup time: 1484 ms.

      Auto-deploying OA Framework web application deployment descriptor (New server version detected)...

      Oracle9iAS (9.0.3.1.0) Containers for J2EE initialized

      Tutalii: C:\JDEV\jdevbin\jdev\appslibrt\iasjoc.zip archive

      ICX DIAGNOSTIC: FND_TOP = C:\JDEV\jdevhome\jdev\dbc_files\

      ICX DIAGNOSTIC: application_id = 601

      ICX DIAGNOSTIC: responsibility_id = 24742

      ICX DIAGNOSTIC: security_group_id = 0

      ICX DIAGNOSTIC: mEncryptedSessionID = VOJ1vU0LWyvpCvPMgp0CPqNg:S

      ICX DIAGNOSTIC: mSessionID = 1874125765

      ICX DIAGNOSTIC: mTransactionID = 1962477773
      ==========================================================
      ==========================================================

      We have setup the same JDEV patch on 2 machines having the same DBC files and the same application logins as well as the same responsibility keys.
      But it is working fine on one machine and we are able to run the test page as well as any custom page that we are developing.
      but on one machine we are unable to run even the test page.
      Both are also on the same network.

      We are struck as we are unable to do any work.
      Could anyone please suggest any solution to this.
      I have gone through the numerous posts regarding this kind of error, but have not been yet able to resolve.

      Thanks
        • 1. Re: URGENT!! Error While Running Tutorial Test Page.
          PrazzyJay
          As per error message, the problem is with the Database connection.
          Check again if your using wright dbc file, you can check it through connection string given in the dbc file
          and also try connecting the database through sql developer.

          --prasanna