No random sampling items in the Review Set.

book

Article ID: 100043119

calendar_today

Updated On:

Description

Error Message

From the Enterprise Vault Event Viewer on the CA server:

EventID: 272
Description:
APP AT - Customer ID: x - Guaranteed Sampling: Error during guaranteed sampling - aborting. System.Data.SqlClient.SqlException: Cannot open database "" requested by the login. The login failed.Login failed for user '{Domain}\{User}'.

 

Cause

SQL server hosting the  database or the database is not reachable by the CA service.

 

Resolution

1.     From the SQL server, make sure the SQL Server Management Studio (SSMS) is accessible via the Vault Service Account (VSA) and the SQL database is online.
2.     From the CA server's Services MMC snap-in, ensure the Enterprise Vault Accelerator Manager Service (EVAMS) is started.
3.     If the problem persists, go to the Properties of EVAMS and click on the Logon tab.
4.     Reset the VSA password and restart EVAMS.

 

Please assign this ticket to Sammy Champavannarath as he is familiar with our environment

Issue/Introduction

Compliance Accelerator (CA) Random Sampling started, but failed to process archived items waiting to be sampled. As a result, no item was captured and put in the Review Set.