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

Release: 14.x
Component: IDMGR

Cause

Over 2 billion records in history 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. 

Steps: 
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.