Hello Nicola,
You say this error you receive happens for some items, but not all.
Does that mean that some users who are getting this error, when they doubleclick on other items within their mailbox, they come up fine? Or does a user who experiences this problem, get the error on all archived mail messages all the time?
I would recommend opening a case with support at this time.
The fact that some of the items have a .dvs and .archdvs file, simply means that the file has been accessed recently. When a dvs fie is extracted from a .CAB to be viewed, a temporary, .archdvs file is created.
Since you have been able to find the .dvs file, and it appears to be in the right location, the question is, why would EV think the file is not there? Perhaps it's because it's not pointing to the correct location, or associated with the correct CAB in SQL?
Is the ArchiveID and the DefaultWebAppURL listed the same for the shortcut items that retrieve correctly and those that do not?
To find the item in the Saveset table, see below:
1. In troubleshooting Enterprise Vault, it is important to know how archived items are referenced in SQL.
This can be determined by the ID.
Id: 818000000000000~200608161654500000~0~5897B02F698742588F202B3E4CDD96D
The of an item can be obtained by holding down Crtl/Shift while highlighting an archived item in Outlook, clicking on an EV icon on the toolbar, then selecting the Vault Information tab. The will be listed at the bottom. Copy the contents of Vault Information into Wordpad.
An alternate way of finding a SavesetID of an item would be to use Search.asp to find an item. The ID will be referenced in the URL.
The last part of the ID after the final tilde (~) is called the Transaction ID and is composed of 31 characters. Add a 0 to this number to make an even, 32 characters.
Example: Transaction ID with a 0 added
5897B02F-6987-4258-8F20-2B3E4CDD96D0
The Transaction ID is separated by dashes in the table in the following way: 8-4-4-4-12
Add hyphens (-) to this transaction id as in the example below:
5897B02F-6987-4258-8F20-2B3E4CDD96D0
Select * from where IdTransaction = '5897B02F-6987-4258-8F20-2B3E4CDD96D0'
One column to pay particular attention to - if this is an NTFS partition - is IdDateTime. This provides the folder structure for the .DVS file location. The NTFS partition folder structure is defined by:
Year
Month
Day
Hour
For example, the IdDateTime field for a is: 8/16/2006 4:54:50 PM, so the folder structure would be:
2006
8
16
16 (why 16? Because 4 pm gets changed to military time. 4 am would be the 4 folder. 16 is 4 pm,
military time)
2. What if I'm using NTFS Collections?
If performing NTFS Collections, the CAB file the .DVS file is located in will be required. This is also in the table in a column called CollectionIdentity.
Select Idtransaction, IdDateTime, CollectionIdentity from where IdTransaction = '5897B02F-6987-4258-8F20-2B3E4CDD96D0'
The CollectionIdentity value will be some numeric value (e.g. - 12589) The cab file will be called 12589.CAB.
You will find the .CAB files in Day directory of the Vault Store Partition.
Year
Month
Day
Note: If a query is performed and it returns a NULL value in the CollectionIdentity field, then this means that this particular has not been collected and is not in a .CAB.
3. Can I tell what archive my is in from SQL?
The table has two columns, VaultIdentity and ArchivePointIdentity. What's the difference? Over the years, Enterprise Vault terminology has changed. With the advent of structured archiving we now have to keep up with not only what archive the item is in, but also what folder within the archive the item is in.
ArchivePointIdentity = what archive my item is stored in
VaultIdentity = what folder within the archive my item is stored in.
A view called view_saveset_archive_vault gives you the corresponding ArchivePointID and VaultID for my .
SELECT IdTransaction, ArchivePointId, VaultID
FROM view_Saveset_Archive_Vault
WHERE (IdTransaction = '5897B02F-6987-4258-8F20-2B3E4CDD96D0')
From this query, you copy either the ArchivePointID or VaultID.
From the Vault Administration Console, select Ctrl/Shift while right clicking on the Archives Folder.
Select Find Archive or Folder
For example, this Vault ID is: 1AC57141529345643B4AB4A95E61671511110000EVSite.tech-support.local
Find Archive or Folder tells me that this Vault ID is associated with the Inbox folder of user1's archive.
Note: Notice that the Vault ID is referenced as "Archive Folder ID" and ArchivePointID is referenced as
"ArchiveID"
Archive Folder ID: 1AC57141529345643B4AB4A95E61671511110000EVSite.tech-support.local
Folder Name: Inbox
Folder Path: \Inbox
===== Parent Archive details ======
Archive ID: 19B9A778E11178E478083FA440337F7001110000EVSite.tech-support.local
Archive Name: user1
Archive Description: Default for user1
Archive Admin Note:
Archive Type: Mailbox
===== Mailbox details ======
Legacy Mailbox DN: /o=First Organization/ou=First Administrative Group/cn=Recipients/cn=user1
Mailbox Display Name: user1
Mailbox Alias: user1
NT User: user1
NT Domain: TECH-SUPPORT
