2 Replies Latest reply on May 5, 2015 6:52 AM by 2634558

    Oracle R12.1.1 issue with blank page after login page redirection

    2634558

      We have two application tier nodes running IBM AIX servers. We keep getting this issue of login page going blank after re-direction to OA_HTML/AppsLogin page.

       

      Our observation is, the requests reaching one particular appl node, will end up in this error during the problem time. If request reaches the healthy node, it works perfectly fine. Pasted the error in application.log of that node.

      If we do oacore bounce in that server, everything works fine. Can you please help on this issue.

       

      This is some problem with multi-application nodes. All our test instances are single appl & single DB, this problem never occurs in test instances.

       

      15/05/03 16:33:29.200 html: chain failed

      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.AppsLoginRedirect.doGet(AppsLoginRedirect.java:350)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)

              at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)

              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)

              at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)

              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)

              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)

              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)

              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)

              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)

              at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.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.5.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

              at java.lang.Thread.run(Thread.java:736)

      Caused by: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.

              at oracle.apps.fnd.common.AppsException.<init>(AppsException.java:114)

              at oracle.apps.fnd.common.Pool.createObject(Pool.java:1258)

              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:1451)

              at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:170)

              at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)

              ... 32 more

      Caused by: java.lang.NullPointerException

              at oracle.jdbc.driver.T4CTTIiov.unmarshalV10(T4CTTIiov.java:199)

              at oracle.jdbc.driver.T4C8Oall.readIOV(T4C8Oall.java:544)

              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:281)

              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

              at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)

              at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

              at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)

              at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)

              at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)

              at oracle.apps.fnd.security.AppsConnectionManager.getEncApplsysPwd(AppsConnectionManager.java:1355)

              at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1216)

              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:783)

              at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:228)

              at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source)

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)

              at java.lang.reflect.Constructor.newInstance(Constructor.java:527)

              at oracle.apps.fnd.common.Pool.createObject(Pool.java:1273)

              ... 45 more