14 Replies Latest reply on Apr 19, 2013 5:40 PM by Hussein Sawwan-Oracle

    EBS Login error - HTTP 500 internal server error

    A.Ebenezer
      Hi All,

      We are working on cloning ebs r12 application,after successfully adcfgclone.pl script, when we try to open the login page we are hitting Http 500 internal server error.

      But Autoconfig completed successfully, Please see the application log below.

      13/04/14 17:09:11.579 html: Servlet error
      java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.sso.Utils
              at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:221)
              at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:287)
              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpApplication.loadServlet(HttpApplication.java:2379)
              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4830)
              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4754)
              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2978)
              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:738)
              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
              at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
              at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
              at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
              at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:298)
              at java.lang.Thread.run(Thread.java:619)
      We have followed the metalink note ID 467562.1 and recompiled the jsps

      Also checked Troubleshooting 500 Internal Server Error in Oracle E-Business suite [813523.1] but still could not solved the issue..

      Any suggestions please...?

      Our environment:

      DB - Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
      Oracle EBS Application: 12.1.1
        • 1. Re: EBS Login error - HTTP 500 internal server error
          Srini Chavali-Oracle
          Pl see if this MOS Doc can help

          R12: Users Are Unable to Log Into Applications [ID 1497554.1]

          HTH
          Srini
          1 person found this helpful
          • 2. Re: EBS Login error - HTTP 500 internal server error
            Hussein Sawwan-Oracle
            Can you find any errors in the database log file?

            Please see (R12: On a cloned target the logon screen reports 'HTTP error 500 Internal server error' [ID 1335176.1]).

            Thanks,
            Hussein
            1 person found this helpful
            • 3. Re: EBS Login error - HTTP 500 internal server error
              Yakub
              Hi,

              Please check below note id:

              500 Internal Server Error - java.lang.NoClassDefFoundError on Login [ID 761869.1]

              Thanks,
              Yakub.
              1 person found this helpful
              • 4. Re: EBS Login error - HTTP 500 internal server error
                A.Ebenezer
                Yakub wrote:
                Hi,

                Please check below note id:

                500 Internal Server Error - java.lang.NoClassDefFoundError on Login [ID 761869.1]
                Hi,

                As per the Note id 761869.1 we have found JTF_DIST_CACHE_PORT is 12346 but in context file s_java_object_cache_port is 1235

                So we corrected it in context file from 12345 to 12346 but after the successful completion of autoconfig, the change in context file did not reflect.

                it was again back to the old value. i.e 12345.


                Any idea on this issue. The clone process we performed is we had a database backup from one server and application from another server and cloned.
                will this be any issue on HTTP 500 internal server error?
                • 5. Re: EBS Login error - HTTP 500 internal server error
                  Hussein Sawwan-Oracle
                  Where does the value change after editing it in the context file and running AutoConfig?

                  Does the context variable value match the value of JTF_DIST_CACHE profile option? -- R12: Resolving error mod_oc4j Failed To find A Failover OC4J Process For Session Request For Destination [ID 785296.1]

                  Thanks,
                  Hussein
                  • 6. Re: EBS Login error - HTTP 500 internal server error
                    A.Ebenezer
                    Hussein Sawwan wrote:
                    Can you find any errors in the database log file?

                    Please see (R12: On a cloned target the logon screen reports 'HTTP error 500 Internal server error' [ID 1335176.1]).
                    Hussien,

                    As per the note id [ID 1335176.1],
                    we already had the parameter sec_case_sensitive_logon = FALSE.
                    And also we did not notice any error in database alert log too.
                    • 7. Re: EBS Login error - HTTP 500 internal server error
                      A.Ebenezer
                      Srini,

                      From the note id you refered( 1497554.1 ),i have followed the reference note id NOTE:135389.1 to check
                      wheteher "Initialization SQL Statement - Custom" was set. And when i queried the sql statement which was mention there

                      i.e
                      SELECT val.level_id, val.level_value, val.profile_option_id,
                      val.profile_option_value
                      FROM fnd_profile_options opt,.....
                      It returns no rows selected, It didn't return any value, so can't know whether the Initialization SQL Statement - Custom was set at application level or site level.
                      • 8. Re: EBS Login error - HTTP 500 internal server error
                        A.Ebenezer
                        Hussein Sawwan wrote:
                        Where does the value change after editing it in the context file and running AutoConfig?
                        Hussein,
                        When we queried select fnd_profile.value('JTF_DIST_CACHE_PORT') from dual; it returns 12346

                        Then we checked the CONTEXT_FILE, it was like this
                        <jcache_port oa_var="s_java_object_cache_port" oa_type="PORT" base="12345" step="1" range="-1" label="Java Object Cache Port">12346</jcache_port>

                        we thought the value "base=12345" must also be 12346, so we changed it and run autoconfig but it was getting back to old value.

                        But Java object cache port is 12346

                        Is this correct ?
                        • 9. Re: EBS Login error - HTTP 500 internal server error
                          Hussein Sawwan-Oracle
                          From the note id you refered( 1497554.1 ),i have followed the reference note id NOTE:135389.1 to check
                          wheteher "Initialization SQL Statement - Custom" was set. And when i queried the sql statement which was mention there

                          i.e
                          SELECT val.level_id, val.level_value, val.profile_option_id,
                          val.profile_option_value
                          FROM fnd_profile_options opt,.....
                          It returns no rows selected, It didn't return any value, so can't know whether the Initialization SQL Statement - Custom was set at application level or site level.
                          Please run the script in (How To List E-Business Suite Profile Option Values For All Levels Using SQLPlus [ID 201945.1]) to verify if this profile option is set or not at all levels. For the profile option name, please use "FND_INIT_SQL".

                          Thanks,
                          Hussein
                          • 10. Re: EBS Login error - HTTP 500 internal server error
                            Hussein Sawwan-Oracle
                            ab8926 wrote:
                            Hussein Sawwan wrote:
                            Where does the value change after editing it in the context file and running AutoConfig?
                            Hussein,
                            When we queried select fnd_profile.value('JTF_DIST_CACHE_PORT') from dual; it returns 12346

                            Then we checked the CONTEXT_FILE, it was like this
                            <jcache_port oa_var="s_java_object_cache_port" oa_type="PORT" base="12345" step="1" range="-1" label="Java Object Cache Port">12346</jcache_port>

                            we thought the value "base=12345" must also be 12346, so we changed it and run autoconfig but it was getting back to old value.

                            But Java object cache port is 12346

                            Is this correct ?
                            base is the value with port pool = 0 so in this case the value will be 12345. If you select port pool = 1 then the value will be 12346 -- FAQ: Cloning Oracle Applications Release 11i [ID 216664.1]

                            Port Pool = 0 --> <jcache_port oa_var="s_java_object_cache_port" oa_type="PORT" base="12345" step="1" range="-1" label="Java Object Cache Port">12345</jcache_port>
                            Port Pool = 1 --> <jcache_port oa_var="s_java_object_cache_port" oa_type="PORT" base="12345" step="1" range="-1" label="Java Object Cache Port">12346</jcache_port>

                            Thanks,
                            Hussein
                            1 person found this helpful
                            • 11. Re: EBS Login error - HTTP 500 internal server error
                              A.Ebenezer
                              Hussein Sawwan wrote:

                              Please run the script in (How To List E-Business Suite Profile Option Values For All Levels Using SQLPlus [ID 201945.1]) to verify if this profile option is set or not at all levels. For the profile option name, please use "FND_INIT_SQL".
                              Hi Hussein,

                              When i run this select Script,

                              It returns as Level_set is Undefined , Please see below
                              SHORT_NAME                     NAME                                     LEVEL_SET       CONTEXT                        VALUE
                              ------------------------------ ---------------------------------------- --------------- ------------------------------ ----------------------------------------
                              FND_INIT_SQL                   Initialization SQL Statement - Custom    UnDef           UnDef
                              I Checked the note id *Using Profile Option 'Initialization SQL Statement - Custom' [ID 135389.1]* for setting this profile option to Application Level or Higher.
                              But they only mention steps to enable session level trace or logging through this profile option.

                              Can you help me, how to set this profile option to Application Level with any values as setting this profile option can solve the error

                              javax.servlet.ServletException: Could not initialize class oracle.apps.fnd.sso.Utils , As by note id ID 1497554.1


                              Thanks
                              • 12. Re: EBS Login error - HTTP 500 internal server error
                                Hussein Sawwan-Oracle
                                Can you help me, how to set this profile option to Application Level with any values as setting this profile option can solve the error
                                Please see (How to Change Profile Option Value Without Forms? [ID 943710.1]).

                                Thanks,
                                Hussein
                                • 13. Re: EBS Login error - HTTP 500 internal server error
                                  A.Ebenezer
                                  Hi All,

                                  Our Error has been resolved, Problem we had is, the Server that host R12 instance got crashed,and we had a Database backup.

                                  So we restored DB to another server and opened the database
                                  and we performed clone activity with R12 application(which we got from another instance).

                                  After Restoring Application to new server, we ran adfgclone.pl script with the Apps password of application server, so we ended up with this Error.

                                  Again we performed the clone activity and ran adcfgclone.pl (post clone step) with Apps password of DB server and atlast the error got fixed and page could open.


                                  Thanks All (Hussein, Srini & Yakub) for your help.

                                  Edited by: ab8926 on Apr 19, 2013 12:03 PM