08-28-2012 06:08 AM
Within the last couple of weeks one of my vault store DBs started showing error 41021. Then the rest started showing the error.
I have ran a couple of SQL Queries that have been posted like:
Both of course return results. the first query shows that the archived items are not being committed.
We have done a lot of the basic troubleshooting, restarting servers...firewalls...nothing has helped to bring the numbers down.
I see a lot of stuff on finding the issues but not resolving it.
Any suggestions?
We are running EV 10.0.1
SQL = 2005
Solved! Go to Solution.
08-28-2012 06:55 AM
Is this a new install of EV or is it an old install from EV9 or below to EV10?
If its an older version, is it the old 32bit index or have you converted the index to 64bit indexing?
Really though i think you're going to have to get a dtrace to see whats going on.
Is there anything in the event viewer related to indexing?
And did anything happen in the environment when this started happening?
You should be able to find the first item that is awaiting indexing in the JournalArchive table, there should be a submitdate or something like that
so like
SELECT TOP 1 SubmitDate FROM JournalArchive WHERE IndexCommited = 0 ORDER BY SubmitDate ASC
08-28-2012 06:18 AM
08-28-2012 06:22 AM
Didnt think to give all the info.
its Mail archives.
None of the indexes are in backup mode. I ran a sql query to be sure.
Search does work. but searching for key words in recent items are not shown.
08-28-2012 06:55 AM
Is this a new install of EV or is it an old install from EV9 or below to EV10?
If its an older version, is it the old 32bit index or have you converted the index to 64bit indexing?
Really though i think you're going to have to get a dtrace to see whats going on.
Is there anything in the event viewer related to indexing?
And did anything happen in the environment when this started happening?
You should be able to find the first item that is awaiting indexing in the JournalArchive table, there should be a submitdate or something like that
so like
SELECT TOP 1 SubmitDate FROM JournalArchive WHERE IndexCommited = 0 ORDER BY SubmitDate ASC