5 Replies Latest reply: Jan 24, 2013 2:45 AM by D.Ram RSS

    Got the 500 Internal Server Error while running OAF page

    Madhav.T.Reddy
      Hi

      I am got the below exception while running my OAF page
      500 Internal Server Error
      oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException:
      Not able to create new database connection: FNDSECURITY_APPL_SERVER_ID

      I Have place the my .dbc file in <<OAF JDev home>jdev/dbcfiles/security
      I am able to create the DB with .dbc file entries.

      Please help me on this.

      Thanks,
      Madhava .
        • 1. Re: Got the 500 Internal Server Error while running OAF page
          Sushant Sharma
          Hi,

          Recheck username, password, responsibility from project properties.
          Also check if you have done these steps: http://sushantsharmaa.blogspot.in/2012/09/jdeveloper-setup-for-oa-framework.html

          --Sushant                                                                                                                                                                                                                                                                                                                                                                                                                                   
          • 2. Re: Got the 500 Internal Server Error while running OAF page
            Madhav.T.Reddy
            Thanks your reply.
            I am configured my OAF JDev based on your blog steps.
            I am able to successful run the OA_HTML/test_fwktutorial.jsp page of toolbox tutorial ,but when i am click any link like HelloWorld,Search & DrillDown etc link it will open the my EBS istance login page after loging it's open the EBS home page
            It's happen same in my own OAF page as well.
            when i right click my any OAF page and run it's open my EBS instache page(http://10.200.178.166:8988/OA_HTML/runregion.jsp).
            is any configurations i missed out?
            Please help me onthis.

            Thanks,
            Madhava
            • 3. Re: Got the 500 Internal Server Error while running OAF page
              Sushant Sharma
              Hi,

              What is OAF version? Did you cross check the JDev patch you are using for your instance ?

              --Sushant                                                                                                                                                                                                                           
              • 4. Re: Got the 500 Internal Server Error while running OAF page
                Madhav.T.Reddy
                Hi ,

                My OAF Jdev version :-Studio Edition Version 10.1.3.3.03
                Installed Oracle EBS version - R12.1.3

                According Oracle EBS version - R12.1.3 requries p9879989_R12_GENERIC patch.
                When i am running My oaf page it's open EBS instance home page , the opned EBS isntance is not my configured EBS isntance
                I am not understanding where it's pick up this URL:- http://10.200.178.175:8988/OA_HTML/runregion.jsp
                My EBS instance Ip is:- 10.240.206.18

                Below is my .dbc files

                #DB Settings
                #Thu Dec 29 12:30:44 IST 2011
                GUEST_USER_PWD=GUEST/ORACLE
                APPL_SERVER_ID=B4AAAD72EAA553E0E040F00A12CE23D611393538614093026453177252362826
                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\=(ADDRESS_LIST\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS\=(PROTOCOL\=tcp)(HOST\=indcldtc05.accenture.com)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=VCPVIS2)))
                FND_JDBC_STMT_CACHE_SIZE=100
                TWO_TASK=VCPVIS2
                JDBC\:oracle.jdbc.maxCachedBufferSize=358400
                JDBC\:processEscapes=true
                FND_MAX_JDBC_CONNECTIONS=500
                FND_JDBC_USABLE_CHECK=false
                FNDNAM=APPS
                FND_JDBC_PLSQL_RESET=false
                DB_PORT=1521
                FND_JDBC_CONTEXT_CHECK=true
                FND_JDBC_BUFFER_DECAY_SIZE=5
                DB_HOST=indcldtc05.accenture.com

                Could you plz help on this,i am new to oAF &EBS.

                Thanks,
                Madhava
                • 5. Re: Got the 500 Internal Server Error while running OAF page
                  D.Ram
                  May be you are using wrong/old DBC file. Confirm with your DBA for the DBC file you are using. Your DBC file have the APPL_SERVER_ID. If your DB Box (Machine) changed then the server id will also changes.

                  Also make sure that your DBC file don't have Junk characters.

                  Regards,
                  Ram