• Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
Jul 182014
 

From time to time you may get into a situation where indexing in Enterprise Vault is lagging behind. It happened to me just the other day when ingesting a large amount of data into some test archives. I’m sure of the exact trigger, but the net result was that the indexing service stopped. This didn’t immediately cause me an issue, because the data was still added to the archive. But searching for the data was a bit tricky!

This can happen in a production environment too. Perhaps it’s something you’ve encountered, or had escalated to you from the IT Helpdesk?

A couple of handy SQL queries can help with figuring out if this is something that is affecting your environment:

select COUNT (*) from JournalArchive where IndexCommited = 0

The output in my environment looked like this:

Image
The second query is used to figure out which archives are affected. Sometimes that’s handy to know. That query is here:

select Records, ArchiveName
FROM
(select ArchivePoint .ArchivePointId, count(*) Records
from journalarchive
inner join ArchivePoint on ArchivePoint .ArchivePointIdentity = JournalArchive.ArchivePointIdentity
where indexcommited= 0
group by JournalArchive.ArchivePointIdentity , ArchivePoint.ArchivePointId) SQ
INNER JOIN EnterpriseVaultDirectory.dbo .ArchiveView ON ArchiveView.VaultEntryId = SQ.ArchivePointId
order by Records desc

And the output looks like this:

Image2

Of course in my environment it was a simple matter of starting the indexing service and waiting for it to catch up. It did take quite some time though.

Reference technote: http://www.symantec.com/business/support/index?page=content&id=HOWTO59167

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)