on 07-11-2013 08:02 AM
How to remove Legal Hold Errors from DA Cases.
Step 1 :
Get the CaseID for the Colum “Errors” in above Screenshot.
Select * from tblCase where StatusID = 20
Step 2 :
Check counts in tblLegalHoldSummaries
Select * from tblLegalHoldSummaries where CaseID = 31
Step 3 :
Update tblIntDiscoveredItems
update tblIntDiscoveredItems set LegalStatus = 420 where CaseId = 31 and LegalStatus = 425
Step 4 :
Update the counts in tblLegalHoldSummaries via this SP
EXEC [usp_LegalItem_UpdateSummary] @CaseID = 31
Step 5 :
Check counts in tblLegalHoldSummaries. CONFIRM NumHoldError = 0
select * from tblLegalHoldSummaries where CaseID = 31
--DONE
LegalStatus :
420 Hold Item Status No Hold
421 Hold Item Status To Add Hold
422 Hold Item Status Adding Hold
423 Hold Item Status To Remove Hold
424 Hold Item Status Removing Hold
425 Hold Item Status Hold Error
426 Hold Item Status Hold
427 Hold Item Status Item Deleted