IndexCommit = 0 produces items for 1 user

[Sani_B]

Hi,

Originally I started to investigate a problem items stuck in "waiting for bu".

So I ended up checking all kinds of things and also ran the query to see the indexing situation. I got the main problem solved but now nothing in the VAC is alarming about anything etc but there are Items as a result of this query:

SELECT A.ArchiveName "Archive Name",

CE.ComputerName "Index Server",

(IRP.IndexRootPath + '\' + IV.FolderName) "Folder Path",

COUNT(JA.IndexCommited) "Items Awaiting Index",

IV.Failed "Index Failed",

IV.ReadOnly "Index ReadOnly",

IV.Offline "Index Offline",

IV.Rebuilding "Index Rebuilding",

IV.WorkPending "Work Pending"

FROM EnterpriseVaultDirectory.dbo.Archive A,

EnterpriseVaultDirectory.dbo.Root R,

EnterpriseVaultDirectory.dbo.IndexVolume IV,

EnterpriseVaultDirectory.dbo.IndexRootPathEntry IRP,

EnterpriseVaultDirectory.dbo.IndexingServiceEntry ISE,

EnterpriseVaultDirectory.dbo.ComputerEntry CE,

EVVSVaultStore_1.dbo.ArchivePoint AP,

EVVSVaultStore_1.dbo.JournalArchive JA

WHERE JA.ArchivePointIdentity = AP.ArchivePointIdentity

AND AP.ArchivePointId = R.VaultEntryId

AND R.RootIdentity = A.RootIdentity

AND R.RootIdentity = IV.RootIdentity

AND IV.IndexRootPathEntryId = IRP.IndexRootPathEntryId

AND IRP.IndexServiceEntryId = ISE.ServiceEntryId

AND ISE.ComputerEntryId = CE.ComputerEntryId

AND JA.IndexCommited = 0

GROUP BY A.ArchiveName, CE.ComputerName,

(IRP.IndexRootPath + '\' + IV.FolderName),

IV.Failed, IV.ReadOnly, IV.Offline,

IV.Rebuilding, IV.WorkPending

ORDER BY "Items Awaiting Index" DESC

Archive Name	Index Server	Folder Path	Items Awaiting Index	Index Failed	Index ReadOnly	Index Offline	Index Rebuilding	Work Pending
Username	EVarchive.company.com	E:\Index\index2\190F47D836DDB1840A29C361F9B782BD9_1502	1283	0	0	0	0	1

 I have verified, synchronized and eventually even rebuilt the index of this user and still this remains. And the number is groving so it looks like the newly archived ites also go to this queue. How do I force this to work and not be pending?

The ev version is 10.0.4 / OS win server 2012 R2 standard

As I said, from the console it looks like the index is fine etc but this tells a different story... any suggestions?

Sani B.

[Sani_B]

Hi Ben,

I opened a case with the support about this problem. Once we get it solved I shall update this thread to make the solution available if someone else is experiencing the same problem in the future.

[Sani_B · Accepted solution]

Ok so the solution was to remove the first stuck item from the users archive with some sql query. After that the  rest of the items in queue was indexed normally and the problem has been solved.

Thank you for all for your help!

Sani B.