search cancel

Some users are unable to remove items from their work list


Article ID: 5419


Updated On:


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


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 Type: PRODUCTION CA Privileged Identity Manager r12.8


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


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