Purge Of Sessions Logs Failed in ODI and getting error "ORA-30036: Unable To Extend Segment By 8 In Undo Tablespace 'UNDOTBS1'"
(Doc ID 2507929.1)
Last updated on MAY 03, 2021
Applies to:Hyperion Financial Data Quality Management - Version 220.127.116.11.000 and later
Information in this document applies to any platform.
While trying to Purge ODI Logs from ODI Console, UNDOTBS1 Tablespace size gets full and finally ODI throws below error -
Purge of load plan logs is successful. Purge of sessions logs failed. com.sunopsis.dwg.SQLWorkReposException:
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
In ODI console few of the sessions will be in waiting state and those sessions cannot be purged, only the active sessions and completed sessions can be purged.
In-order to purge the waiting sessions those sessions should be deleted from ODI studio.
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