1. Home
  2. Support
Article - CS306679

Error 'ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS' is reported when executing a delete attribute operation through a load file in Windchill

Modified: 16-May-2019   


Applies To

  • Windchill PDMLink 10.2 to 11.1
  • FlexPLM 10.2 to 11.1

Description

  • Following error is reported when executing a delete attribute operation through a load file in Windchill
java.sql.BatchUpdateException: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS'

    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:11190)
    at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:244)
    at wt.log4j.jmx.AsyncJDBCAppender.executeBatch(AsyncJDBCAppender.java:1426)
    at wt.log4j.jmx.AsyncJDBCAppender$SharedConnection.flushAll(AsyncJDBCAppender.java:2423)
    at wt.log4j.jmx.AsyncJDBCAppender$AppenderConnection.flushAll(AsyncJDBCAppender.java:2344)
    at wt.log4j.jmx.AsyncJDBCAppender.flushAllSynchronously(AsyncJDBCAppender.java:1464)
    at wt.log4j.jmx.AsyncJDBCAppender$FlushAllTask.run(AsyncJDBCAppender.java:1330)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
 
  • Operation is done through a load file of type:
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE NmLoader

  SYSTEM "standardX24.dtd">

<NmLoader>

   <csvDeleteAttributes handler="com.ptc.core.lwc.server.TypeDefinitionLoader.deleteAttributeDefinitions">

      <csvattTemplate>LWCTYPE</csvattTemplate>

      <csvtypeContext>wt.part.WTPart</csvtypeContext>

      <csvdefNames>DATA|com.ptc.core.meta.common.DiscreteSet|DATA|java.lang.Boolean|false , DATA|java.lang.String|Std1, DATA|java.lang.String|Std2, DATA|java.lang.String|Std3</csvdefNames>

   </csvDeleteAttributes>

</NmLoader>

 
This is a printer-friendly version of Article 306679 and may be out of date. For the latest version click CS306679