EnterWorks - ETT 148 - How to Purge Completed Work Items from EPX Workflows using SQL

When work items have completed in a workflow, they remain at the End activity until they are purged by a user (in Design Console or the UI) or by the a Purge activity in the same workflow.  In cases where the completed work items have accumulated to a large count, a normal Purge operation may fail with an error.  This results in a growing number of work items in EPX, which can have a negative impact to performance.  If this happens, it may be necessary to run the Purge operation in Design Console after stopping the EPXTomcat service.

The stored procedure EW_PurgeCompletedWorkItems will purge the completed work items from the designated workflows in batches, providing an alternative to running Design Console and having to stop the EPXTomcat service.  This stored procedure was derived from the EW_PurgeDeletedWorkItems. covered in EnterWorks Tech Talk: "ETT 146 - How to Purge Deleted Work Items from EPX Workflows) with the main change being the query that identifies the work items to be purged looking for completed work items instead of deleted ones.

This session shows how to use the SQL stored procedure.

Prerequisites - ETT 002, ETT 003