Sunday, October 23, 2011

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

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem Description: Exception creating new Poolable object




Login to application gives :


500 Internal Server Error
oracle.apps.fnd.cache.CacheException
at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:228)
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1485)
at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:354)
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:1259)
at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1114)
at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1083)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1050)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1037)
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:1081)
at oracle.apps.fnd.sso.Utils.getAppsContext(Utils.java:539)
at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:120)
at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.loadServlet(HttpApplication.java:2232)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) .server.http.HttpApplication.findServlet(HttpApplication.java:4622)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4546) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2822) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:740) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:299) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:187) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230) at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33) at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595)Caused by: oracle.apps.jtf.base.resources.FrameworkException: Error in IAS Cache: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object. at oracle.apps.jtf.cache.IASCacheProvider.get(IASCacheProvider.java:833) at oracle.apps.jtf.cache.CacheManager.getInternal(CacheManager.java:4802) at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:4624) at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:216) ... 33 moreCaused by: oracle.apps.jtf.base.resources.FrameworkException: An exception occurred in the method CacheAccess.getnullThe base exception is:Exception creating new Poolable object. at oracle.apps.jtf.base.resources.FrameworkException.convertException(FrameworkException.java:607) at oracle.apps.jtf.base.resources.FrameworkException.addException(FrameworkException.java:585) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:66) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:88) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:202) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:218) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:249) ... 37 more



access_log.1306800000
10.1.25.56 - - [31/May/2011:10:27:09 +0400] "GET /OA_HTML/AppsLogin HTTP/1.1" 500 5672 229 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)"
10.1.25.56 - - [31/May/2011:10:47:04 +0400] "GET /OA_HTML/AppsLogin HTTP/1.1" 500 5672 152 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)"

debug.log
[May 31, 2011 10:25:19 AM GST]:1306823119991:-1:-1:erptest-temp.auh.police:130.130.100.135:oacore.default_group.2:412373572:-1:-1:ANONYMOUS(-1):-1:Thread[AJPRequestHandler-ApplicationServerThread-1,5,RequestThreadGroup]:130.130.100.135:58850:1306823010799:4:STATEMENT:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.instantiateProfileStore(): s_constructorExtendedProfileStore=public oracle.apps.fnd.profiles.ExtendedProfileStore(oracle.apps.fnd.common.AppsContext)
[May 31, 2011 10:44:34 AM GST]:1306824274840:-1:-1:erptest-temp.auh.police:130.130.100.135:oacore.default_group.1:412373571:-1:-1:ANONYMOUS(-1):-1:Thread[AJPRequestHandler-ApplicationServerThread-1,5,RequestThreadGroup]:130.130.100.135:11086:1306824274840:4:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.makeConnectionManager(class oracle.apps.fnd.security.AppsConnectionManager): : BEGIN

javacache.log
[2011-05-31T09:23:28.435+04:00] [ias] [ERROR] [] [cache] [host: erptest-temp.auh.police] [nwaddr: 130.130.100.135] [tid: 10] [userId: appltest] [ecid: 130.130.100.135:38039:1306819169749:0,7] [[
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:297)
...
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:1215)
...
... 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.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1410)
... 72 more



Explanation:


Failed to change apps password by providing wrong apps password using FNDCPASS


log file shows


FNDCPASS was not able to decrypt password for user 'GCC' during applsys password change.
FNDCPASS was not able to decrypt password for user 'APPS' during applsys password change.
FNDCPASS was not able to decrypt password for user 'APPLSYS' during applsys password change.

. . . 


Solution:


RUn FNDCPASS using the right apps password
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: