10-12-2017 04:24 AM
We have a user who can't see any items in his archive explorer. It just says 'there are no items to show in this view'
The usage report shows lots of items there and resynced his archive without issue.The index volumes browser shows his indexes as healthy. Going to try and verify the indexes in any case.
Is there anything else that can cause this behaviour?
10-12-2017 09:46 AM
The items in the right-hand pane of AE should be the result of querying the index for the folder that is clicked in the tree-view.
Can that archive be searched from the Search page and return results? Is the server busy or low on resources?
What version of EV?
10-17-2017 01:30 AM
@ashks2014 while you run a verify on the index volumes, you may also run a SQL query to find which folders contain the items. The user may have moved emails under specific folders in the archive and has simply not selected the same folder in Archive Explorer.
Run the query against the Vault Store Database holding the users archive and replace 'Your ARCHIVE NAME' with the user's archive name. Then try and browse the folders which show the maximum number of items in Archive Explorer.
,CAST(AF.FolderPath AS NVARCHAR(MAX))
,COUNT(S.IdTransaction) "Number of Archived Items"
,rc.RetentionCategoryName AS "Retention Category"
,SUM(S.ItemSize) "Total Size (KB)"
FROM Saveset S,
WHERE S.VaultIdentity = V.VaultIdentity
AND S.ArchivePointIdentity = AP.ArchivePointIdentity
AND AP.ArchivePointID = R.VaultEntryID
AND V.VaultID = R2.VaultEntryID
AND R.RootIdentity = A.RootIdentity
AND R2.RootIdentity = AF.RootIdentity
AND rc.RetentionCategoryIdentity = s.RetentionCategoryIdentity
AND A.ArchiveName = 'Your ARCHIVE NAME'
GROUP BY A.ArchiveName, CAST(AF.FolderPath AS NVARCHAR(MAX)),AF.FolderName, rc.RetentionCategoryName
10-17-2017 02:29 AM
Have you read the following technote ?
10-20-2017 03:26 AM
it can also be the profile of the user that could be troublesome.
Let him login from another pc/laptop with his own credentials and see if he can see the items from there.
Can you see his archived files his archive when you give yourself permissions?