Lost the pending self registration users during upgrade

Products

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

Issue/Introduction

We upgraded our IDM to 14.3 and switched our IDM database to use a new schema. Since the database copy was a week old we lost the list of pending self-registration users from that day.  I was able to get the users list from WP_ tables.

Is there any way to get the email addresses?

Environment

Release : 14.3

Component : IdentityMinder(Identity Manager)

Resolution

The pending self registrations, including the users' email addresses, would have been stored in Task Persistence tables from before the database switchover. There's no way to get those emails without having the database from the correct time frame.

The recommended best practice is to process all tasks to completion prior to upgrades in which you will be swapping databases.