Data archive/ cleanup

[Pankaj kr]

Hi,

I am trying to archive- destroy/ cleanup record using the OOB functionality but when executed the rules I observed the attachment are becoming orphan and not getting deleted along with base record deletions. If anyone have experienced the similar issue, pls answer this question.

Thanks,

Pankaj kumar

[pavani_paluri]

Hi @Pankaj kr ,

Have you created child rules on sys_attachment and sys_attachment_doc table? If not, Please create them because this makes sure both the attachment metadata and actual file content are archived together.

If they are already orphaned, we can delete them using ix script.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Pavani P

[Pankaj kr]

Hi @pavani_paluri ,

We can't directly create the child archive rules on sys_attachment and attachment_doc table. As per the recent comments by servicenow, it being ignored because my attachments are encrypted. I will keep the thread updated once I get any solution.