How to Remove Completed and Canceled Processes in Enterprise Manager?

Applies To

• AgilePoint Suite
• AgilePoint Enterprise Manager
• AgilePoint Envision
• AgilePoint Developer
• AgilePoint Server

Objective

How to remove complete and canceled processes in Enterprise Manager?

Summary

Instead of in Enterprise Manager, it can be done by SQL scripts or through archive database.

Resolution

To remove completed and canceled processes, there are two ways:

1. Through SQL scripts as follow:

   delete WF_EVENTS where 
       PROC_INST_ID in (select PROC_INST_ID from WF_PROC_INSTS where STATUS = 
       'Canceled' OR STATUS = 'Completed')
       
   delete WF_AUTO_WORKITEMS 
       where PROC_INST_ID in (select PROC_INST_ID 
       from WF_PROC_INSTS where STATUS = 'Canceled' OR STATUS = 'Completed')
       
   delete WF_MANUAL_WORKITEMS where PROC_INST_ID in (select PROC_INST_ID 
       from WF_PROC_INSTS where STATUS = 'Canceled' OR STATUS = 'Completed')
       
   delete WF_ACTIVITY_INSTS where PROC_INST_ID in (select PROC_INST_ID 
       from WF_PROC_INSTS where STATUS = 'Canceled' OR STATUS = 'Completed')
       
   delete WF_CUSTOM_ATTRS where CUSTOM_ID in (select PROC_INST_ID 
       from WF_PROC_INSTS where STATUS = 'Canceled' OR STATUS = 'Completed')
   delete WF_CUSTOM_ATTRS where CUSTOM_ID in ( select WORK_OBJECT_ID 
       from WF_PROC_INSTS where PROC_INST_ID in (select PROC_INST_ID 
       from WF_PROC_INSTS where STATUS = 'Canceled' OR STATUS = 'Completed'))
   
   delete WF_PROC_TRACKINGS where PROC_INST_ID in (select PROC_INST_ID 
       from WF_PROC_INSTS where STATUS = 'Canceled' OR STATUS = 'Completed')
       
   delete WF_LARGE_TEXTS where TEXT_ID in (select PROC_INST_ID 
       from WF_PROC_INSTS where STATUS = 'Canceled' OR STATUS = 'Completed')
       
   delete WF_MAIL_DELIVERABLES where PROC_INST_ID in (select PROC_INST_ID 
       from WF_PROC_INSTS where STATUS = 'Canceled' OR STATUS = 'Completed')
       
   delete WF_PROC_INSTS where PROC_INST_ID in (select PROC_INST_ID 
       from WF_PROC_INSTS where STATUS = 'Canceled' OR STATUS = 'Completed')

2. Through database archiving

   In AgilePoint Server Configuration, you can set up an Archive Database in additional to the Main Database. Then you can set up a schedule to archive the completed processes and their related data from the main database into the archive database.

   In addition, in upcoming release, the Enterprise Manager will provide additional management type functionalities such as: database cleanup.