Siebel Application or IP2017 Upgrade (Upgphys Step) Fails with Error ORA-01652/ORA-01653 unable to extend segment/table in tablespace
(Doc ID 2360099.1)
Last updated on OCTOBER 03, 2024
Applies to:
Siebel Service Enterprise - Version 17.0 [IP2017] and laterInformation in this document applies to any platform.
Symptoms
When attempting to run an upgrade to IP2017 or later, Upgphys fails and the following error is seen in the log file upgphys_dev_<source_version>\output\syncidx1.log:
2018-02-07 13:35:27 writeExecDDL error (pOperCallback UTLDbDdlOperIndCreate).
2018-02-07 13:35:27 Error in MainFunction (UTLDbDdlDbMerge).
2018-02-07 13:35:27 Error in Main function...
2018-02-07 13:35:27 (logapi.cpp (184) err=1 sys=2) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 2, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)
Similar issue may also happen in the upgphys_dev_<source_version>\output\upgpddlctl_tab.log:
S1000: [tp][ODBC Oracle driver][Oracle]ORA-01653: unable to extend table SIEBEL.S_ORDER_ITEM by 8192 in tablespace <SIEBEL_DATA>
2019-08-08 15:12:54
2019-08-08 15:12:54 add "WIDTH" number(10, 0)
2019-08-08 15:12:54
2019-08-08 15:12:54 ;
2019-08-08 15:12:54 writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
2019-08-08 15:12:54 writeExecDDL error (pOperCallback UTLDbDdlOperMultiColAdd).
2019-08-08 15:12:55 Error in MainFunction (UTLDbDdlDbMerge).
2019-08-08 15:12:55 Error in Main function...
The same error can also be encountered while performing workspace delivery or accessing application and doing some tasks. When this happens, below errors will be displayed in the corresponding logs:
The ObjMgr*.log might show below error when trying to have some data getting inserted into a table as part of a task.
Please continue or ask your systems administrator to check your application configuration if the problem persists.
SQLParseAndExecute Execute 5 00006f7c66b130a0:0 2024-08-05 15:40:32 ORA-01652: unable to extend temp segment by 128 in tablespace TEM
While delivering workspace, the error might be encountered and WS_Deliver*.log will show the same error code.
As per TYPE - List Column, NAME - LS Clinical RACT Assessment Value List AppletListProbability, FIELD - Sequence OLDVAL - 7, NEWVAL -
!!ERRORS FOUND - An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111)--
ORA-01653: unable to extend table SIEBEL_DEV.S_LIST_COLUMN by 128 in tablespace SIEBEL_DATA
ORA-06512: at line 5,it was suggested to fix the error
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |