Forum Discussion

Y1251's avatar
Y1251
Level 5
7 years ago

Outlook Show "Enterprise Vault is unable to retrieve this archived item. "

Hi 

Please be informed that some of our users report that the message "Enterprise Vault is unable to retrieve this archived item. There was a problem opening this item. Try again later" will show when they retrieve the archive in VV.

This issue can be fix after reset the vault and it will happen again a few month.

Our EV server version is version Version: 11.0.1.3706 and our client version 32 bit Outlook 2010 & 64 bit Outlook 2016. The Client agent is v12.2.0.1437

May i have any suggestion?

Thx

 

 

 

  • Y1251's avatar
    Y1251
    Level 5
    7 years ago

    Hi,

    I also have the message "Database fragmentation levels" from EV server as below: is it cause this issue?

    ========================================================================================

    41561 Fragmentation warning for indexes of 'EVVSFileVaultStore2_9' on SQL server instance 'EVDBserver'.

    2 table(s) have one or more indexes with a fragmentation level of more than 30%.

    The 'EVVSFileVaultStore2_9' database is crucial to the operation of Enterprise Vault.

    High levels of fragmentation reduce the performance of Enterprise Vault.

    ========================================================================================

    • Gfry's avatar
      Gfry
      Level 3
      7 years ago

      The could be linked. If the retrieval request SQL times out then that could be explained by the SQL fragmentation. Run this script on your EV SQL server and look at the Fragmentation percentage of each index, anything greater than 30% is not good according to Microsoft.

      If you do have heavy SQL fragmentation then you should run a SQL maintenance task that at least has the following tasks:

      Rebuild Index

      Update Stats

      SELECT dbschemas.[name] as 'Schema', dbtables.[name] as 'Table', dbindexes.[name] as 'Index', indexstats.avg_fragmentation_in_percent as 'Fragmentation', indexstats.page_count as 'PageCount' FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS indexstats INNER JOIN sys.tables dbtables on dbtables.[object_id] = indexstats.[object_id] INNER JOIN sys.schemas dbschemas on dbtables.[schema_id] = dbschemas.[schema_id] INNER JOIN sys.indexes AS dbindexes ON dbindexes.[object_id] = indexstats.[object_id] AND indexstats.index_id = dbindexes.index_id WHERE indexstats.database_id = DB_ID() ORDER BY indexstats.avg_fragmentation_in_percent desc

      Realise the value in Enterprise Vault. ->www.cloudficient.com

       

       

      • Y1251's avatar
        Y1251
        Level 5
        7 years ago

        Hi Gfry,

        Thanks for your information, for workaround solution, is it can avoid the Fragmentation percentage over 30% if i restart the EV service in DB service? Because rebuild index may take some time.