javax.servlet.ServletException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION

Hi Readers,

7-8 months back I implemented R12.1.1 on Sun sparc-10 (64-bit) . End users start complaning that after giving username/password on login page and press login gives "unexpected error - please contact to your system administrator" . More interesting thing is that this issue comes intermittently .When end user tried again or refrehes the Internet explore and provide user credentials and clink on login , he/she logged in successfully into the applicaiton. I turned on FND_DIAGNOSTICS to Yes to see more details of the error.

Finally I got below error details and I raised a serv1 for this. After 4-5 months struggle finally oracle released the patch.

Oracle Support - February 9, 2011 1:27:33 PM GMT+05:30 [ODM Action Plan]
=== ODM Action Plan ===Patch 9908921 (9908921:R12.FWK.B Details) "FND, MESSAGE NAME: FND_NO_DATABASE_CONNECTION"has been released

To check more details of the error.
$LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log

javax.servlet.ServletException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION.
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:899)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:816)
at _OALogout._jspService(_OALogout.java:243)
at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.5.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
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.5.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
10/10/18 09:32:59.564 html: OABodyBean, localName='body': Could not find partial target: Employment.EmpHistoryTab
10/10/18 09:48:07.480 html: OABodyBean, localName='body': Could not find partial target: Employment.EmpHistoryTab

FYI,
When 9908921 Patch released (08-Feb-2011), it released in 2 versions. i.e. 9908921 for OA Framework 12.1.2 and 11832737 (FORWARD PORT OF 9908921 TO 12.1.3 - Released on 16-MAR-2011) for OA Framework 12.1.3 customers.This is documented in Doc Id # 1298103.1 (created as of 30-Mar-2011)

Hope this info is helpful.

Regards
Guru

Don't forget to leave your comments