How to identify reason behind record deletion from custom table

[PriyankaSadhwni]

There is an observation in SNOW environment : Custom table's requests created  a day before are disappearing after a day

Checked Archival rules/Logs : nothing is there for that  table

Also checked scheduled jobs; but can't find anything linked to same custom table.

I noticed in deleted records in: sys_audit_delete and from there we can Roll back:

1)My Ask : How I can check which job is deleting this?
Document Key present in -sys_audit_delete  is not helping..
2)In Table: /sys_delete_recovery not able to locate which job is causing this deletion?

3) In Table: sys_rollback_sequence when I enter document key: No result.

4) One more question cun observation : omit relationship to parent record is not clear to me

In table:  there is related list: delete Record ; I see 'URLs/Query omit relationship to parent record' and when try to open link in new tab  ; sys_rollback_sequence : no record found with document key

@Sulabh Garg Can You please advice?

[Bert_c1]

Hi PriyankaSadhwni,

If you create a support case, and have an example of a record being deleted in the last couple of days, a Support Engineer can track down the reason for a record being deleted. Database logs can be searched, then the app node logs.  Database logs have a few days lifetime, no more.

[jonsan09]

You could try creating a Business rule for record deletions on the table and have it log to the system log the time and account triggering the deletion. It may not tell you the exact reason for the deletion but it should help narrow down the issue.

[Poonam Mahajan]

@PriyankaSadhwni  : Did you find any root cause for this issue.As we are also facing the same issue for one of our custom table.

Kindly assist.

Thanks