Lost the pending self registration users during upgrade

Products

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

Issue/Introduction

After upgrade IDM to 14.3 and switch of IDM database to use a new schema. Since the database copy was a week old the list of pending self-registration users from that day was lost. Users list was recovered 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.