Video Screencast Help

How to remove Legal Hold Errors from DA Cases.

Created: 11 Jul 2013 • Updated: 19 Jul 2013
Language Translations
EV_Ajay's picture
0 0 Votes
Login to vote

Error.JPG

 

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