7 Replies Latest reply: Jul 3, 2013 12:49 AM by JayaManasa RSS

    Not able to run a OA page from jdeveloper

    943958

      Hi,

       

      I am getting the below error when i run the page from jdeveloper from my local machine. It says invalid user name and password. But i have given a valid user_name and password

       

      Please help me to resolve this error.

       

      Note: recently our DB passwords are made case sensitive.

       

      500 Internal Server Error

      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.WebAppsContext.<init>(WebAppsContext.java:1140)
           at oracle.apps.fnd.common.WebRequestUtil.validateContext(WebRequestUtil.java:225)
           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:583)
           at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:300)
           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)
           ... 49 more
      Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
           at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1423)
           at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1218)
           at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1113)
           at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1102)
           at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:787)
           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: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
           at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:647)
           at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
           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:1410)
           ... 72 more

       

      Regards,

      Berchmans