Some users are unable to remove items from their work list

Document ID : KB000005419
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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