My Oracle Support Banner

Long lasting calculation process ends with Error ORA-30036: Unable to extend segment by 128 in undo tablespace 'FUSION_UNDOTS' (Doc ID 2469304.1)

Last updated on SEPTEMBER 10, 2019

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.18.05.0 and later
Oracle Fusion Incentive Compensation - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

Symptoms

Calculation Process has been running for more than 12 hours and then error.  Notice that it restarted / resubmit itself.


ERROR
ORA-30036: unable to extend segment by 128 in undo tablespace 'FUSION_UNDOTS'

OR

Unexpected Error SQLCODE=-30036:SQLERRM=ORA-30036: unable to extend segment by 128 in undo tablespace 'UNDOTBS2'
Unexpected Error SQLCODE=-1555:SQLERRM=ORA-01555: snapshot too old: rollback segment number 218 with name "_SYSSMU218_954695908$" too small
Unexpected Error SQLCODE=-30036:SQLERRM=ORA-30036: unable to extend segment by 8 in undo tablespace 'FUSION_UNDOTS'
Unexpected Error SQLCODE=-30036:SQLERRM=ORA-30036: unable to extend segment by 128 in undo tablespace 'FUSION_UNDOTS'
// *Cause: the specified undo tablespace has no more space available.
// *Action: Add more space to the undo tablespace before retrying
// the operation.



STEPS
Submit calculation for 2018-04-01 to 2018-10-31 , all participants , in TOTAL 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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.