Remove All Process Related Data from Database

Applies To

AgilePoint Server

Symptoms

During the QA cycle, there may be pending or completed processes that are created for testing purpose and are no longer needed in the server. It will nice to have SQL scripts that can be used to clean up the database to remove unwanted processes.

Cause

N/A

Resolution

To delete all the processes and their related data from the database, please use the following SQL statements:

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.