NON-PROD - Failure In FCEXEC_PRE_JOB - ORA-30036: unable to extend segment by in undo tablespace
(Doc ID 3036908.1)
Last updated on JULY 24, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 24.0 and laterInformation in this document applies to any platform.
Symptoms
On : 24.0 version, Merch-Scheduler
UAT/STG - Failure in FCEXEC_PRE_JOB
This job just failed after almost 5h of execution with the following error:
ERROR
-----------------------
2024-07-22T20:37:13,377 [Thread-684] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Mon Jul 22 15:55:52 Program: prepost: PID=84433: Started by RMSBATCHUSER1
2024-07-22T20:37:13,383 [Thread-684] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: prepost~20240722203713~fcexec_pre~~-30036~ORA-30036: unable to extend segment by in undo tablespace ''~INSERT in package FUTURE_COST_THREAD_SQL.INSERT_BATCH_THREADS thread_num: 1
2024-07-22T20:37:13,383 [Thread-684] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Mon Jul 22 20:37:13 Program: prepost: PID=84433: Aborted in process: function fcexec_pre, INSERT in package FUTURE_COST_THREAD_SQL.INSERT_BATCH_THREADS thread_num: 1
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the fcexec process in adhoc mode
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 |