AnsweredAssumed Answered

Clean Orphaned Attachments

Question asked by john.wohlgemuth on Nov 19, 2018
Latest reply on Nov 19, 2018 by Chi_Chen

We're in a situation where the physical file attachments, the attmnt table and the usp_lrel_attachments* tables are out of sync.  

 

Situation:

 

  1. Physical files are stored on disk, but have no corresponding record in attmnt
  2. The usp_lrel_attachments* have records, but point to purged cr and chg records.

Example query: 

select count(id) from 
usp_lrel_attachments_requests with (nolock)
where cr not in (select persid from call_req with (nolock))

 

 

Question: Are there any OOTB solutions to reconcile this, similar to the CORA cleanup utility?

 

Thank you.

Outcomes