Some users are unable to remove items from their work list

Products

• CA Virtual Privilege Manager
• CA Privileged Identity Management Endpoint (PIM)
• CA Privileged Access Manager (PAM)

Issue/Introduction

Some users are unable to remove items from their work list. They select the approval tasks, reject them all at once but the items always return to their work list.

Environment

Environment Type: PRODUCTION CA Privileged Identity Manager r12.8

Cause

Items that are on the Approval queue, and expire before being approved or rejected, become orphan items.

Resolution

To remove the Orphaned tasks: 

 

* Backup the WP_WORK_ITEM table. 

 

If your ENTM database is 

 

* MS-SQL, Please run the Worklist_Cleanup_MSSQL.SQL (it creates a procedure) and then Worklist_Cleanup_Execute_MSSQL.SQL(it executes the procedure). 

Note: Please replace the USE [129sp1] in the above SQL files with the USE[YOUR_ENTM_DB_NAME] 

 

 

* Oracle, Please run the Worklist_Cleanup_ORACLE.SQL in the oracle db client after connecting to ENTM database. After execution, it creates a procedure with the name called CLEANUP_WORKITEMS. Then run the procedure. 

Note: Please replace ENTM_DB_NAME with the your ENTM Database Name.

 

After running the above procedure, you will not see the older approval links in Waiting For My Approval page. 

 

Additional Information

 

 

The scripts mentioned on this article are available in http://bit.ly/2kNNqWw