How to delete and recreate an Identity Manager Environment (IME) with the same Object ID (OID) in v15

Products

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

Issue/Introduction

When a CA Identity Manager Environment (IME) is deleted and recreated, the system automatically increments the Object ID (OID). This causes a loss of visibility for historical Task Persistence (TP) and archived data, which are linked to the original OID. Customers often need to recreate the environment while retaining access to this historical data by forcing the new environment to use the original OID 

Environment

CA Identity Suite / Identity Manager v15
Supported Relational Databases (Oracle, MS SQL, etc.)

Resolution

[!CAUTION] Warning: Manually modifying internal Identity Manager database tables is not generally recommended. Always perform a full backup of your Object Store database before proceeding.

To recreate an environment with a specific OID (e.g., 23), follow these steps:

0. Backup your Machine (vmware snapshot or clone) before any action and backup database too before proceed with next steps. This will be used to rollback in case something happen unexpected.

1. From IM Management Console export the environment under environments menu that will generate a zip file, export also the Provisioning Store and User Store Directories under Directory folder.

2. Delete the Environment: Delete the existing Identity Manager Environment and its associated Directories from the Management Console.

3. Access the Database: Connect to your Object Store database using a management tool (e.g., SQL Server Management Studio or Oracle SQL Developer).

4. Locate the Sequence Table: In v15, identify the table named SEQUENCES.

5. Identify the Row: Look for the row where TABLENAME is 'IM_ENVIRONMENT_JDBC_SEQ'.

6. Adjust the NEXTID: The NEXTID column actually represents the last used ID. To have the next environment created with ID 23, you must set this value to 22 (for this example we want create the environment with ID 23 so we put 22 here)

SQL Command:

UPDATE dbo.SEQUENCES 
SET NEXTID = 22 
WHERE TABLENAME = 'IM_ENVIRONMENT_JDBC';

7. Verify the Change: Run a SELECT statement to ensure the table is updated.

8. Import/Create Environment: Return to the Management Console and create or import your environment. It will now be assigned the ID 23.