Cannot edit or remove a schedule in Accelerator Scheduled Searches

book

Article ID: 100049349

calendar_today

Updated On:

Description

Error Message

There are no errors reported.

 

Cause

This issue is caused by the StatusID of the Parent Scheduled Search being set to an incorrect value.  The expected value for an active Parent Scheduled Search is 9 (Schedule).

To determine if this is the cause, edit the following SQL query for the Customer database name as indicated and  run the query against the CA/DA customer database:

USE CustomerDB;   -- change CustomerDB to the name of the actual customer database
SELECT
[Customer Database] = db_name()
, tis.CaseID
, CASE
    WHEN (tc.FolderType = 330 AND tc.Type = 101) THEN 'Case'
    WHEN (tc.FolderType = 330 AND tc.Type = 102) THEN 'Department'
    WHEN tc.FolderType = 331 THEN 'Folder'
    WHEN tc.FolderType = 332 THEN 'Hidden Folder'
    ELSE 'Unknown' END + ': ' + tc.Name AS 'Case/Department/Research Folder'
, ts3.Name AS 'Case/Dept/Research Folder Status'
, tis.SearchID AS 'Parent Scheduled Search ID'
, tis.Name AS 'Parent Scheduled Search Name'
, ts2.Name AS 'Search Type'
, ts1.Name AS 'Search Status'
, tis.CreateDate AS 'Parent Search Creation Date'
, tis.RunDate AS 'Last Scheduled Run Date'
FROM tblIntSearches AS tis (NOLOCK)
INNER JOIN tblCase AS tc (NOLOCK) ON tis.CaseID = tc.CaseID
INNER JOIN tblStatus AS ts1 ON tis.StatusID = ts1.StatusID
INNER JOIN tblStatus AS ts2 ON tis.Type = ts2.StatusID
INNER JOIN tblStatus AS ts3 ON tc.StatusID = ts3.StatusID
WHERE tis.Type = 112 AND tis.StatusID NOT IN (4, 5, 9, 858);
 
Any rows returned by this query will be the Parent Scheduled Searches that would not be able to have their Schedules changed.
 

Resolution

Please contact Technical Support for assistance in resolving this issue.

 

Issue/Introduction

Enterprise Vault (EV) Compliance Accelerator (CA) and Discovery Accelerator (DA) have the ability to create Search Schedules and use those Schedules in Scheduled Searches. Once a Scheduled Search is saved, it becomes a Parent Scheduled Search and will run Child Searches (Scheduled Search Runs) using its Criteria based on the frequency set in the Schedule. A Parent Scheduled Search only allows certain fields to be edited. One of those fields is the Search Schedule used in the Scheduled Search. A Schedule can be edited to a different Schedule or can be stopped so the Parent Scheduled Search does not create any more Child Searches. For a Scheduled Search to be stopped, one option is to change the selected Schedule to the <None> option. When this issue is seen, editing the Selected Search Schedule may seem to take effect, but upon viewing the Search Criteria again, the Schedule is not changed.
Powered by Wolken Software