Searches that have been paused in groups may not resume when unpaused.
book
Article ID: 100015441
calendar_today
Updated On:
Cause
This issue can be caused by the load on the Microsoft SQL Server hosting the CA or DA customer database at the time the group of Searches was paused. If the load is too great for the server to handle gracefully, some Index Volumes that are yet to be searched may be placed in a Paused status while other Index Volumes to be searched within the group of Searches are left in an active status. The Searches themselves are updated to the Paused status, just not all of the Index Volumes to be searched are placed in the Paused status.
Resolution
In order to determine if the above condition exists, run the following SQL query against the CA or DA customer database. This query can be run with the Enterprise Vault Accelerator Manager Service and the Customer's Background Tasks running.
SELECT
tis.CaseID
, tis.SearchID
, [Search Name] = tis.Name
, tis.StatusID
, [Search Status] = ts1.Name
, tis.Type
, [Search Type] = ts2.Name
, tis.CreateDate
, tis.RunDate
, tis.ModifiedDate
, tis.NumIndexVolsSearch
, tis.NumIndexVolsTotal
, tsv.SearchVaultID
, tsv.VaultId
, tsv.StatusID
, [Vault Status] = ts3.Name
, tsv.StartDate
, tsv.EndDate
, tsv.IndexVolumeSetID
, tsv.NumHits
, tsv.Info
, tsv.WarningInfo
FROM tblIntSearches AS tis (NOLOCK)
JOIN tblSearchVault AS tsv (NOLOCK) ON tis.SearchID = tsv.SearchID
JOIN tblStatus AS ts1 ON tis.StatusID = ts1.StatusID
JOIN tblStatus AS ts2 ON tis.Type = ts2.StatusID
JOIN tblStatus AS ts3 ON tsv.StatusID = ts3.StatusID
WHERE tis.StatusID IN (175 /*Paused*/, 176/*To Be Paused*/, 177/*Pausing*/, 178/*To Be Resubmitted*/, 179/*Resubmitting*/)
AND tsv.StatusID NOT IN (13/*Finished*/, 525/*Paused*/)
ORDER BY tis.CaseID, tis.SearchID, tsv.VaultId;
Any results returned by the query will list index volumes that are not in an expected status for paused searches. If the query returns results, please contact technical support to implement the resolution steps, which will involve editing the index volume entries in the Accelerator Customer database. A pre-requisite of implementing the resolution steps is to have current SQL backups of all Accelerator databases. Please verify current SQL backups are available prior to contacting technical support as this will reduce the time to implement the resolution steps.
Issue/Introduction
When Compliance Accelerator (CA)/Veritas Advanced Surveillance (VAS) or Discovery Accelerator (DA) Searches are paused in a group, those Searches may not resume processing when un-paused, either individually or in groups.
Was this article helpful?
thumb_up
Yes
thumb_down
No