Hotfix for Symantec Enterprise Vault (EV) Discovery Accelerator (DA) 10.0.1, Build 10.0.1.1069, Suspect memory leak in the AcceleratorService process during DA searches.

Article:TECH187349  |  Created: 2012-04-25  |  Updated: 2014-06-24  |  Article URL http://www.symantec.com/docs/TECH187349
Article Type
Technical Solution


Issue



Which version of Symantec Enterprise Vault (tm) Discovery Accelerator (DA) can this hotfix be applied?
This hotfix can only be applied to the following versions of Enterprise Vault for:
 
Enterprise Vault Discovery Accelerator 10.0.1, Build 10.0.1.1069


Solution



What issue(s) does this hotfix resolve?
Out of memory errors and high AcceleratorService.exe process memory usage while running Discovery Accelerator (DA) searches of very large numbers (i.e., over 5000) of index volumes .


Which files does this hotfix replace? 

File Name File Version New File Version
AcceleratorCommon.dll 10.0.1.1069

10.0.1.1070

AcceleratorInterfaces.dll 10.0.1.1069

10.0.1.1070

AcceleratorSearch.dll 10.0.1.1069

10.0.1.1070

Which new files are included:

File Name File Size File Date
EV 2732721_CustomerDB_ApplyHF.Sql 10 KB

3/29/2012 4:48 PM

ET 2732721_CustomerDB_RemoveHF.SQL 1 KB

3/29/2012 4:48 PM


How to Install this hotfix:

Preliminary Installation Instructions
=========================

Save the hotfix compressed file, "CADA_10.0_ET2732721-MemoryIssue due to Many IndexVolumes in Searches.zip",  and extract its contents to a resource that will be available to the SQL Server hosting the appropriate databases and the Accelerator server(s).  Copy the extracted '.sql' files to the SQL Server.  Copy the '.dll' files to the Accelerator server(s).

Recommended procedure is:
*** On a workstation with a decompression program, such as WinZip or 7-Zip ***
1. Log on using an account that has access to copy files to a folder on the Compliance Accelerator (CA) or Discovery Accelerator (DA) server and the SQL Server hosting the CA/DA customer databases (such as the Vault Service Account).
2. Create a folder named "HotfixET2732721" on a local drive.
3. Save the hotfix file 'CADA_10.0_ET2732721-MemoryIssue due to Many IndexVolumes in Searches.zip' to the "HotfixET2732721" folder.
4. Extract the contents of the hotfix file to the 'HotfixET2732721" folder.
   1. The extracted files will be
      1. AcceleratorCommon.dll.SAFE
      2. AcceleratorInterfaces.dll.SAFE
      3. AcceleratorSearch.dll.SAFE
      4. ET 2732721_CustomerDB_ApplyHF.Sql.SAFE
      5. ET 2732721_CustomerDB_RemoveHF.SQL.SAFE
      6. Hotfix Details Etrack 2732721.txt
      7. Hotfix Etrack 2732721 Installation and Removal Instructions.txt   <--- this file
5. Rename all of the files with the '.SAFE' extension by removing the '.SAFE' extension.  The resultant file names for all of the files should be:
      1. AcceleratorCommon.dll
      2. AcceleratorInterfaces.dll
      3. AcceleratorSearch.dll
      4. ET 2732721_CustomerDB_ApplyHF.Sql
      5. ET 2732721_CustomerDB_RemoveHF.SQL
      6. Hotfix Details Etrack 2732721.txt
      7. Hotfix Etrack 2732721 Installation and Removal Instructions.txt   <--- this file
6. Copy the following extracted files to the SQL Server hosting the CA or DA customer database(s)
   1. ET 2732721_CustomerDB_ApplyHF.Sql
   2. ET 2732721_CustomerDB_RemoveHF.SQL
7. Copy the following extracted files to the CA or DA server:
      1. AcceleratorCommon.dll
      2. AcceleratorInterfaces.dll
      3. AcceleratorSearch.dll

Detailed Installation Instructions
=========================
*** On each workstation where the Compliance Accelerator (CA) and / or Discovery Accelerator (DA) Client is installed ***
1. Close all open CA or DA Clients.

*** On the Compliance Accelerator (CA) or Discovery Accelerator (DA) server ***
2. Log on as the Vault Service Account (VSA).
3. Launch the Services application.
4. Select the Enterprise Vault Accelerator Manager Service (EVAMS).
5. Stop EVAMS.
6. Launch Windows Explorer.
7. Navigate to the CA or DA installation folder.
   1. On 32-bit Windows, the default path is 'C:\Program Files\Enterprise Vault Business Accelerator'.
   2. On 64-bit Windows, the default path is 'C:\Program Files (x86)\Enterprise Vault Business Accelerator'.
8. Make a backup copy of the files listed in the "Files updated" section (3 files), located in the Compliance Accelerator / Discovery Accelerator server installation folder.
   1. Locate and select the file "AcceleratorCommon.dll".
   2. Right click and select the Rename option.
   3. Add ".PreET2732721" to the end of the file name (i.e., filename changes from "AcceleratorCommon.dll" to "AcceleratorCommon.dll.PreET2732721").
   4. Press the Enter key to save the name change.
   5. Repeat Steps 8.1 through 8.4 for the files "AcceleratorInterfaces.dll" and "AcceleratorSearch.dll".
   6. When complete, the following files will be in the CA or DA installation folder:
      1. AcceleratorCommon.dll.PreET2732721
      2. AcceleratorInterfaces.dll.PreET2732721
      3. AcceleratorSearch.dll.PreET2732721
9. Make a backup copy of the file "AcceleratorService.exe.config".
   1. Locate and select the file "AcceleratorService.exe.config".
   2. Right click on the file and select the Copy option.
   3. Right click anywhere in the CA or DA installation folder.
   4. Click the Paste option.
   5. Locate and select the copy file (i.e., on Windows Server 2008 R2, the copied file will be named 'AcceleratorService.exe - Copy.config').
   6. Right click on the file and select the Rename option.
   7. Rename the file to be "AcceleratorService.exe.config.PreET2732721".
10. Select the following hotfix files from the folder of Step 6 in the 'Preliminary Installation Instructions' section above and copy them into the CA or DA installation folder, which will replace the 
originals that were renamed to end in '.PreET2732721:
   1. AcceleratorCommon.dll
   2. AcceleratorInterfaces.dll
   3. AcceleratorSearch.dll
11. Edit the AcceleratorService.exe.config file in the CA or DA installation folder to add 3 new entries:
   1. Open the 'AcceleratorService.exe.config' file in NotePad for editing
   2. Locate the following line in the top 1/3rd of the file:

         </appSettings>

   3. Insert 3 blank lines above this line.
   4. Add the following command and 2 key lines in the blank lines:
         <!-- The following 2 keys, SearchesRunPerSecond and MaxSearchesToReadPerIndexVolume, are for Etrack 2732721 hotfix usage only. -->

         <add key="SearchesRunPerSecond" value="10" />
         <add key="MaxSearchesToReadPerIndexVolume" value="5" />

   5. Save and close the file.

*** On the SQL Server hosting the CA or DA Customer database(s) ***
12. Run the sql file "ET 2732721_CustomerDB_ApplyHF.Sql" against each Discovery/Compliance Accelerator customer database.  Note: If the hotfix from TECH187335 for DA 10.0 (Base) has been installed, the stored procedure "usp_VaultSearches_Sel_Original" must first be deleted as it is no longer needed and will be replaced by the actions in this step.  See the Related Documents section below for TECH187335.
   1. Log on using an account with permissions to modify the CA or DA Customer database(s), such as the Vault Service Account (VSA).
   2. Launch and log into the SQL Sever Management Console.
   3. Expand Databases.
   4. Select and right click on the CA or DA Customer database.
   5. Select the 'New Query' option to see a query window open in the right pane.
   6. Locate and use NotePad to open the file 'ET 2732721_CustomerDB_ApplyHF.Sql' that was copied to the SQL Server in Step 5 of the Preliminary Installation Instructions section above.
   7. Select the entire contents of the file and copy them to Clipboard.
   8. Paste the contents of the file into the query window of Step 12.5 above.
   9. Click the 'Execute' button to run the script.
   10. Monitor the script execution until completed.
>> Note:
      The following information may be displayed in the Messages section under the query window:
            Caution: Changing any part of an object name could break scripts and stored procedures.
      This information may be safely ignored as the renamed object is recreated with the original name by the script.
   11. Repeat Steps 12.1 to 12.10 for each CA or DA Customer database.
   12. Close SQL Server Management Studio, electing to not save the contents of the query window.
   13. Log off of the SQL Server.

*** On the Compliance Accelerator (CA) or Discovery Accelerator (DA) server while still logged in as the VSA ***
13. Start the Enterprise Vault Accelerator Service:
   1. Select the Services application used in Step 4 above.
   2. Select the Enterprise Vault Accelerator Manager Service (EVAMS).
   3. Start EVAMS.

At this point, any open applications on the CA or DA server - such as NotePad, Services, and Windows Explorer - can be closed and the VSA logged off of the CA or DA server; however,  remaining logged on so the Task Manager can be used to monitor the memory usage of the AcceleratorService.exe processes while searches are running is recommended until such time as the effectiveness of the hotfix can be confirmed.

How to Uninstall this hotfix:

Removal Instructions Overview
===========================

- Take the backed up copy of the files listed in the "Files updated" section plus "AcceleratorService.exe.config" and replace the hotfixed files, locatable in the Discovery/Compliance Accelerator  Server installation folder.
- Run the sql file "ET 2732721_CustomerDB_RemoveHF.SQL" against each Discovery/Compliance Accelerator customer database.
- Start the Enterprise Vault Accelerator Service.

Detailed Removal Instructions
===========================

*** On each workstation where the Compliance Accelerator (CA) and / or Discovery Accelerator (DA) Client is installed ***
1. Close all open CA or DA Clients.

*** On the Compliance Accelerator (CA) or Discovery Accelerator (DA) server ***
2. Log on as the Vault Service Account (VSA).
3. Launch the Services application.
4. Select the Enterprise Vault Accelerator Manager Service (EVAMS).
5. Stop EVAMS.
6. Launch Windows Explorer.
7. Navigate to the CA or DA installation folder.
   1. On 32-bit Windows, the default path is 'C:\Program Files\Enterprise Vault Business Accelerator'.
   2. On 64-bit Windows, the default path is 'C:\Program Files (x86)\Enterprise Vault Business Accelerator'.
8. Restore the original copy of the files listed in the "Files updated" section (3 files), located in the Compliance Accelerator / Discovery Accelerator server installation folder.
   1. Locate and select the file "AcceleratorCommon.dll".
   2. Right click and select the Rename option.
   3. Add ".ForET2732721" to the end of the file name (i.e., filename changes from "AcceleratorCommon.dll" to "AcceleratorCommon.dll.ForET2732721").
   4. Press the Enter key to save the name change.
   5. Repeat Steps 8.1 through 8.4 for the files "AcceleratorInterfaces.dll" and "AcceleratorSearch.dll".
   6. When complete, the following files will be in the CA or DA installation folder:
      1. AcceleratorCommon.dll.ForET2732721
      2. AcceleratorInterfaces.dll.ForET2732721
      3. AcceleratorSearch.dll.ForET2732721
   7. Locate the original copy of the files listed in the "Files updated" section (3 files), that end in '.PreET2732721'.
   8. Remove the '.PreET2732721' extension from each of the 3 files.
   9. When complete, the following files will be in the CA or DA installation folder:
      1. AcceleratorCommon.dll          <-- original CA or DA 10 file
      2. AcceleratorInterfaces.dll          <-- original CA or DA 10 file
      3. AcceleratorSearch.dll          <-- original CA or DA 10 file
      4. AcceleratorCommon.dll.ForET2732721          <-- hotfix file from Etrack 2732721
      5. AcceleratorInterfaces.dll.ForET2732721          <-- hotfix file from Etrack 2732721
      6. AcceleratorSearch.dll.ForET2732721          <-- hotfix file from Etrack 2732721
9. Restore the original copy of the file "AcceleratorService.exe.config".
   1. Locate and select the file "AcceleratorService.exe.config".
   2. Right click on the file and select the Rename option.
   3. At the end of the file name, add '.ForET2732721'
   4. Press the Enter key to save the name change.
   5. Locate and select the original copy of the file (i.e., "AcceleratorService.exe.config.PreET2732721" from Step 9.7 of the Detailed Installation Instructions section above).
   6. Right click on the file and select the Rename option.
   7. Rename the file to remove the '.PreET2732721' extension, to the file name will be returned to "AcceleratorService.exe.config".

*** On the SQL Server hosting the CA or DA Customer database(s) ***
10. Run the sql file "ET 2732721_CustomerDB_RemoveHF.SQL" against each Discovery/Compliance Accelerator customer database.
   1. Log on using an account with permissions to modify the CA or DA Customer database(s), such as the Vault Service Account (VSA).
   2. Launch and log into the SQL Sever Management Console.
   3. Expand Databases.
   4. Select and right click on the CA or DA Customer database.
   5. Select the 'New Query' option to see a query window open in the right pane.
   6. Locate and use NotePad to open the file 'ET 2732721_CustomerDB_RemoveHF.SQL' that was copied to the SQL Server in Step 5 of the Preliminary Installation Instructions section above.
   7. Select the entire contents of the file and copy them to Clipboard.
   8. Paste the contents of the file into the query window of Step 10.5 above.
   9. Click the 'Execute' button to run the script.
   10. Monitor the script execution until completed.
>> Note:
      The following information may be displayed in the Messages section under the query window:
            Caution: Changing any part of an object name could break scripts and stored procedures.
      This information may be safely ignored as the renamed object is recreated with the original name by the script.
   11. Close SQL Server Management Studio, electing to not save the contents of the query window.
   12. Log off of the SQL Server.

*** On the Compliance Accelerator (CA) or Discovery Accelerator (DA) server while still logged in as the VSA ***
11. Start the Enterprise Vault Accelerator Service:
   1. Select the Services application used in Step 3 above.
   2. Select the Enterprise Vault Accelerator Manager Service (EVAMS).
   3. Start EVAMS.

At this point, any open applications on the CA or DA server - such as NotePad, Services, and Windows Explorer - can be closed and the VSA logged off of the CA or DA server.  The hotfix files may also be deleted from the EV and SQL servers as appropriate.

 


Attachments

CADA_10.0.1_ET2732721--MemoryIssue due to Many IndexVolumes in Searches.zip
CADA_10.0.1_ET2732721--MemoryIssue due to Many IndexVolumes in Searches.zip (862 kBytes)

Supplemental Materials

SourceETrack
Value2732721
Description

Suspect memory leak in the AcceleratorService process during DA searches.




Article URL http://www.symantec.com/docs/TECH187349


Terms of use for this information are found in Legal Notices