Deleting pending orphan tasks in PAM

Products

• CA Process Automation Base

Issue/Introduction

There are pending tasks that have been restarted and already re-assigned to other users. We need to delete the orphan tasks that are no longer usable but still show up as pending tasks for the user(s).

Environment

Process Automation Manager 4.4

Resolution

Note: Perform a backup before any manual update or delete statement to the PAM database.

1. Log in to PAM as an Administrator | Operations | Click on "Tasks" under Links

2. Identify and take note of the Task(s) ID(s) that are orphaned (no longer required). This step is critical since only orphan pending tasks can be deleted.

3. Log into the PAM runtime database

4. Find the Task ID that needs to be deleted:

select ROID from c2opromptuser where UserInfoXML like '%USERNAME_ASSIGNED_TO_ORPHAN_TASK%' and roid in (TASK_ID_TO_BE_DELETED)

Note: Make sure only one row is returned

5.  Delete the orphan TASK:

delete from c2opromptuser where UserInfoXML like '%USERNAME_ASSIGNED_TO_ORPHAN_TASK%' and roid in (TASK_ID_TO_BE_DELETED)

 

Note: We recommended deleting one or two tasks first, checking the behavior, and continuing based on the results.

The tasks should disappear from PAM UI (Operations Tab | Tasks page) once the delete statement is executed.

Additional Information

Manage Task Lists