How to cancel in progress tasks from the database
search cancel

How to cancel in progress tasks from the database

book

Article ID: 30407

calendar_today

Updated On:

Products

CA Identity Manager

Issue/Introduction

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).

Environment

Release: 12.x, 14.x
Component: IDMGR

Cause

In-progress tasks and unable to delete through the UI. 

Resolution

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

Additional Information

To get the Task ID, please, see the article below

https://knowledge.broadcom.com/external/article?articleId=111984