Advertisement

05.15.2008 at 11:13PM PDT, ID: 23407508 | Points: 125
[x]
Attachment Details

Exporting data from Oracle Application throughs error message

Asked by bokaria in Oracle ERP, Oracle Database

Tags: Orcale, E-Business Suite, Application Version: 11.5.9 / Database : 9.2.0.7, OS - Redhat Linux, null Cannot Get Connection to Database

On exporting data (File --> Export) from Oracle AP or GL gives me the following error message.
"null Cannot get Connection to the Database"

It shows the export progress and opens up a new page where it shows this error.
I tried logging in using different roles but I get the same message.
I definitely have connection to database because all the payments and processing which I do in AP gets applied to database.

Find below the exception details for the same.
Please advice/help to fix this.

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.lang.Exception: Can not get a JDBCConnection;  (Could not lookup message because there is no database connection)
      at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:625)
      at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:601)
      at _oa__html._OAErrorPage._jspService(_OAErrorPage.java:75)
      at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:385)
      at oracle.jsp.JspServlet.doDispatch(JspServlet.java:259)
      at oracle.jsp.JspServlet.internalService(JspServlet.java:178)
      at oracle.jsp.JspServlet.service(JspServlet.java:148)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
      at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:175)
      at oracle.jsp.runtime.OraclePageContext.handlePageException(OraclePageContext.java:360)
      at _oa__html._AppsLocalLogin._jspService(_AppsLocalLogin.java:568)
      at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:385)
      at oracle.jsp.JspServlet.doDispatch(JspServlet.java:259)
      at oracle.jsp.JspServlet.internalService(JspServlet.java:178)
      at oracle.jsp.JspServlet.service(JspServlet.java:148)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      at org.apache.jserv.JServConnection.run(JServConnection.java:294)
      at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
java.lang.Exception: Can not get a JDBCConnection
      at oracle.apps.fnd.umx.password.PasswordUtil.generateForgotPwdLink(PasswordUtil.java:79)
      at oracle.apps.fnd.umx.password.PasswordUtil.generateForgotPwdLink(PasswordUtil.java:164)
      at _oa__html._AppsLocalLogin._jspService(_AppsLocalLogin.java:482)
      at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:385)
      at oracle.jsp.JspServlet.doDispatch(JspServlet.java:259)
      at oracle.jsp.JspServlet.internalService(JspServlet.java:178)
      at oracle.jsp.JspServlet.service(JspServlet.java:148)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      at org.apache.jserv.JServConnection.run(JServConnection.java:294)
      at java.lang.Thread.run(Thread.java:534)
java.lang.Exception: Can not get a JDBCConnection
      at oracle.apps.fnd.umx.password.PasswordUtil.generateForgotPwdLink(PasswordUtil.java:79)
      at oracle.apps.fnd.umx.password.PasswordUtil.generateForgotPwdLink(PasswordUtil.java:164)
      at _oa__html._AppsLocalLogin._jspService(_AppsLocalLogin.java:482)
      at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:385)
      at oracle.jsp.JspServlet.doDispatch(JspServlet.java:259)
      at oracle.jsp.JspServlet.internalService(JspServlet.java:178)
      at oracle.jsp.JspServlet.service(JspServlet.java:148)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      at org.apache.jserv.JServConnection.run(JServConnection.java:294)
      at java.lang.Thread.run(Thread.java:534)


Start Free Trial
[+][-]05.18.2008 at 08:57AM PDT, ID: 21593110

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]05.19.2008 at 02:21AM PDT, ID: 21596178

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 04:41AM PDT, ID: 21605166

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 05:10AM PDT, ID: 21605368

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 04:57AM PDT, ID: 21622903

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628