1 Reply Latest reply: Jun 14, 2013 7:43 AM by Sridhar Yerram RSS

    DBLink in VO Query

    nancy25

      Hi,

       

      I have a created a dblink that connects to R12 database. When i use the DBlink in VO in oaf it doesnt seem to be working on the server.However it is working on the local machine. Below is the details of the error.

       

      <!--StartFragment-->java.sql.SQLException: ORA-02019: connection description for remote database not found.

       

      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

      at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)

      at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)

      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)

      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)

      at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2566)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2963)

      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)

      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:584)

      at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:631)

      at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:518)

      at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3375)

      at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java:828)

      at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4525)

      at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574)

      at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:544)

      at oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:619)

      at oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:3339)

      at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3326)

      at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441)

      at gesss.oracle.apps.icx.gesearch.search.webui.GECMJobSearchCO.processFormRequest(GECMJobSearchCO.java:162)

      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:814)

      at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)

      at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1159)

      at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)

      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1026)

      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:992)

      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:847)

      at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)

      at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)

      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1026)

      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:992)

      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:847)

      at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)

      at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)

      at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2720)

      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1714)

      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:515)

      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:436)

      at _oa__html._OA._jspService(_OA.java:84)

      at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)

      at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)

      at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)

      at oracle.jsp.JspServlet.internalService(JspServlet.java:186)

      at oracle.jsp.JspServlet.service(JspServlet.java:156)

      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:662)

       

      Please advise.

       

       

      Regards,

      Nancy