Support Article
Purge wizard is not deleting PC_ASSIGN_WORKBASKET contents
SA-2297
Summary
User has observed that work object data from PC_ASSIGN_WORKBASKET and PC_ASSIGN_WORKLIST were are not deleted by the Purge and Archive process. User wants to know about deleting work object data using Purge and Archive process in Process Commander.
Error Messages
NA
Steps to Reproduce
Run Purge and Archive wizard in PRPC
Root Cause
NA
Resolution
Purge and Archive wizard in Process Commander deletes all the work objects having status as Resolved-* from the following tables (in same order):
PR_DATA
PC_DATA_WORKATTACH
PC_LINK_ATTACHMENT
PC_HISTORY_WORK
PC_INDEX_WORKPARTY
PC_WORK
PC_DATA_WORKATTACH
PC_LINK_ATTACHMENT
PC_HISTORY_WORK
PC_INDEX_WORKPARTY
PC_WORK
If the work object data has Resolved-* status, then that work object will not reside in PC_ASSIGN_WORKLIST or PC_ASSIGN_WORKBASKT tables. If there are some records present in PC_ASSIGN_WORKLIST/PC_ASSIGN_WORKBASKT tables, that means that the work object is waiting for some action to be performed, and they are not resolved yet. Or if resolved work objects data was present in these two tables, then the flow by which these records should have been removed and need to be investigated.
For more details, refer the PDN document - Purge and Archive.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.