Database error on execution of clean submitted tasks

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

When running the daily Clean Submitted Tasks task on our production environment it fails with the following database error:

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1' ORA-06512: at "IDMANAGER.GARBAGECOLLECTBYID", line 10 ORA-06512: at "IDMANAGER.GARBAGECOLLECTBYEVENTID", line 6 ORA-06512: at "IDMANAGER.GARBAGECOLLECTBYTASKID", line 47 ORA-06512: at "IDMANAGER.GARBAGECOLLECTBYTASKID", line 39 ORA-06512: at "IDMANAGER.GARBAGECOLLECTTASKS", line 44 ORA-06512: at "IDMANAGER.GARBAGECOLLECTTASKPERSISTENCE", line 18 ORA-06512: at line 1 

Environment

Identity Manager 14.x 

Resolution

The issue is with the oRacle UNDO space.  This should be increased.

Additional Information

Please also see the related knowledge article below.

SQLException:ORA-01555, Undo error( ORA-30036: unable to extend segment by 128 in undo tablespace 'UNDOTBS2)