Overview:
When a user opens Outlook and shows the folder list under Inbox, and compares this with the folder list in Archive Explorer, there may be discrepancies between these views and Archive Explorer may not show all of the folders that should be available in the archive.

Archive Explorer constructs this view from the SQL EnterpriseVaultDirectory database.  Under Views and within the ArchiveFolderView (which is a custom display of the ArchiveFolder, ArchiveRoot, ArchiveFolderRoot and Trustee tables), all folders for all users are referenced.  

First, it must be confirmed that Archive Explorer is displaying all folders that are returned from SQL. This will determine if the issue is due to invalid information within SQL.

1. Open Internet Explorer and enter the following URL:
http://EVServername/EnterpriseVault/TreeViewXML.asp?archiveid=UserArchiveID&version=1

Note: EVServername is the Server Alias of the Enterprise Vault Server, used to access the server over the network.  UserArchiveID is the user's Archive ID which is determined within the Enterprise Vault Administration Console on the Advanced tab of the Archive Properties.

This page displays the raw content returned from SQL showing all the folders that were found to be associated with the archive.  This is then translated into HTTP format and displayed by ArchiveExplorerUI.asp.  The issue referenced below discusses how to resolve this issue if this page also does not return all folders assigned to the Archive, and Archive Explorer displays only the folders returned by the TreeViewXML.asp page.

2. To determine all folders assigned to a unique Archive ID run the following SQL query:

 

USE EnterpriseVaultDirectory
 

SELECT * from ArchiveFolderView
 

WHERE ArchiveVEID = 'UserArchiveID'
 

Note: UserArchiveID is the user's Archive ID which is determined within the Enterprise Vault Administration Console on the Advanced tab of the Archive Properties.

Within the ArchiveFolderView table, each folder will be assigned a RootIdentity (a unique number that will represent it) and will refer to the ParentFolderRootIdentity (the RootIdentity is a child of the ParentFolderRootIdentity) Every archive's first folder will be Top of Information Store, followed usually by Inbox.  Every folder listed within the ArchiveFolderView will have a RootIdentity and a ParentFolderRootIdentity, except the Top of Information Store folder which, since it is the 'First' folder, should not have a ParentFolderRootIdentity.  The Top of Information Store folder will instead have a NULL value for ParentFolderRootIdentity, showing that it is the top of the archive with no folders above it. (Figure 1)

Figure 1
 

Discrepancies may occur in Archive Explorer if there are multiple references to Top of Information Store assigned to the same archive AND if one or more of these entries have a RootIdentity referenced in the ParentFolderRootIdentity, rather than NULL.  If the Top of Information Store value has a value for ParentFolderRootIdentity, rather than NULL, this folder and any folder that has a ParentFolderRootIdentity associated with the RootIdentity of this Top of Information Store value, will not be trawled and all folders and individual items that have been archived under these folders will not be displayed in Archive Explorer.

3. To display all instances of Top of Information Store that are assigned to a specific Archive ID run the following SQL query:

 

USE EnterpriseVaultDirectory
 

SELECT * from ArchiveFolderView
 

WHERE ArchiveVEID = 'UserArchiveID'
 

AND FolderName = 'Top of Information Store'
 

Note: UserArchiveID is the user's Archive ID which is determined within the Enterprise Vault Administration Console on the Advanced tab of the Archive Properties.

4. The following SQL script can be run against all archives to check for any references to Top of Information Store which do not have NULL for the ParentFolderRootIdentity:
 

 

USE EnterpriseVaultDirectory
 

SELECT * from ArchiveFolderView
 

WHERE FolderName = 'Top of Information Store'
 

AND ParentFolderRootIdentity IS NOT NULL
 

Resolution:

In order to resolve this issue, the associated ParentFolderRootIdentity for the Top of Information Store value must be set to NULL.  Run the following SQL script to set the value to NULL.

 

USE EnterpriseVaultDirectory
 

UPDATE ArchiveFolderView  

 

SET ParentFolderRootIdentity = NULL
 

WHERE ParentFolderRootIdentity = 'Current_Invalid_Value'
 

AND FolderName = 'Top of Information Store'

 

Note: UserArchiveID is the user's Archive ID which is determined within the Enterprise Vault Administration Console on the Advanced tab of the Archive Properties. Current_Invalid_Value will be the current value of the ParentFolderRootIdentity.

This will allow Archive Explorer to trawl all Top of Information Store structures and display all folders under all Top of Information Store values, which will then allow indexing to return all items that have been archived under these folders.