Error getting UniqueID Numeric Overflow

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

Exception in the log is "Error getting UniqueID Numeric Overflow "

Environment

All Identity Manager

Cause

The WP_IP_GEN table contains a NEXT_ID column for each table that stores a counter. The maximum value an int can hold in Java is 2,147,483,647 so when the counter reaches that the error will be generated for that specific table.

Resolution

Could not reset WPDS key as this would cause all existing reports to fail.  We truncated the below and deleted the WP_IP_GEN table which Workpoint support confirmed would rebuild itself after restart and not cause issues with existing data.  The below resolved the issue.  

This requires a manual DB updates.  Please confirm a full backup of your database has been completed BEFORE performing the steps below with the assistance of your DBA. 

The below steps is an example for when the error is related to the WP_TRANI_Hist:

1. Backing up database
2. Bring application down 
3. Truncate the WP_TRANI_Hist table
4. Delete the row 43 in WP_IP_Gen table 
5. Reinitialize WP.

The below steps is an example for when the error is related to the WP_WI_Alert_Hist:

1. Backing up database
2. Bring application down 
3. Truncate the WP_WI_Alert_Hist table
4. Delete the row 44 in WP_IP_Gen table 
5. Reinitialize WP.