How to determine why an index volume has failed using the SQL database

Article:HOWTO56250  |  Created: 2011-07-27  |  Updated: 2011-07-31  |  Article URL http://www.symantec.com/docs/HOWTO56250
Article Type
How To



When an index volume is failed, an event is logged in the event viewer stating the reason for the failure:

Log Name:      Symantec Enterprise Vault
Source:        Enterprise Vault
Date:          6/21/2011 3:40:56 PM
Event ID:      41329
Task Category: Index Volumes Processor
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      IndexServer1.server.local
Description:
Index volume is marked as failed.

Archive Name: DomTest1/server
Index Volume ID: 128140EE76EDF61489B88550159726C5F1110000IndexServer1.server.local_7611
Reason: None
Error Type: FrenzyErrorDetected

Description:
Error 1: Error encountered whilst trying to fetch item Sequence Number '28806' Item Identifier '201106208563747~201106200945100000~Z~60DF4C6D4EFBB564BD069207A0453011'
Error 2: Error encountered whilst trying to fetch item Sequence Number '28808' Item Identifier '201106208563747~201106200945100000~Z~60DF4D6F2FF3FC79F9AE8278C7C5B091'
Error 3: Error encountered whilst trying to fetch item Sequence Number '28809' Item Identifier '201106208563747~201106200945100000~Z~60DF4B4E57FCD06566CA28A3DFABB2D1'
Error 4: Error encountered whilst trying to fetch item Sequence Number '28810' Item Identifier '201106208563747~201106200945100000~Z~60DF4C36A042A136C7FD62B0B3C35A71'
Error 5: Error encountered whilst trying to fetch item Sequence Number '28814' Item Identifier '201106208563747~201106200945100000~Z~60DF4AB06DB562D6E8B8AB48B9DDE571'
Error 6: Error encountered whilst trying to fetch item Sequence Number '28818' Item Identifier '201106208563747~201106200945100000~Z~60DF4C171E36A00520D1BC29B82F3D91'
Error 7: Error encountered whilst trying to fetch item Sequence Number '28819' Item Identifier '201106208563747~201106200945100000~Z~60DF4D5CE0BFEC4C01116FF7B2113521'
Error 8: Error encountered whilst trying to fetch item Sequence Number '28823' Item Identifier '201106208563747~201106200945100000~Z~60DF4BDA4836CFB1BC6613AC297A7771'
Error 9: Error encountered whilst trying to fetch item Sequence Number '28825' Item Identifier '201106208563747~201106200945100000~Z~60DF4F7EA91461BBD603D2473B2F3E11'
Error 10: Error encountered whilst trying to fetch item Sequence Number '28826' Item Identifier '201106208563748~201106200945100000~Z~60DF5F652AA32D66EF32C1CAACB9F0C1'
Error 11: Error encountered whilst trying to fetch item Sequence Number '28827' Item Identifier '201106208563748~201106200945100000~Z~60DF5B484DA71D1C47DCCA2A4291EA81'
Error 12: Error encountered whilst trying to fetch item Sequence Number '28831' Item Identifier '201106208563748~201106200945100000~Z~60DF5D90F8832DF5AE37A2EFDE8B3C81'
Error 13: Error encountered whilst trying to fetch item Sequence Number '28833' Item Identifier '201106208563748~201106200945100000~Z~60DF5C5BA91C67945968B601DDE13BF1'
Error 14: Error encountered whilst trying to fetch item Sequence Number '28836' Item Identifier '201106208563748~201106200945100000~Z~60DF5F07F1AFFF5295063AA3915F10A1'
Error 15: Error encountered whilst trying to fetch item Sequence Number '28837' Item Identifier '201106208563748~201106200945100000~Z~60DF5F75C0F909B1FE646E2659E9A981'
Error 16: Error encountered whilst trying to fetch item Sequence Number '28838' Item Identifier '201106208563748~201106200945100000~Z~60DF5DB93974D2BDACBCF5476BE4B9C1'
Error 17: Error encountered whilst trying to fetch item Sequence Number '28841' Item Identifier '201106208563748~201106200945100000~Z~60DF5BDA2FF5D7F6F5B389E5AADB8C51'
Error 18: Error encountered whilst trying to fetch item Sequence Number '28847' Item Identifier '201106208563748~201106200945100000~Z~60DF5F021BD820C96E3BCC2CBADBB511'
Error 19: Error encountered whilst trying to fetch item Sequence Number '28849' Item Identifier '201106208563748~201106200945100000~Z~60DF5BE3BE6B55191A22BFB1D0BFC741'
Error 20: Error encountered whilst trying to fetch item Sequence Number '28852' Item Identifier '201106208563748~201106200945100000~Z~60DF5E6471F1FC706C1FF8B95901CD91'
Error 21: Error encountered whilst trying to fetch item Sequence Number '28855' Item Identifier '201106208563748~201106200945100000~Z~60DF6AFBA368681FE4850F6F85BC53A1'
Error 22: Error encountered whilst trying to fetch item Sequence Number '28857' Item Identifier '201106208563748~201106200945100000~Z~60DF6EAF303C20F35AFC1CDD1D201CE1'
Error 23: Error encountered whilst trying to fetch item Sequence Number '28859' Item Identifier '201106208563749~201106200945100000~Z~60DF6E7969AB6C2B148ADE579CF55481'
Error 24: Error encountered whilst trying to fetch item Sequence Number '28860' Item Identifier '201106208563749~201106200945100000~Z~60DF6CD6346848CEF6CDE95C71E4FBE1'
Error 25: Error encountered whilst trying to fetch item Sequence Number '28861' Item Identifier '201106208563749~201106200945100000~Z~60DF6CD7B68D999672B8A657A592E081'
 

The Directory database IndexVolume table and IndexVolumeView View can be used to determine the exact reason for the failure, using the FailedVolumeReason column:

  1. No Errors
  2. Volume Directory is missing
  3. Consecutive number of failed items found has been reached
  4. Sequence Number mismatch
  5. Volume has been deleted
  6. 32bit Index Volume dataset file is missing
  7. 32bit Index Volume dataset file is empty
  8. 32bit Index Volume dataset file is invalid
  9. Failed to open
  10. 32bit Index Volume Checksum failure
  11. 32bit Index Volume Make Stable
  12. 32bit Index Volume Make Stable DA
  13. 32bit Index Volume Compaction Error
  14. Indexing Engine Error
  15. Failed to Audit Items
  16. Duplicate SSIDs
  17. State file missing or invalid
  18. Metadata sync error

 

The event viewer error above is an example of FailedVolumeReason of 2 and is caused by too many consecutive items being unable to be fetched from storage. 

 

To find index volumes that have failed, use the query:

use EnterpriseVaultDirectory
Select *
from IndexVolumeView
where Failed = 1


 



Article URL http://www.symantec.com/docs/HOWTO56250


Terms of use for this information are found in Legal Notices