Remove All Process Related Data from the Workflow Database
During the application development process, there may be Running or Completed processes that are created for testing purposes, but are no longer needed in the server. You can use SQL scripts that can be used to clean up the workflow database to remove unwanted processes.
Prerequisites
- A user account that can access the AgilePoint workflow database. By default, this is the AgilePoint Service Account.
Procedure
- To delete All the processes and their related data, execute this SQL command.
delete WF_EVENTS delete WF_AUTO_WORKITEMS delete WF_MANUAL_WORKITEMS delete WF_ACTIVITY_INSTS delete WF_CUSTOM_ATTRS delete WF_PROC_TRACKINGS delete WF_LARGE_TEXTS where TEXT_ID in ( select PROC_INST_ID from WF_PROC_INSTS ) delete WF_PROC_INSTS delete WF_MAIL_DELIVERABLES.