Forum Discussion

EVKydd's avatar
EVKydd
Level 4
9 years ago

Journal Archive Oldest/youngest item date NULL

Hi All,   I need to figure out which Journal archives can be deleted by looking at the oldest and youngest item in the archive. When I run the sql query to pull the oldestitemdateUTC and Younge...
Enterprise Vault
Information Governance
Processing
Search & Analysis
Windows Server (2003-2008)
  • AndrewB's avatar
    AndrewB
    9 years ago

    it depends on why they show null. off the top of my head, could be a bunch of malformed email in your archive or it could have been an indexing issue in which case the way to fix it would be to repair/reindex.

    have you upgraded all your index volumes to 64bit?

    have you looked in index manager to see if any have issues?

GertjanA's avatar
GertjanA
Moderator
9 years ago

It might have been that someone has deleted indexlocations of 'really old' archives, to free up diskspace.

(been there)

Only way to get that info is as Andrew says, repair/sync/rebuild those indexes. (which might not be worth the effort)