Error Message

The Rejection process is performed by the SQL server in the Customer database. The following rare circumstances may adversely affect the Rejection processing:
- User intervention to manually edit any of the Search's parameters in the database without the guidance of Veritas technical support.
- Sudden and unexpected loss of power to the SQL server configured without any un-interruptable power supplies.
- Sudden and unexpected loss of connectivity and/or to the hard drives housing the Customer database(s) files and/or the TempDB database files.

To verify the current condition of a Search suspected to not have completed the Rejection process completely, obtain the SearchID, either via the Accelerator Client by hovering the cursor over the Search Name in the Search tab, or via querying the Customer database as below after editing the Search Name as indicated:

SELECT SearchID, Name AS 'Search Name', RunDate, StatusID
FROM tblIntSearches
WHERE Name LIKE '%Search_Name%'; -- Replace Search_Name with part of the search name that have been deleted.

Edit the SearchID in the first line of the following query as indicated and execute the query against the CA or DA Customer database:

DECLARE @SearchID int = AA;  -- Edit the SearchID here
SELECT
Name, SearchID, CaseID, CreateDate, RunDate, ModifiedDate, StatusID, NumIndexVolsSearch, NumIndexVolsTotal, NumHits, NumDuplicates, SampleSize, SampleResultSize
, [tblSearchResults count] = (SELECT COUNT (1) FROM tblSearchResults WHERE SearchID = @SearchID)
, [tblSearchItems count] = (SELECT COUNT (1) FROM tblSearchItems WHERE SearchID = @SearchID)
, [tblDiscoveredItemToSearch count] = (SELECT COUNT (1) FROM tblDiscoveredItemToSearch WHERE SearchID = @SearchID)
, [tblIntDIscoveredItems count] = (SELECT COUNT (1) FROM tblIntDiscoveredItems WHERE SearchID = @SearchID)
, [tblSearchVault count] = (SELECT COUNT (1) FROM tblSearchVault WHERE SearchID = @SearchID)
, [tblSearchVaultsArchived count] = (SELECT COUNT (1)
FROM tblSearchVaultsArchived
WHERE SearchID = @SearchID)
FROM tblIntSearches WHERE SearchID = @SearchID;

If the following columns show the results below, the Search has successfully completed the Rejection processing:
- tblSearchResults count = 0
- tblSearchItems couont = 0
- tblDiscoveredItemToSearch count = 0
- tblIntDiscoveredItems count = 0
- tblSearchVault count = 0
- tblSearchVaultsArchived count = 0

If any of the above columns do not display zero, then please contact Veritas technical support for further investigation.