java.sql.SQLException: No corresponding row found in XDO_LOBS

Oracle Community | Diwakar Dhake | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Not able to upload RTF files

    Oracle Community | 6 years ago | Diwakar Dhake
    java.sql.SQLException: No corresponding row found in XDO_LOBS

    Root Cause Analysis

    1. java.sql.SQLException

      No corresponding row found in XDO_LOBS

      at oracle.apps.xdo.oa.schema.server.LobHelper.updateLob()
    2. oracle.apps.xdo
      TemplatesAMImpl.addTemplateFile
      1. oracle.apps.xdo.oa.schema.server.LobHelper.updateLob(LobHelper.java:116)
      2. oracle.apps.xdo.oa.schema.server.LobHelper.updateLob(LobHelper.java:286)
      3. oracle.apps.xdo.oa.schema.server.LobHelper.updateLob(LobHelper.java:205)
      4. oracle.apps.xdo.oa.schema.server.TemplateHelper.updateTemplateFile(TemplateHelper.java:3900)
      5. oracle.apps.xdo.oa.template.server.TemplatesAMImpl.addTemplateFile(TemplatesAMImpl.java:611)
      5 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    4. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:189)
      2. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:679)
      2 frames
    5. oracle.apps.xdo
      TemplateFileAddCO.processFormRequest
      1. oracle.apps.xdo.oa.template.webui.TemplateFileAddCO.processFormRequest(TemplateFileAddCO.java:362)
      1 frame
    6. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:799)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1118)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2633)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1659)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
      18 frames
    7. oa_html
      _OA._jspService
      1. oa_html._OA._jspService(_OA.java:88)
      1 frame
    8. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    9. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    10. oracle.jsp
      JspServlet.service
      1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
      2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
      3. oracle.jsp.JspServlet.service(JspServlet.java:156)
      3 frames
    11. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    12. org.apache.jserv
      JServConnection.run
      1. org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      2. org.apache.jserv.JServConnection.run(JServConnection.java:294)
      2 frames
    13. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame