1. Home
  2. Support
Article - CS294101

Update Tool fails to upgrade database schema with "ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS1'" in Windchill PDMLink

Modified: 09-Jan-2024   


Applies To

  • FlexPLM 10.1 to 11.1
  • Windchill PDMLink 10.1 to 12.0

Description

  • Update Tool fails to upgrade database schema with "ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS1'" 
  • Migration fails with an error: ORA-30036: unable to extend segment by 8 in tablespace 'UNDOTBS1'
  • Update Tool fails to update the database schema: 
    • 2018-09-28 06:40:06,153 INFO  [UpgradeEventFirer] com.ptc.windchill.upgrade.logging.UpgradeFrameworkLogger - Task EXECUTING: Update Database Schema
2018-09-28 06:40:07,962 INFO  [main] com.ptc.windchill.upgrade.phases.upgradeschema.DefaultUpgradeSchemaWorker - Executing with a pool of 13 threads.
2018-09-28 06:40:07,962 INFO  [main] com.ptc.windchill.upgrade.phases.upgradeschema.DefaultUpgradeSchemaWorker - Total number of batches to execute: 184
2018-09-29 15:55:38,345 ERROR [pool-2-thread-5] com.ptc.windchill.upgrade.phases.upgradeschema.ExecuteBatch - wt.util.WTException: (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand
[ALTER TABLE LCSSKU MODIFY(num31 NUMBER NULL, num32 NUMBER NULL, num33 NUMBER NULL, num34 NUMBER NULL, num35 NUMBER NULL, num36 NUMBER NULL, num37 NUMBER NULL, num38 NUMBER NULL, num39 NUMBER NULL, num40 NUMBER NULL, num41 NUMBER NULL, num42 NUMBER NULL, num43 NUMBER NULL, num44 NUMBER NULL, num45 NUMBER NULL, num46 NUMBER NULL, num47 NUMBER NULL, num48 NUMBER NULL, num49 NUMBER NULL, num50 NUMBER NULL, num51 NUMBER NULL, num52 NUMBER NULL, num53 NUMBER NULL, num54 NUMBER NULL, num55 NUMBER NULL, num56 NUMBER NULL, num57 NUMBER NULL, num58 NUMBER NULL, num59 NUMBER NULL, num60 NUMBER NULL, num61 NUMBER NULL, num62 NUMBER NULL, num63 NUMBER NULL, num64 NUMBER NULL, num65 NUMBER NULL, num66 NUMBER NULL, num67 NUMBER NULL, num68 NUMBER NULL, num69 NUMBER NULL, num70 NUMBER NULL, num71 NUMBER NULL, num72 NUMBER NULL, num73 NUMBER NULL, num74 NUMBER NULL, num75 NUMBER NULL, num76 NUMBER NULL, num77 NUMBER NULL, num78 NUMBER NULL, num79 NUMBER NULL, num80 NUMBER NULL) ].
Nested exception is: java.sql.SQLException: ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDOTBS1'
ORA-06512: at "DBADMIN.T_LCSSEASONPRODUCTLINK_END", line 9
ORA-04088: error during execution of trigger 'DBADMIN.T_LCSSEASONPRODUCTLINK_END'
ORA-06512: at "DBADMIN.T_LCSSKU_END", line 16
ORA-04088: error during execution of trigger 'DBADMIN.T_LCSSKU_END'

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