There is a procedure to locate and cancel in progress tasks directly from the CA IM (CA Identity Manager) database.
Procedure outline: Locate the ‘tasksessionid’ for the task(s) to delete, then update the tasksession12_5 table and change the state of those tasks to a CANCELLED state (256).
In-progress tasks and unable to delete through the UI.
To locate the tasksessionid, go to View Submitted Tasks (VST) and use the ‘Description’ and the ‘Submitted Time’ to help filter out these objects from this tasksession12_5 table.
1. Go to VST – find the task
2. Use the SQL below to select that task from tasksession12_5 table and find its tasksessionid.
3. Update the task entry of this tasksessionid state = ‘256’
4. Repeat this for all tasks you need to delete.
See below:
/**
BEGIN_STATE = 0x00; 0 In Progress
PRE_STATE = 0x01; 1
PENDING_STATE = 0x04; 4
EXECUTING_STATE = 0x08 8
APPROVED_STATE = 0x10; 16
POST_STATE = 0x40; 64
INITIAL_STATE = 0x400 1024
PRIMARY_PENDING_STATE = 0x800 2048
PRIMARY_COMPLETE_STATE = 0x1000 4096
SECONDARY_PENDING_STATE = 0x2000 8192
MARK_FOR_DELETION_STATE = 0x200 512 Completed
COMPLETED_STATE = 0x80; 128
AUDIT_STATE = 0x4000 16384 Audited
INVALID_STATE = 0x02; 2 Failed
REJECTED_STATE = 0x20; 32 Rejected
CANCELLED_STATE = 0x100; 256
UNKNOWN_STATE = 0x300 768 Unknown
**/
SELECT QUERY:
SELECT [tasksessionid]
,[state]
,[created_time]
,[last_access_time]
,[user_dn]
,[org_dn]
,[environmentid]
,[name]
,[description]
,[acknowledged]
,[parent_of_wf_id]
,[action_type]
,[priority]
,[initiatorid]
,[nesting_type]
,[next_state]
FROM [IM_TPSTORE].[dbo].[tasksession12_5]
WHERE [BUILD A FILTER BASED ON DESCRIPTION AND/OR SUBMITTED TIME YOU GET FROM VIEW SUBMITTED TASKS]
GO
UPDATE STATEMENT:
UPDATE [dbo].tasksession12_5
set [state] = 256
WHERE [tasksessionid] = ‘THE ID YOU FOUND’
GO
To get the Task ID, please, see the article below
https://knowledge.broadcom.com/external/article?articleId=111984