Manually purge campaign on Oracle Database

Products

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

Issue/Introduction

The campaign data purge from the Identity Governance portal takes a while to complete and is resource intensive.

The script performs the same action in a considerable less time and resources.

Environment

Identity Governance 14.x

Cause

Due to large dataset

Resolution

Below running the steps below, perform a backup of your Identity Governance database.

Here are the steps to running the script:

1. Stop Identity Governance server
2. Run the following SQL query to get the BusinessFlows: "select * from businessflows;"
3. The result is a list of all the business flows, note BUSINESSFLOWID of the campaign you wish to purge. For this document we will assume it is 42.
4. Open the jar file dbutil-jar-with-dependencies.jar located in <RCM_Home>/eurekify-jboss/bin/ for JBoss and for WebSphere
5. In the navigate to com\eurekify\dbutil\oracle\sql, where you will find the file purgeCampaignScript.sql
6. Copy the file to a different location.
7. Open the file in a text editor and edit the first line as follows (you only need to edit the value you found in step 3):
   "DECLARE BusinessFlow_Id INTEGER := XX;"
8. Execute the updated script.
9. Run statistics on the schema.
10. Start RCM server.

 

If you are using Virtual Appliance, the dbutil-jar-with-dependencies.jar is located under /opt/CA/wildfly-ig/bin