When too many resources are used on the SQL Server to process database queries, SQL deadlocks can occur that result in performance issues. When the DA Analytics Ingestor Task is running and these deadlocks occur, the ingestion processing will fail. A maximum number of retries for the task is then reached and the ingestor processing is automatically paused.
In some circumstances, turning off the auto-pause mechanism can allow analytics data collection to complete successfully. For example, this may be the case if transient SQL timeout issues are responsible for the failure of an internal analytics task.
To turn off the auto-pause mechanism:
1. On the DA Server, browse to the DA installation folder (typically C:\Program Files (x86)\Enterprise Vault Business Accelerator\).
2. Find the file AnalyticsServerApp.exe.config and open it in a simple text editor such as Windows Notepad.
3. Find the following configuration key and set its value to false:
If the key does not exist, add it under the key , or above the key .
4. Save and close the file.
5. Restart the Enterprise Vault Accelerator Manager Service.