Question

1
Replies
348
Views
Abhijit Member since 2011 4 posts
TD Bank
Posted: 2 years ago
Last activity: 2 years 4 months ago
Closed
Solved

Purge unresolved work objects

I would like to purge/remove some of the data from our lower environments (upto PAT in Pega 7.2) for performance/data constraints.

Tables :
pr_index
pc_history_work
pc_link_attachment
pc_assign_worklist
Work Table
pc_index_workparty
NBB_INDEX_WORK

I am planning to do this via SQL (delete) queries. And the records within a particular time frame have been chosen to be deleted (mentioned in query condition).
I have taken this approach as the Pega Purge wizard wont delete unresolved WO's. Also it wont give us the freedom to choose a time frame or any other further conditions.

Hence i have the following questions :

  1. Is there any other pega suggested approach to do these deletes?
  2. Are there any OOTB rules to carry out this deletion (with no or minimal customization)?
  3. Are there any other tables from which we need to delete the records (which are interlinked to the above tables).
  4. Would there be any discrepancies that you foresee due to the above changes.

Thanks.

System Administration Data Integration
Moderation Team has archived post
Share this page LinkedIn