How to Clean Up Stuck In-Progress Tasks in Identity Manager

Products

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

Issue/Introduction

In-progress tasks remain visible in the "View Submitted Tasks" console even after executing the "Cancel In Progress Task Only" task.

Environment

• Product: Broadcom Identity Manager 14.x 15.x
• Database: MS SQL Server

Cause

In-progress tasks may remain stuck in the database due to orphaned records or incomplete workflow states.

 

Resolution

To clean up stuck in-progress tasks on MS SQL Server, follow these steps:

1. Prepare the Stored Procedure: Execute the SQL script contents of Create stored procedure clean_in_progress_task_withWF.txt. This creates a stored procedure titled clean_in_progress_task_only_withWF.

2. Identify Tasks to Remove: Execute the contents of the file Query to list only in progress task_withWF.txt to generate a list of tasks that will be removed.

   • Note: You must modify the last_access_time parameter for your specific time period.
   • Note: Ensure the environment OID (ime_id) is accurate.

3. Execute Cleanup: Run the clean_in_progress_task_only_withWF stored procedure using the following parameters:

   • @ime_id: The environment OID value (found in the Identity Manager Management Console).
   • @cutoff_time: The date/time stamp. All records in a pending state prior to this time are subject to removal (Example: 08/29/2018 12:59:59 PM).
   • @chuck_rec_count: The number of records to process before committing (default is 500).

   Warning: This script will remove all in-progress workflow tasks.

4. Verify Removal: Run the content of Query to list only in progress task_withWF.txt again. The list should now be empty.

5. Confirm in Console: Log in to the Identity Manager user console and verify that the in-progress tasks have been removed.

Additional Information

For detailed guidance on retrieving logs, refer to the product documentation. To speak with a customer representative or a Support Engineer, see Contact Support. Scroll to the bottom of the page and select your region.