CA Service Management

  • 1.  Clean Orphaned Attachments

    Posted Nov 19, 2018 09:57 AM

    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.



  • 2.  Re: Clean Orphaned Attachments

    Broadcom Employee
    Posted Nov 19, 2018 11:22 AM

    I am not aware of such a tool.

    That being said, maybe start looking into why this happened and try to prevent further occurrence?