java.sql.SQLException: ORA-01691: unable to extend lob segment S_BIP_SCHED.SYS_LOB0000233445C00007$$ by 8192 in tablespace ORACLE_BIP Error Code: 1691 Call: UPDATE XMLP_SCHED_OUTPUT SET MESSAGE = ?, STATUS = 'S', DOCUMENT_DATA_AVAILABLE = 'Y', DOCUMENT_DATA_CONTENT_TYPE = 'application/pdf', XML_DATA = ?, XML_DATA_AVAILABLE = 'Y', DOCUMENT_DATA = ?, XML_DATA_CONTENT_TYPE = 'text/xml', LAST_UPDATED = {ts '2010-09-28 02:02:51.75'} WHERE (OUTPUT_ID = 29901) bind => [[B@13596bf, [B@13bdf73, [B@1cb0917] Query: UpdateObjectQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput@1d093bd)

Oracle Community | 799809 | 6 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    BIP scheduler jobs are failed while we schedule the reports

    Oracle Community | 6 years ago | 799809
    java.sql.SQLException: ORA-01691: unable to extend lob segment S_BIP_SCHED.SYS_LOB0000233445C00007$$ by 8192 in tablespace ORACLE_BIP Error Code: 1691 Call: UPDATE XMLP_SCHED_OUTPUT SET MESSAGE = ?, STATUS = 'S', DOCUMENT_DATA_AVAILABLE = 'Y', DOCUMENT_DATA_CONTENT_TYPE = 'application/pdf', XML_DATA = ?, XML_DATA_AVAILABLE = 'Y', DOCUMENT_DATA = ?, XML_DATA_CONTENT_TYPE = 'text/xml', LAST_UPDATED = {ts '2010-09-28 02:02:51.75'} WHERE (OUTPUT_ID = 29901) bind => [[B@13596bf, [B@13bdf73, [B@1cb0917] Query: UpdateObjectQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput@1d093bd)

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-01691: unable to extend lob segment S_BIP_SCHED.SYS_LOB0000233445C00007$$ by 8192 in tablespace ORACLE_BIP Error Code: 1691 Call: UPDATE XMLP_SCHED_OUTPUT SET MESSAGE = ?, STATUS = 'S', DOCUMENT_DATA_AVAILABLE = 'Y', DOCUMENT_DATA_CONTENT_TYPE = 'application/pdf', XML_DATA = ?, XML_DATA_AVAILABLE = 'Y', DOCUMENT_DATA = ?, XML_DATA_CONTENT_TYPE = 'text/xml', LAST_UPDATED = {ts '2010-09-28 02:02:51.75'} WHERE (OUTPUT_ID = 29901) bind => [[B@13596bf, [B@13bdf73, [B@1cb0917] Query: UpdateObjectQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput@1d093bd)

      at oracle.apps.xdo.servlet.scheduler.toplink.ToplinkDataHandler.updateOutput()
    2. oracle.apps.xdo
      XDOJob.execute
      1. oracle.apps.xdo.servlet.scheduler.toplink.ToplinkDataHandler.updateOutput(ToplinkDataHandler.java:1144)
      2. oracle.apps.xdo.servlet.scheduler.XDOJob.execute(XDOJob.java:635)
      2 frames
    3. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:195)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
      2 frames