Archive & Purge Wizard does not delete Attachment Records
We are using Pega 8.4.1 (upgraded from 7.2.2) & we are planning to use OOTB Archiving/Purging Pega feature to maintain system performance by reducing database processing demands.
After scheduling the process, it appears the feature only archives & purge work object & history table records, however, the related records in the attachment tables (pc_data_workattach & pc_link_attachement) still persists in the table.
As per the link below, I was under the impression that the wizard takes care of all related records and archives in the form of a zip file.
Attachments should we archived unless it has multiple references. Do you see multiple links to the data-workattach? If yes those attachments will not be archived. Links are not archived.. Hope this helps.
I am not sure what you mean by multiple references but I simply created 2 works objects - One had 2 file attachments and another had another file attachment. I can see their entries in the attachment table even after purging.
In production, the size of this attachment table is very large that's why we want to apply the archiving & purging solution but it appears the standard OOTB feature has some limitations. As per the Pega help guide, it should archive all the related attachments which is not the case here.
Apologies, I thought you are using the Archival option available at the case level under case settings on a case type. Please note this option is available only on cloud in case you want to use it to Archive
By multiple references, I mean more than one link to an attachment.
I will have someone from ECS team answer this for the Purge and Archive wizard.
We have found out the root cause here. OOTB Archive & purge wizard can't take care of attachments which are added through gadget(using '+' icon in Recent Content section in the right panel) as it creates an instance of PegaSocial-Document which is different work pool.
If we use basic 'Attach Content' control in our section to attach the file then attachments are part of the archived file. I think Pega should clearly specify this in their help document to avoid confusion in future.