Random Sampling no longer occurs after upgrading Compliance Accelerator (CA) 11.0.1 to 11.0.1 CHF1

book

Article ID: 100032073

calendar_today

Updated On:

Description

Error Message

A Dtrace log of an EVCompliance process on the EV storage server shows the error message similar to the one below appear:
-----------------------------------
3805    09:08:15.465     [6676]    (EVCompliance)    <9328>    EV-H    {DataTransferTask} Exception: Procedure or function 'usps_ItemSamplingStatusLog' expects parameter '@StartSavesetIdentity', which was not supplied. Info:Failure when trying to process items from [Journal Vault Store01] Diag:Num:201 State:4 Sev:16 Svr:SQLServer.domain.com Proc:usps_ItemSamplingStatusLog Line:0 Type:System.Data.SqlClient.SqlException
-----------------------------------

Cause

The stored procedure 'usps_ItemSamplingStatusLog' in the Enterprise Vault (EV) Vault Store database from version 11.0.1 CHF 1 and higher was changed from its original version in 11.0.1. If the CHF installation/upgrade process did not update the stored procedure to its new version, the above error occurs upon stored procedure execution.

Resolution

From the EV server, run the EVDatabaseUpgrader.exe to ensure that all stored procedures are upgraded to the current version. To run the EVDatabaseUpgrader:

Note: Do not run more than one instance of Database Upgrader at a time.
  1. Stop all the Enterprise Vault services on all servers in the Enterprise Vault site. If more than one site uses the same Enterprise Vault Directory database, stop all Enterprise Vault services in all the sites.
  2. Log on as the Vault Service account to any Enterprise Vault server (or to the active node, if running Enterprise Vault in a clustered environment).
  3. Open a Command Prompt window with administrator privileges.
  4. Change to the Enterprise Vault installation folder (for example, C:\Program Files (x86)\Enterprise Vault).
  5. Type the command: EVDatabaseUpgrader.

If the problem persists or if the EVdatabaseupgrader.exe report that no updates were required, you will need to update the stored procedure manually via SQL.

Issue/Introduction

Random Sampling no longer occurs after upgrading EV and CA from 11.0.1 to 11.0.1 CHF1.
Powered by Wolken Software