Publish Fails on delivery due to error -- java.sql.SQLException: ORA-01691: unable to extend lob segment {SITES_DB_USER}.SYS_LOB0000412003C00003$$ by 128 in tablespace {TABLESPACE} (Doc ID 2274027.1)

Last updated on DECEMBER 06, 2022

Applies to:

Symptoms

On : 11.1.1.8.0 version, WebCenter Sites

We are unable to publish from Source to Delivery environment and
the following error occurs in delivery

ERROR
-----------------------
[2017-04-19 23:53:39,958 CDT] [ERROR] [.kernel.Default (self-tuning)'] [cs.core.db.DBTransaction] TransactionUnit failed to execute
com.fatwire.cs.core.db.TransactionAbortException: replacerows failed

[2017-04-21 00:47:30,581 CDT] [ERROR] [.kernel.Default (self-tuning)'] [logging.cs.xcelerate.publish] Error during publish: java.lang.Exception: com.fatwire.cs.core.realtime.DataException: Error transporting data, errno=-105
com.fatwire.cs.core.realtime.DataException: java.lang.Exception: com.fatwire.cs.core.realtime.DataException: Error transporting data, errno=-105
at com.fatwire.realtime.AbstractTransporter.execute(AbstractTransporter.java:159)

Caused by

java.sql.SQLException: ORA-01691: unable to extend lob segment {SITES_DB_USER}.SYS_LOB0000412003C00003$$ by 128 in tablespace {TABLESPACE}
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.