How to find the Compliance Accelerator or Discovery Accelerator version Information

Description

Troubleshooting Compliance Accelerator (CA)/Veritas Advanced Surveillance (VAS) and Discovery Accelerator (DA) issues occasionally require checking the version information of the installed Accelerator product. This article provides a listing of the CA/VAS and DA version information.

Below is a listing of the versions for CA/VAS and DA.  After verification of the binaries on the CA/VAS or DA server, it is imperative that the schema version of the Configuration and Customer databases both match appropriately. Any differences will result in loss of functionality within the product.

It is crucial that component versions are at the same CA/VAS or DA product/schema version across all CA/VAS/DA/SQL servers.  A mismatch could have occurred because of a partial or failed upgrade. See the installation Guide or Upgrade Documents to assist with confirming a successful upgrade or new installation.

To find the database schema for either CA/VAS or DA Configuration databases, look in the Configuration database's tblVersion table using the following SQL query:

SELECT Version FROM tblVersion

To find the database schema for either CA/VAS or DA Customer databases, look in the Customer database's tblConfig table using the following SQL query:

SELECT [Key], [Value]
FROM [dbo].[tblConfig]
WHERE [Key] LIKE 'Database Version'

Also, the Customer database version can be checked against the Configuration database by running the following SQL query:

SELECT [CustomerID] AS 'Customer ID Number', [Name] AS 'Customer Name',
[Version] AS 'Database Version', [InitialCatalog] AS 'Database Name'
FROM [dbo].[tblCustomer]
WHERE [CustomerID] > 1      -- CustomerID 1 is the System customer

Note: Not all of the below-listed versions are supported.  For End of Life and End of Support Life information, please visit the Product Life Cycle information page.

To obtain the installed version of CA/VAS, check the registry on the CA server for the Version value at the following location:

• For 32-bit Windows Operating System:

HKEY_LOCAL_MACHINE\Software\KVS\Compliance Accelerator\Install

• For 64-bit Windows Operating System:

HKEY_LOCAL_MACHINE\Software\Wow6432Node\KVS\Compliance Accelerator\Install

To obtain the installed version of DA, check the registry on the DA server for the Version value at the following location:

• For 32-bit Windows Operating System:

HKEY_LOCAL_MACHINE\Software\KVS\Discovery Accelerator\Install

• For 64-bit Windows Operating System:

HKEY_LOCAL_MACHINE\Software\Wow6432Node\KVS\Discovery Accelerator\Install

Note: a mismatch between the Value in the customer database and the Value in the configuration database for a customer indicates the customer database will not work with the installed CA/VAS or DA version until some action has been completed.  Contact Enterprise Vault Support for assistance in taking the appropriate action.

Important CA/VAS Notes:

1. When upgrading from CA/VAS 14.5.1 to 14.5.2, there are no database schema changes. As such, there is no database upgrade required for the Configuration or Customer databases. It is required to upgrade the Clients from 14.5.1 to 14.5.2.

Compliance Accelerator Versions Information Table

Important DA Notes:

1. When upgrading from DA 14.5.1 to 14.5.2, there are no database schema changes. As such, there is no database upgrade required for the Configuration, Customer or Custodian Manager databases. It is required to upgrade the Clients from 14.5.1 to 14.5.2.

Discovery Accelerator Versions Information Table

 For the Enterprise Vault versions information, see 100020901 in the Related Articles section below.