3 Replies Latest reply on Jul 27, 2011 6:17 PM by Hussein Sawwan-Oracle

    The website cannot display the page HTTP 500

    685292
      Hi All,

      I had an issue with OA Framework. I was told to look into logs, where I found out what was posted in below thread.

      Error: Cannot Display Page  - Transaction context is lost...

      Unfortunately nobody replied to me, so I started looking for solution on my own. I found a metalink note 1089197.1 (fix was for same error I had in my logs). Unfortunately after applying I can't even open login page. All services are up and running, database is accesible through sqlplus or developer. I have below error in application.log:

      11/07/27 17:39:34.468 html: Servlet error
      java.lang.ExceptionInInitializerError
           at oracle.apps.fnd.sso.Utils.<clinit>(Utils.java:664)
           at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:116)
           at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170)
           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:303)
           at java.lang.Thread.run(Thread.java:619)
      Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
           at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1509)
           at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:362)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:211)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:171)
           at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)
           at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1294)
           at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1149)
           at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1118)
           at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1085)
           at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1072)
           at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)
           at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:593)
           at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:570)
           at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:524)
           at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:292)
           at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:1095)
           at oracle.apps.fnd.sso.Utils.getAppsContext(Utils.java:539)
           at oracle.apps.fnd.sso.SessionMgr.loadInstalledLanguages(SessionMgr.java:3875)
           at oracle.apps.fnd.sso.SessionMgr.getInstalledLanguages(SessionMgr.java:3693)
           at oracle.apps.fnd.sso.Utils.getBaseInstalledLangCode(Utils.java:1476)
           at oracle.apps.fnd.sso.Authenticator.<clinit>(Authenticator.java:45)
           ... 17 more
      Caused by: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
           at oracle.apps.fnd.common.Pool.createObject(Pool.java:1286)
           at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1027)
           at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:584)
           at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:301)
           at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1719)
           at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2266)
           at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2203)
           at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2061)
           at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1871)
           at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1715)
           at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1728)
           at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1453)
           at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:170)
           at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)
           ... 37 more
      Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28000: the account is locked

           at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1423)
           at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1241)
           at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1136)
           at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1125)
           at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:788)
           at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:228)
           at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
           at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
           at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
           at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
           at oracle.apps.fnd.common.Pool.createObject(Pool.java:1273)
           ... 50 more
      Caused by: java.sql.SQLException: ORA-28000: the account is locked

           at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
           at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
           at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:799)
           at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
           at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:510)
           at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
           at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
           at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
           at java.sql.DriverManager.getConnection(DriverManager.java:582)
           at java.sql.DriverManager.getConnection(DriverManager.java:154)
           at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1410)
           ... 60 more

      It says that some account was locked, but which? Is this the reason that I cannot even open login page?

      Regards
      Piotr
        • 1. Re: The website cannot display the page HTTP 500
          Hussein Sawwan-Oracle
          Piotr,
          Caused by: java.sql.SQLException: ORA-28000: the account is locked
          Most probably it is APPS/APPLSYS account.

          Issue the following and check then:
          SQL> alter user apps account unlock;
          
          SQL> alter user applsys account unlock;
          Cloning Failed With ORA-28000 The account is locked [ID 1114244.1]
          APPS User Get Locked While Applying Patch And Patch Fail With ORA-28000 [ID 420001.1]

          Thanks,
          Hussein
          • 2. Re: The website cannot display the page HTTP 500
            685292
            Hi Hussein,

            I have just realized I did this already and error is different now:

            11/07/27 19:13:05.406 html: Error initializing servlet
            java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.sso.Utils
                 at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:116)
                 at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170)
                 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 com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
                 at java.lang.Thread.run(Thread.java:619)
            11/07/27 19:13:05.406 html: Servlet error
            java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.sso.Utils
                 at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:116)
                 at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170)
                 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 com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
                 at java.lang.Thread.run(Thread.java:619)

            Regards
            Piotr
            • 3. Re: The website cannot display the page HTTP 500
              Hussein Sawwan-Oracle
              This seems to be an OAF issue, so please update your other thread and close this one -- Re: The website cannot display the page HTTP 500

              Thanks,
              Hussein