Error : (ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS2')

UNDO Tablespace issue can take toll on Oracle database.

Simple reason for this problem is that UNDO Tablespace is running out of allocated disk space whilst attempting the procedure migration .That causes MIGRCASE instruction failure and the Oracle database would be required to rollback all of the changes it had made up until the UNDO failure.The MIGRCASE instruction would then be un-locked and another BG process would then be allowed to process that same MIGRCASE instruction which would start the migration process from the very beginning again.


1. How to find out the total cases which need to be migrated ?
Please run below query on iProcess database for a specific procedure .

select b.is_dead, b.major_vers, b.minor_vers, count(*)
  from proc_index a JOIN case_information b
    on a.proc_id = b.proc_id
 where a.proc_name = '<>'
 group by b.is_dead, b.major_vers, b.minor_vers
 order by b.is_dead, b.major_vers, b.minor_vers

To confirm on the migration error , you would also like to search "MIGRC" in the log files. You will find details in sw_warn.log file for case migration. Something similar to below :

CPLInstruction - Error> <-2>