1 2 Previous Next 15 Replies Latest reply on Jun 28, 2007 10:42 AM by 518974

    OA framework Error

    user582322
      hi all

      i m trying to run hello world page .

      i have cheked username/pwd, connection, responsibility key(FWK_TBX_TUTORIAL),application short name(AK), dbc file in secure folder.

      but still getting this error when i run the page..



      oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = null; (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.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 = null; (Could not lookup message because there is no database connection)
      at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getAppId(OAWebBeanFactoryImpl.java:3879)
      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.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 = null; (Could not lookup message because there is no database connection)
      at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getAppId(OAWebBeanFactoryImpl.java:3879)
      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.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)


      pls help
        • 1. Re: OA framework Error
          555256
          Do you have multiple connections in Jdev, if yes, please confirmur using is the right one !This error basically suggests that you do not have valid database connection.Also check you have put the correct DBC file removing ' \'!
          --Mukul                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
          • 2. Re: OA framework Error
            user582322
            Hi Mukul,

            Under project settings this is the dbc file i am using
            C:\J2EE\p4573517_11i_GENERIC\jdevhome\jdev\dbc_files\secure\hpuxdb03_int6.dbc

            and contents of file are:
            #DB Settings
            #Thu May 10 23:59:10 EDT 2007
            GUEST_USER_PWD=GUEST/ORACLE
            APPL_SERVER_ID=2ADD1289C38054BBE044001321EAA99F23311126552205133110563661372428
            FND_JDBC_BUFFER_DECAY_INTERVAL=300
            APPS_JDBC_DRIVER_TYPE=THIN
            FND_JDBC_BUFFER_MIN=1
            GWYUID=APPLSYSPUB/PUB
            FND_JDBC_BUFFER_MAX=5
            APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=tcp)(HOST\=hpuxdb03.diebold.com)(PORT\=1556)))(CONNECT_DATA\=(SID\=int6)))
            FND_JDBC_STMT_CACHE_FREE_MEM=TRUE
            FND_JDBC_STMT_CACHE_SIZE=200
            TWO_TASK=int6
            FND_MAX_JDBC_CONNECTIONS=500
            FND_JDBC_USABLE_CHECK=false
            FNDNAM=apps
            FND_JDBC_PLSQL_RESET=false
            DB_PORT=1556
            FND_JDBC_CONTEXT_CHECK=true
            FND_JDBC_BUFFER_DECAY_SIZE=5
            DB_HOST=hpuxdb03.diebold.com

            I have tested the connectiona nd it shows success!!

            Mukul can you please let me know if i have to correct some thing , I really appreciate your help.

            Thanks,
            Sarath
            • 3. Re: OA framework Error
              555256
              Hi,
              Basically you have to remove back slashes from
              APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=tcp)(HOST\=hpuxdb03.diebold.com)(PORT\=1556)))(CONNECT_DATA\=(SID\=int6)))
              like
              APPS_JDBC_URL=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=hpuxdb03.diebold.com)(PORT=1556)))(CONNECT_DATA=(SID=int6)))

              and you are done! :)
              Basically these back slashes crept in because dbc file is generated in unix server, where it puts it to understand the path. Its not required in your local jdev.
              --Mukul                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
              • 4. Re: OA framework Error
                user582322
                Hi,

                I am not sure why even after removing the trailing back slashes i still get the same kind of error. can you please help
                • 5. Re: OA framework Error
                  555256
                  Check carefully have you removed all slashes and files is saved. Just check, r u referring this dbc file only in jdev.
                  --Mukul                                                                                                                                                                                                                                                                                               
                  • 6. Re: OA framework Error
                    user582322
                    I have verifed there are no trailing back slashes , I am new to Jdeveloper. Is there any thing i need to check to make this work i have followed all steps mentioned in developer guide to run hello world page.
                    • 7. Re: OA framework Error
                      518974
                      Can you verify the file runregion_params.txt under <JDEV_USER_HOME>\myhtml\OA_HTML dir and see what is the value for the parameter "akAppShortName" and ensure that this is a valid application in your apps instance?
                      • 8. Re: OA framework Error
                        518974
                        Mukul,
                        Just a while ago, I was going through some docs and something interesting caught my eyes, the use of backslash in the jdbc_url parameter of the dbc file. I should admit never bothered about this earlier.
                        As the dbc file is basically a java property file, the contents of the file are simple name value pairs represented by name=value. Now the case of representing the jdbc_url as a name=value is a tricky one as the value would internally have "=" within it. Hence to escape them the "\" is used.
                        After reading the doc. I got the impression that the "\=" is required in the dbc file.
                        Does it really work fine, if they are removed?
                        • 9. Re: OA framework Error
                          user582322
                          I have verified AK is valid application, Below are the details of then file.

                          JRAD_XML_PATH=C\:\\J2EE\\p4573517_11i_GENERIC\\jdevhome\\jdev\\myclasses\\JRADXML
                          akUsername=yalamas
                          akAppShortName=AK
                          akOpts1=OADiagnostic;OADeveloperMode
                          akOpts0=OABackButtonTestMode;OAPassivationTestMode;OADumpUIXTree;OAConnectionTestMode
                          JRADStartTime=1182972453230
                          page=/Oracle/apps/ak/hello/webui/HelloWorldPG
                          akDbcFile=hpuxdb03_int6
                          akPassword=welcome123
                          akRespKey=FWK_TBX_TUTORIAL
                          • 10. Re: OA framework Error
                            518974
                            page=/Oracle/apps/ak/hello/webui/HelloWorldPG
                            shouldn't it be
                            page=/oracle/apps/ak/hello/webui/HelloWorldPG
                            • 11. Re: OA framework Error
                              555256
                              Mani,
                              I have never came to a scenario, where on local jdev, ur dbc file with back slashes will work, it will always go into error.

                              You are right , saying
                              "As the dbc file is basically a java property file, the contents of the file are simple name value pairs represented by name=value. Now the case of representing the jdbc_url as a name=value is a tricky one as the value would internally have "=" within it. Hence to escape them the "\" is used"
                              But this is needed only on server because its a unix machine. Most of use windows for jdev, there jdev cannot interpret these excape characters, so they have to be removed! Have you never faced that issue?

                              --Mukul

                              Message was edited by:
                              Mukul Gupta
                              • 12. Re: OA framework Error
                                557833
                                Could you please check the Jdev log window and see what are the values coming for ICX profiles?

                                --Shiv                                                                                                                                                                                                                   
                                • 13. Re: OA framework Error
                                  557833
                                  Also give it a try to create a simple page project with a user and responsibility of your own different from the default AK user.

                                  This was what I found in one of the earlier threads with respect to a particular rup, haven't tested it though. Worth checking it.

                                  ---------------------------
                                  The problem appears to be when people are following the OA Toolbox Tutorial to the letter (as they should!). The apps user 'FWKTESTER' does not have the correct responsibility assigned to it (the responsibility key is correct but the application is wrong [Application=Demo Order Entry (AOL Class)].

                                  The correct responsibility should be:
                                  OA Framework ToolBox Tutorial Labs [Application=Common Modules-AK]
                                  OA Framework ToolBox Tutorial [Application=Common Modules-AK]
                                  -----------------------------

                                  --Shiv                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                  • 14. Re: OA framework Error
                                    518974
                                    Mukul,
                                    Thanks for your comments on this one. Made me really think a bit and go back to basics (try with a sample code) :)

                                    Used jdk1.4.2 with the following properties file on Windows and Linux machines, here are the observations

                                    Properties File
                                    Prop1=Prop1Value\=a\=b\=c\=c\=d
                                    Prop2=asd

                                    Java Code
                                    import java.util.Properties;
                                    import java.io.InputStream;
                                    import java.io.FileInputStream;

                                    public class Test
                                    {
                                         public static void main (String[] args)
                                         {
                                              try
                                              {
                                                   InputStream is = new FileInputStream("myprop.properties");          
                                                   Properties prop = new Properties();
                                                   prop.load(is);
                                                   System.out.println("ASD : " + prop.getProperty("Prop1"));          
                                              }
                                              catch (Exception e)
                                              {
                                                   e.printStackTrace(System.err);
                                              }
                                         }
                                    }
                                    Output in both the Windows and Linux machines
                                    ASD : Prop1Value=a=b=c=c=d

                                    Interesting isn't it?
                                    1 2 Previous Next