Upgrade identity governance fail with Oracle

Products

• CA Identity Governance

Issue/Introduction

Getting the following error during the upgrade

output of DBUTIL running to upgrade Identity Governance database
                          Status: SUCCESSFUL
                          Additional Notes: NOTE - DBUTIL_RESULT = ERROR from db-util: java.lang.RuntimeException: exit code: -1.Updating Database ... 
ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces
ORA-06512: at line 20

 

Environment

Release : 14.4

Component : GovernanceMinder(Role & Compliance Manager)

Cause

This is due to the DB index overflow

Resolution

1. Restore the DB

2. Get the vanilla Jboss and run the migration tool as per the documentation.

3. Take the backup of new JBOSS after above step (2).

4. Run the below query on the SDB database.

ALTER TABLE Resources add overflow ;

5. Run the upgrade through installer.