Database error on execution of clean submitted tasks

Products

• CA Identity Manager

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

Release : 14.3 CP2

Component : IdentityMinder(Identity Manager)

Resolution

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

 

 

Additional Information

Please also see the realted knowledge article below.

 

https://knowledge.broadcom.com/external/article?articleId=94227