Wednesday, September 05, 2012

OAF Error: Exception creating new Poolable object + Io exception: The Network Adapter could not establish the connection

Case:

I have an issue when running OA page (using JDeveloper for EBS  12.1.3). I was able to create the database connection without any issue and it works fine. But when i try to run hello page(test_fwktutorial.jsp) for the first time, then error with following message:

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: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.(WebAppsContext.java:1160)
 at oracle.apps.fnd.common.WebRequestUtil.validateContext(WebRequestUtil.java:227)
 at _OAErrorPage._jspService(_OAErrorPage.java:66)
...
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.(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)
 ... 63 more

Solution:
1. Check JDeveloper version is suitable for EBS. Please refer to metalink article id 
    416708.1
2. Copy the correct .dbc file from EBS instance server
    The location $INST_TOP/appl/fnd/secure. For the alternative, open one of oaf page example in your ebs instance, then click "About Page"--> Go to page context tab menu. You can see the location of dbc on that page

In my case, my .dbc file is not correct even i have re copy from server like step no 2. And then i try to edit the database connection again and i found the strange condition.
When i use ip configuration for hostname, it's work!! But when i replace the ip configuration with hostname it's error: io exception: The NetworkI Adapter could not establish the connection

This error same as the error in OA Page. So in my opinion something configuration in network so the network does not recognize hostname.

Then i edit file .dbc in my local computer, i replace hostname,with the ip. And it's solve!! The hello page is running well

Regards

Rifky