Attachment document data having sys_attachment as empty

[varunkumar11863]

Hi All,

As per SN, sys_attachment_doc shall always have sys_attachment reference as sys_attachment contains the meta data and sys_attachment_doc contains the actual attachment data. We have Reference cascade rule set as 'Delete' OB. However, I can still see sys_attachment as blank in sys_attachment_doc.

Have anyone faced this issue earlier?

[Ankur Bawiskar]

@varunkumar11863 

did you verify the cascade rule settings?

[varunkumar11863]

Yes, it is marked as 'Delete'.

Attachment Document is extremely huge; hence I am not able to analyze it. I have set up some data and will retest if OB Archiving delete the Attachment Document data or just clear out the Attachment reference.

[khanalihaid]

Hi Varun, I haven't come across this before. It might be worth reviewing the cascade delete settings or any recent updates that could affect the reference. Let me know if you find a solution!