Question
Nordea
SE
Last activity: 6 Aug 2020 5:25 EDT
Archive & Purge Wizard does not delete Attachment Records
Hi,
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.
https://collaborate.pega.com/question/dose-purgearchive-tools-purge-all-related-recodes
while importing the zip file back into the system, I can only see work object and history records. There is no record for attachments.
Am I doing something wrong or I should raise Incident for that?
Accepted Solution
Updated: 6 Aug 2020 5:25 EDT
Nordea
SE
Hi,
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.
Pegasystems Inc.
IN
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.
Nordea
SE
Hi,
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.
Pegasystems Inc.
IN
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.
Thanks!
Updated: 10 Jul 2020 11:21 EDT
CBA
AU
Hi Anand,
We applied purging and archiving in our application as mentioned above it will not work for all the tables for such tables DB team need to perform purging and archiving from their end.
Updated: 13 Jul 2020 5:29 EDT
Nordea
SE
Hi Sam,
If my understanding is correct, it's mentioned in the help guide (https://community.pega.com/sites/default/files/help_v73/tools/purgearchive/aboutpurgearchivewizard.htm) that it takes care of related attachments. In my opinion, there is no point in using the OOTB feature if it only takes care of just the work object table. Might be considered as a product improvement in future releases.
Accepted Solution
Updated: 6 Aug 2020 5:25 EDT
Nordea
SE
Hi,
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.