9 Replies Latest reply: Jun 20, 2013 2:27 AM by 1011751 RSS

    500 internal server error

    1011751

      HI,

      OAF version: 10.1.3.3.0

      Oracle R12

      Database: 11g

       

      When i run the oaf, 500 internal server error occur with following log:

       

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

      at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:579)

      at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:533)

      at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:1160)

      at oracle.apps.fnd.common.WebRequestUtil.validateContext(WebRequestUtil.java:227)

      at _OAErrorPage._jspService(_OAErrorPage.java:62)

      [/OAErrorPage.jsp]

      at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.3.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)

      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)

      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)

      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)

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

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

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

      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)

      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)

      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)

      at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)

      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)

      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:847)

      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:813)

      at _runregion._jspService(_runregion.java:193)

      [/runregion.jsp]

      at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.3.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)

      at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)

      at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)

      at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)

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

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

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

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

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

      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)

      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)

      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)

      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)

      at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)

      at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)

      at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)

      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:298)

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

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

      at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1719)

      at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2314)

      at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2251)

      at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2108)

      at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1918)

      at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1762)

      at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1775)

      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)

      ... 49 more

      Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

      at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:937)

      at oracle.apps.fnd.security.AppsConnectionManager.getGwyuidConn(AppsConnectionManager.java:1016)

      at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:814)

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

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

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

      ... 62 more

      Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

      at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1522)

      at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1425)

      at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:919)

      ... 70 more

      Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:287)

      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:328)

      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:430)

      at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)

      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:608)

      at java.sql.DriverManager.getConnection(DriverManager.java:525)

      at java.sql.DriverManager.getConnection(DriverManager.java:140)

      at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1509)

      ... 72 more

       

      Pl. assist.