7 Replies Latest reply: Nov 13, 2012 4:41 PM by Hussein Sawwan-Oracle RSS

    HTTP 500 Internal Server Error while starting AppsTier post-clone

    user4434301
      Hello,

      Adcfgclone scripts on both DB and App Tiers, as well as Adautocfg scripts, complete successfully but I am faced with a "HTTP 500 Internal Server Error" and "The website cannot display the page" through IE when starting R12 Apps post clone. So far I have run a script on the cloned environment to synchronize the Workflow tables with APPS user, and re-ran autoconfig on both DB and App Tiers, but I still see the 500 error.

      Any other pointers? Thanks in advance!
        • 1. Re: HTTP 500 Internal Server Error while starting AppsTier post-clone
          Hussein Sawwan-Oracle
          Adcfgclone scripts on both DB and App Tiers, as well as Adautocfg scripts, complete successfully but I am faced with a "HTTP 500 Internal Server Error" and "The website cannot display the page" through IE when starting R12 Apps post clone. So far I have run a script on the cloned environment to synchronize the Workflow tables with APPS user, and re-ran autoconfig on both DB and App Tiers, but I still see the 500 error.

          Any other pointers? Thanks in advance!
          What does "adopmnctl.sh status" return?

          The error you are getting "HTTP 500 Internal Server Error" is a generic one, please check Apache log files and the application.log file for details about the error.

          R12: Troubleshooting 500 Internal Server Error in Oracle E-Business suite [ID 813523.1]
          Http 500 : Internal Server Error When Login To A New Cloned Environment [ID 781413.1]

          Also, please confirm that you have no errors in the database log file.

          Thanks,
          Hussein
          • 2. Re: HTTP 500 Internal Server Error while starting AppsTier post-clone
            user4434301
            You are running adopmnctl.sh version 120.6.12010000.5

            Checking status of OPMN managed processes...

            Processes in Instance: ebstst_p10tst10.p10tst10.psft.upmc.edu
            --------------------------------------------------------------+---------
            ias-component | process-type | pid | status
            --------------------------------------------------------------+---------
            OC4JGroup:default_group | OC4J:oafm | 4587746 | Alive
            OC4JGroup:default_group | OC4J:forms | 8847360 | Alive
            OC4JGroup:default_group | OC4J:oacore | 9961586 | Alive
            HTTP_Server | HTTP_Server | 105515~ | Alive


            adopmnctl.sh: exiting with status 0


            I will review the notes below...
            • 3. Re: HTTP 500 Internal Server Error while starting AppsTier post-clone
              user4434301
              One thing I did do was to connect to the JSP/FND/aoljtest.jsp page and found the following under the Verify Guest Settings section...it probably is not good:


              Checking guest user/password in DBC file ... Guest : GUEST/ORACLE

              GUEST user successfully validated in DBC file .

              Checking guest user/password in Vault ... Guest : GUEST/ORACLE

              GUEST user successfully validated in Vault.

              If the application release is 12.1 or above then ignore the following profile check.

              Checking guest user/password in Profiles ... Guest : null

              ERROR:Failed to validate GUEST user in Profiles.

              Next (Make an AOL/J Connection)
              • 4. Re: HTTP 500 Internal Server Error while starting AppsTier post-clone
                user4434301
                Also...813523.1 is the script which I referenced on the cloned environment to synchronize the Workflow tables with APPS user
                • 5. Re: HTTP 500 Internal Server Error while starting AppsTier post-clone
                  Hussein Sawwan-Oracle
                  Checking guest user/password in Profiles ... Guest : null

                  ERROR:Failed to validate GUEST user in Profiles.

                  Next (Make an AOL/J Connection)
                  Please set the profile option as per (How To Set A System Profile Value Without Logging In To The Applications [ID 364503.1]) and check then.

                  Thanks,
                  Hussein
                  • 6. Re: HTTP 500 Internal Server Error while starting AppsTier post-clone
                    user4434301
                    I was able to finally view and log into Apps after I ran the following on the Apps Tier:

                    cd $FND_TOP/patch/115/bin
                    ojspCompile.pl compile flush

                    I still think I may have issues with the Guest login, however...

                    SQL> select profile_option_name from fnd_profile_options_tl where user_profile_option_name like 'Guest%';

                    no rows selected
                    • 7. Re: HTTP 500 Internal Server Error while starting AppsTier post-clone
                      Hussein Sawwan-Oracle
                      user4434301 wrote:
                      I was able to finally view and log into Apps after I ran the following on the Apps Tier:

                      cd $FND_TOP/patch/115/bin
                      ojspCompile.pl compile flush

                      I still think I may have issues with the Guest login, however...

                      SQL> select profile_option_name from fnd_profile_options_tl where user_profile_option_name like 'Guest%';

                      no rows selected
                      If you can login to the application and access it with no issues, then you do not need to set any profile option.

                      Thanks,
                      Hussein