Converting archives from unstructured to structured in Enterprise Vault (EV) 6.0 Service Pack 1 (SP1) and later.
Article ID: 100017671
Updated On:
Cause
Prior to EV 6.0 SP1, Mailbox Archives were constructed by default to be Unstructured. In EV 6.0 SP1, this default behavior has changed to allow new Mailbox Archives created in a Structured format.
A Structured format allows for the view of a Mailbox Archive through the Archive Explorer Web Application to display an archive with a folder structure.
Resolution
The convertarchive.htm utility was available prior to the release of EV 6.0 Service Pack 1 (SP1). This tool was used to convert archives from an unstructured format to a structured format. Due to changes in the way indexes are used in EV 6.0 SP1 and upwards, this utility is no longer available. This document outlines the steps to convert archives if there has been an upgrade to a version later than EV 6.0 GA and archives have not been converted.
Note: The intent of this documentation is to convert Exchange Mailbox Archives from Unstructured to Structured.
How to determine if index is structured
1. Note the name of the archives that need to be converted from the Archives > Mailbox section in the Vault Administration Console (VAC).
2. Open SQL Enterprise Manager.
4. Navigate to the EnterpriseVaultDirectory database and select Tables.
5. Right-click on the Archive table and select Open Table > Return All Rows.
6. On the toolbar, click on the SQL icon to open the scripting window.
7. Type the following script:
How to determine if index is structured
1. Note the name of the archives that need to be converted from the Archives > Mailbox section in the Vault Administration Console (VAC).
2. Open SQL Enterprise Manager.
4. Navigate to the EnterpriseVaultDirectory database and select Tables.
5. Right-click on the Archive table and select Open Table > Return All Rows.
6. On the toolbar, click on the SQL icon to open the scripting window.
7. Type the following script:
select * from archive where archivename = 'Name noted down in step1' 8. Click on the exclamation mark to run the query. The result received should match the specific archive.
Note down the value under the column RootIdentity of the result which matches the archive
9. Locate the Structured column and check the value listed. If it is unstructured this value will be 0, if it is structured this value will be 1.
Note: If the value obtained in step 9 is 0, change this to 1, but only after checking that the storage restore and storage archive MSMQs are at 0. To do this, open Computer Management, expand Services and Applications > Message Queuing and select Private Queues. All of the Enterprise Vault MSMQs and the number of messages on each one will be visible. If the queues are not at 0, use the Refresh button until they are at 0.
9. Locate the Structured column and check the value listed. If it is unstructured this value will be 0, if it is structured this value will be 1.
Note: If the value obtained in step 9 is 0, change this to 1, but only after checking that the storage restore and storage archive MSMQs are at 0. To do this, open Computer Management, expand Services and Applications > Message Queuing and select Private Queues. All of the Enterprise Vault MSMQs and the number of messages on each one will be visible. If the queues are not at 0, use the Refresh button until they are at 0.
Prior to running the query below, make sure all instances of the Vault Administration Console are closed as this can cause the setting to be reverted.
10. Change value to 1 by running the below query
update archive
set Structured = '1'
where rootidentity =
11. Exit SQL Enterprise Manager.
How to rebuild index so that it is structured
Please note that if you're attempting to rebuild an archive in Enterprise Vault 8 and later, you can go directly to the Archive properties for the Archive you wish to structure, select the Index Volumes tab, and rebuild all the Index Ranges for that Archive. Otherwise, use the procedure below for Enterprise Vault 2007 and earlier.
1. Open up the VAC.
2. Locate the archive used in the above procedure by going to Archives > Mailbox.
3. Right-click on the archive name and choose Properties.
4. Select the Advanced tab.
5. Copy the Archive ID at the bottom of the tab (Figure 1).
Figure 1
5. Go to the EV directory (C:\Program Files\Enterprise Vault by default).
6. Run IndexVolumeReplay.exe.
7. Paste the Archive ID obtained in step 5 into the EV Directory Computer or Archive Entry ID field.
8. Select the All Volumes radio button and click on Search (Figure 2).
Figure 2
9. Right-click on VolumeID= and select Rebuild Index.
10. Click Yes to rebuild and then OK to the Successfully submitted information message.
The status of the rebuilding index can be monitored via two methods:
- Select the search by Index Volume Status radio button and check Rebuilding only. Select Search and keep clicking Search until the archive disappears from the pane below.
- Monitor the Enterprise Vault Event Log. A 7294 information entry will be logged to denote the start of the index volume rebuild and a 7295 information entry will be logged to denote the completion of the index volume rebuild.
Note: Please be aware then the time it takes to rebuild an archive depends on the amount of data that needs to be indexed.
12. Check the structure of the archive in Archive Explorer. The folder view should now be visible.
Note: It may be necessary to right-click in the Archive Explorer window an choose Refresh to update the view.
How to check that all newly created archives are created as structured by default
1. Open SQL Enterprise Manager.
2. Expand the EnterpriseVaultDirectory database and select Tables.
3. Right-click the SiteEntry table and select Open Table > Return all rows.
4. Find the column named CreateStructuredArchives.
5. Set the value to 1 to have all new archives created as structured archives.
6. Restart the Enterprise Vault Admin Service.
Issue/Introduction
Converting Enterprise Vault Mailbox archives from unstructured to structured in Enterprise Vault (EV) 6.0 Service Pack 1 (SP1) and later.
Was this article helpful?
Yes
No
Powered by
