Windchill PDM Link: Upload, Checkin or Add to Workspace of a large assembly and its related drawing fails with the error: "A SQL error has occurred. Database system message follows:"

• Upload, Checkin or Add to Workspace of a large assembly and its related drawing fails with the error: "A SQL error has occurred. Database system message follows:"
• Event Management shows the following error:

• MethodServer log shows the following error:

wt.pom.DatastoreException: A SQL error has occurred. Database system message follows:
Nested exception is: wt.util.WTIOException: A persistence error occurred. System message follows:
    java.io.IOException: ORA-01691: unable to extend lob segment WCADMIN.SYS_LOB0000029370C00002$$ by 8192 in tablespace BLOBS

    at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:285)
    at oracle.jdbc.driver.OracleBlobOutputStream.close(OracleBlobOutputStream.java:238)
    at wt.pds.oracle81.StandardLobHandler81.write(StandardLobHandler81.java:208)
    at wt.pds.LobOutputStream.writeBytes(LobOutputStream.java:106)
    at wt.pds.LobOutputStream.flushBuffer(LobOutputStream.java:115)
    at wt.pds.LobOutputStream.close(LobOutputStream.java:97)
    at wt.pds.PDSEncoder$OutputRedirector.close(PDSEncoder.java:1156)
    at wt.pds.PDSEncoder$EncodeObjectOutputStream.close(PDSEncoder.java:459)
    at wt.pds.oracle81.StandardLobHandler81.setObjectAsLob(StandardLobHandler81.java:496)
    at wt.pds.SQLDatabasePds.setObjectAsLob(SQLDatabasePds.java:1538)
    at wt.pds.WTPreparedStatement.postProcessLobs(WTPreparedStatement.java:760)
    at wt.pds.SQLDatabasePds.insertList(SQLDatabasePds.java:3223)
    at wt.pds.SQLDatabasePds.insert(SQLDatabasePds.java:306)
    at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:2404)
    at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:572)
    at wt.fc.StandardPersistenceManager.insert(StandardPersistenceManager.java:1382)
    at wt.fc.StandardPersistenceManager.insert(StandardPersistenceManager.java:1117)
    at wt.queue.ProcessingQueue.addEntry(ProcessingQueue.java:227)
    at wt.notify.StandardNotificationManager.queueNotification(StandardNotificationManager.java:5910)
    at wt.notify.StandardNotificationManager.queueDeferNotificationEventTargets(StandardNotificationManager.java:8407)
    at wt.notify.StandardNotificationManager$NotificationEventListener.queueNotificationSubscriptions(StandardNotificationManager.java:863)
    at wt.notify.StandardNotificationManager$NotificationEventListener.processNotificationEventTargets(StandardNotificationManager.java:754)
    at wt.notify.StandardNotificationManager$NotificationEventListener.doEventTargetChunkProcessing(StandardNotificationManager.java:415)
    at wt.notify.StandardNotificationManager$NotificationEventListener.notifyVetoableMultiObjectEvent(StandardNotificationManager.java:361)
    at wt.events.StandardKeyedEventBranch.intDispatchEvent(StandardKeyedEventBranch.java:298)
    at wt.events.StandardKeyedEventBranch.dispatchVetoableMultiObjectEvent(StandardKeyedEventBranch.java:263)
    at wt.events.StandardKeyedEventDispatcher.intDispatchEvent(StandardKeyedEventDispatcher.java:306)
    at wt.events.StandardKeyedEventDispatcher.dispatchVetoableMultiObjectEvent(StandardKeyedEventDispatcher.java:244)
    at wt.services.StandardManagerService.intDispatchVetoableEvent(StandardManagerService.java:408)
    at wt.services.StandardManagerService.dispatchVetoableMultiObjectEvent(StandardManagerService.java:313)
    at wt.events.summary.SummaryEventFactory.finishTransaction(SummaryEventFactory.java:324)
    at wt.pom.TransactionManager.summaryEventFinishTransaction(TransactionManager.java:509)
    at wt.pom.TransactionManager.commitTransaction(TransactionManager.java:437)
    at wt.pom.BasicTransactionMonitor.commitTransaction(BasicTransactionMonitor.java:64)
    at wt.pom.PersistentObjectManager.commitTransaction(PersistentObjectManager.java:404)
    at wt.pom.Transaction.commit(Transaction.java:725)
    at com.ptc.windchill.uwgm.proesrv.StandardRequestDispatcher.dispatchRequest(StandardRequestDispatcher.java:1324)
    at com.ptc.windchill.uwgm.proesrv.StandardRequestDispatcher.scanRequests(StandardRequestDispatcher.java:1061)
    at com.ptc.windchill.uwgm.proesrv.UwgmTransactionExecuterImpl.execute(UwgmTransactionExecuterImpl.java:109)
    at com.ptc.windchill.uwgm.proesrv.UwgmTransactionExecuterImpl.executeTransaction(UwgmTransactionExecuterImpl.java:59)
    at com.ptc.windchill.uwgm.proesrv.ProeService.executeTransaction(ProeService.java:111)
    at com.ptc.windchill.uwgm.proesrv.ProeService.execute(ProeService.java:87)
    at com.ptc.windchill.uwgm.soap.impl.uwgm.BinaryRequestHandler.processRequest(BinaryRequestHandler.java:678)
    at com.ptc.windchill.uwgm.soap.impl.uwgm.BinaryRequestHandler.getCacheDescriptor(BinaryRequestHandler.java:527)
    at sun.reflect.GeneratedMethodAccessor42869.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at wt.httpgw.HTTPServer.processRequest(HTTPServer.java:346)
    at wt.httpgw.MethodRequestHandler.handleRequest(MethodRequestHandler.java:58)
    at wt.httpgw.HTTPGatewayServlet.serviceWithoutFilters(HTTPGatewayServlet.java:336)
    at wt.httpgw.HTTPAuthGatewayServlet.serviceWithoutFilters(HTTPAuthGatewayServlet.java:86)
    at wt.httpgw.FilterChainImpl.doFilter(FilterChainImpl.java:94)
    at wt.session.SessionContextDestroyer.doFilterInternal(SessionContextDestroyer.java:136)
    at wt.session.SessionContextDestroyer.doFilter(SessionContextDestroyer.java:184)
    at wt.httpgw.FilterChainImpl.doFilter(FilterChainImpl.java:81)
    at wt.httpgw.HTTPGatewayServlet.service(HTTPGatewayServlet.java:235)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at com.ptc.jws.servlet.filter.WsdlServletFilter.doFilter(WsdlServletFilter.java:80)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at com.ptc.core.ui.validation.URLValidationFilter.doFilter(URLValidationFilter.java:77)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at wt.httpgw.filter.WTContextBeanFilter.doWithWtContextBeanHandler(WTContextBeanFilter.java:104)
    at wt.httpgw.filter.WTContextBeanFilter.doFilter(WTContextBeanFilter.java:58)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at wt.servlet.CompressionFilter.doFilter(CompressionFilter.java:294)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at wt.servlet.RequestInterrupter.doFilter(RequestInterrupter.java:335)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at wt.servlet.ServletRequestMonitor.doFilter(ServletRequestMonitor.java:1660)
    at wt.servlet.ServletRequestMonitorFilter.doFilter(ServletRequestMonitorFilter.java:56)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
    at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:476)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1420)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: ORA-01691: unable to extend lob segment WCADMIN.SYS_LOB0000029370C00002$$ by 8192 in tablespace BLOBS

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)
    at oracle.jdbc.driver.T4C8TTILob.processError(T4C8TTILob.java:790)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
    at oracle.jdbc.driver.T4C8TTILob.write(T4C8TTILob.java:176)
    at oracle.jdbc.driver.T4CConnection.putBytes(T4CConnection.java:3072)
    at oracle.sql.BLOB.setBytes(BLOB.java:1046)
    at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:277)
    ... 93 more

2025-03-26 17:36:28,587 ERROR [ajp-nio-127.0.0.1-8013-exec-3] wt.pds.exception Nikhil_khanchanale - Suppressing internal message wt.pom.DatastoreException: A SQL error has occurred. Database system message follows:<br />Nested exception is: wt.util.WTIOException: A persistence error occurred. System message follows:<br />	java.io.IOException: ORA-01691: unable to extend lob segment TESTPLMDB.SYS_LOB0000125116C00002$$ by 1024 in tablespace BLOBS<br /><br />	
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:257)<br />	
at oracle.jdbc.driver.OracleBlobOutputStream.close(OracleBlobOutputStream.java:219)<br />	
at wt.pds.oracle81.StandardLobHandler81.write(StandardLobHandler81.java:204)<br />	
at wt.pds.LobOutputStream.writeBytes(LobOutputStream.java:106)<br />	
at wt.pds.LobOutputStream.flushBuffer(LobOutputStream.java:115)<br />	
at wt.pds.LobOutputStream.close(LobOutputStream.java:97)<br />	
at wt.pds.PDSEncoder$OutputRedirector.close(PDSEncoder.java:1337)<br />	
at wt.pds.PDSEncoder$EncodeObjectOutputStream.close(PDSEncoder.java:534)<br />	
at wt.pds.oracle81.StandardLobHandler81.setObjectAsLob(StandardLobHandler81.java:492)<br />	
at wt.pds.SQLDatabasePds.setObjectAsLob(SQLDatabasePds.java:1587)<br />	
at wt.pds.WTPreparedStatement.postProcessLobs(WTPreparedStatement.java:758)<br />	
at wt.pds.SQLDatabasePds.cacheLobs(SQLDatabasePds.java:4415)<br />	
at wt.pds.SQLDatabasePds.insertListDefault(SQLDatabasePds.java:3270)<br />	
at wt.pds.SQLDatabasePds.insertList(SQLDatabasePds.java:3150)<br />	
at wt.pds.SQLDatabasePds.insert(SQLDatabasePds.java:320)<br />	
at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:2405)<br />	
at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:573)<br />	
at wt.fc.StandardPersistenceManager.insert(StandardPersistenceManager.java:1427)<br />	
at wt.fc.StandardPersistenceManager.insert(StandardPersistenceManager.java:1143)<br />	
at wt.queue.ProcessingQueue.addEntry(ProcessingQueue.java:231)<br />	
at com.ptc.wvs.server.publish.PublishQueueHelper.addEntry(PublishQueueHelper.java:1009)<br />	
at com.ptc.wvs.server.publish.PublishQueueHelper.addPublishEntry(PublishQueueHelper.java:857)<br />	
at com.ptc.wvs.server.publish.PublishQueueHelper.addPublishEntry(PublishQueueHelper.java:833)<br />	
at com.ptc.wvs.server.publish.Publish.executePublish(Publish.java:1941)<br />	
at com.ptc.wvs.server.publish.Publish.executePublish(Publish.java:1838)<br />	
at com.ptc.wvs.server.publish.Publish.doPublish(Publish.java:619)<br />	
at com.ptc.windchill.enterprise.wvs.newrep.forms.CreateFromEpmFormDelegate.publishPublishParam(CreateFromEpmFormDelegate.java:574)<br />	
at com.ptc.windchill.enterprise.wvs.newrep.forms.CreateFromEpmFormDelegate.doOperation(CreateFromEpmFormDelegate.java:371)<br />	
at com.ptc.core.components.forms.DefaultObjectFormProcessor.processDelegates(DefaultObjectFormProcessor.java:392)<br />	
at com.ptc.core.components.forms.DefaultObjectFormProcessor.doOperation(DefaultObjectFormProcessor.java:86)<br />	
at com.ptc.windchill.enterprise.wvs.newrep.forms.NewRepFormProcessor.doOperation(NewRepFormProcessor.java:29)<br />	
at com.ptc.core.components.forms.DefaultFormProcessorController.executeDoOperation(DefaultFormProcessorController.java:538)<br />	
at com.ptc.core.components.forms.DefaultFormProcessorController.performExecuteDoOperationAndPostProcess(DefaultFormProcessorController.java:342)<br />	
at com.ptc.core.components.forms.DefaultFormProcessorController.execute(DefaultFormProcessorController.java:263)<br />	
at com.ptc.core.components.forms.FormDispatcher.callControllerExecute(FormDispatcher.java:146)<br />	
at com.ptc.core.components.forms.FormDispatcher.callFormProcessorController(FormDispatcher.java:116)<br />	
at com.ptc.core.components.forms.FormDispatcher.execute(FormDispatcher.java:93)<br />	
at jdk.internal.reflect.GeneratedMethodAccessor1583.invoke(Unknown Source)<br />	
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br />	
at java.base/java.lang.reflect.Method.invoke(Method.java:569)<br />	at com.ptc.netmarkets.util.beans.NmCommandBean.execute(NmCommandBean.java:2246)<br />	
at com.ptc.jca.mvc.controllers.ActionController.executeWizardAction(ActionController.java:222)<br />	
at com.ptc.jca.mvc.controllers.ActionController.processRequest(ActionController.java:125)<br />	at jdk.internal.reflect.GeneratedMethodAccessor1517.invoke(Unknown Source)<br />	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br />	
at java.base/java.lang.reflect.Method.invoke(Method.java:569)<br />	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:255)<br />