Java Workflow Mailer does not startup

Issue:


The Java Workflow Mailer does not startup. The following error message is recorded in the log file - "Exception in static block of jtf.cache.appsimpl.AppsCacheLogger. Stack trace is: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object."

Symptoms, Troubleshooting and Fix:

We started seeing this issue when we were validating various components of Oracle Apps in our newly upgraded environment. We had just finished upgrading from 11.5.8 to 11.5.10.2. The workflow mailer would not come up and I started troubleshooting the issue. I observed that all Java based managers like SFM event manager, Workflow Agent Listener etc were not working and the problem was not limited to workflow mailer alone.

As part of 11.5.10.2 upgrade, we had upgraded the tech stack components as well. Two of the tech stack components that were upgraded among others were JDK and Oracle Database. We upgraded from JDK 1.3 to JDK 1.6 and from 9.2.0.6 (64-Bit) to 10.2.0.3.0 (64-Bit) on the database front.

Further investigation of the issue revealed the following issue:

- References to JDK 1.3 in the windows registry on the concurrent manager server.


The issue was corrected after changing the references from JDK 1.3 to JDK 1.6. Specifically the AFJVAPRG registry variable was the culprit.

- Aravind Kamath