Description

Note: The procedure described in this technote is specific to the Enterprise Vault 15.1/Veritas Surveillance 5.2 release.

In Enterprise Vault 15.1 Compliance Accelerator, when a new customer database is created, the Evidence of Review Asynchronous API may not work properly. To resolve this issue, perform the following steps manually.

1. In the Veritas Alta Surveillance installation directory, access the AcceleratorDatabasePrograms.sql file.
   (\Enterprise Vault Business Accelerator\AcceleratorDatabasePrograms.sql)

2. Open the AcceleratorDatabasePrograms.sql file, and locate the following stored procedures that are required for the Evidence of Review report:
   • usp_ProcessReportQueueTask
   • StartReportQueueJob
3. Connect to your SQL Server instance using SQL Server Management Studio (SSMS), and select the newly created customer.
4. Delete the stored procedures specified in step 2.
5. Copy the above-mentioned stored procedures.
6. Paste the copied stored procedures into a new query window in SSMS and execute them.
7. Execute the script to ensure the stored procedures usp_ProcessReportQueueTask and StartReportQueueJob are correctly created on the SQL Server.
8. Verify that the stored procedures are displayed in the new customer database.