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
  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)
  2. 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)
  3. 0

    Oracle Business Intelligence Publisher Stuck

    Oracle Community | 2 years ago | user13333117
    java.sql.SQLException: ORA-00942: table or view does not exi st Error Code: 942 Call: SELECT t0.OUTPUT_ID, t0.MESSAGE, t0.DELETED, t0.STATUS, t0.DOCUMENT_DATA_A VAILABLE, t0.STATUS_DETAIL, t0.DOCUMENT_DATA_CONTENT_TYPE, t0.XML_DATA, t0.CREAT ED, t0.XML_DATA_AVAILABLE, t0.DOCUMENT_DATA_COMPRESSED, t0.XML_DATA_COMPRESSED, t0.DOCUMENT_DATA, t0.XML_DATA_CONTENT_TYPE, t0.LAST_UPDATED, t0.JOB_ID FROM XMLP _SCHED_OUTPUT t0 WHERE ((t0.DELETED = 'N') AND EXISTS (SELECT t1.SUBSCRIPTION_ID FROM XMLP_SCHED_JOB t3, XMLP_SCHED_JOB t2, XMLP_SCHED_SUBSCRIPTION t1 WHERE ((( t1.SUBSCRIBER = '025_teller01') AND (t2.JOB_ID = t3.JOB_ID)) AND ((t2.JOB_ID = t 1.JOB_ID) AND (t3.JOB_ID = t0.JOB_ID)))) ) ORDER BY t0.CREATED DESC Query: ReadAllQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle Business Intelligence Publisher Stuck

    Oracle Community | 2 years ago | user13333117
    java.sql.SQLException: ORA-00942: table or view does not exi st Error Code: 942 Call: SELECT t0.OUTPUT_ID, t0.MESSAGE, t0.DELETED, t0.STATUS, t0.DOCUMENT_DATA_A VAILABLE, t0.STATUS_DETAIL, t0.DOCUMENT_DATA_CONTENT_TYPE, t0.XML_DATA, t0.CREAT ED, t0.XML_DATA_AVAILABLE, t0.DOCUMENT_DATA_COMPRESSED, t0.XML_DATA_COMPRESSED, t0.DOCUMENT_DATA, t0.XML_DATA_CONTENT_TYPE, t0.LAST_UPDATED, t0.JOB_ID FROM XMLP _SCHED_OUTPUT t0 WHERE ((t0.DELETED = 'N') AND EXISTS (SELECT t1.SUBSCRIPTION_ID FROM XMLP_SCHED_JOB t3, XMLP_SCHED_JOB t2, XMLP_SCHED_SUBSCRIPTION t1 WHERE ((( t1.SUBSCRIBER = '025_teller01') AND (t2.JOB_ID = t3.JOB_ID)) AND ((t2.JOB_ID = t 1.JOB_ID) AND (t3.JOB_ID = t0.JOB_ID)))) ) ORDER BY t0.CREATED DESC Query: ReadAllQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput)
  6. 0

    error while upgrading user form in oim sysadmin console

    Oracle Community | 1 year ago | user8744020
    java.sql.SQLException: ORA-01691: unable to extend lob segment IAMEXT_OIM.SYS_LOB0000354182C00002$$ by 128 in tablespace IAMEXT_OIM Error Code: 1691 Call: INSERT INTO USR_CONFIG_HISTORY (CFG_KEY, CFG_XML, ENTITY_TYPE, REASON, UPDATED_BY, UPDATED_DATE) VALUES (?, ?, ?, ?, ?, ?) bind => [6 parameters bound] Query: InsertObjectQuery(oracle.iam.configservice.vo.ConfigAudit@2120ed23)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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