Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

Index Rebuild subtask failing with Error 41352

Created: 04 Jan 2013 • Updated: 04 Jan 2013 | 2 comments
This issue has been solved. See solution.

Hi,

 

We trying to rebuild a EV10.0.1 index volume, but failing with following error every time half way through, any idea please?

Log Name:      Symantec Enterprise Vault

Source:        Enterprise Vault 
Date:          04/01/2013 11:59:44
Event ID:      41352
Task Category: Index Volumes Processor
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ev1.domain.local
Description:
The processing of the Rebuild Sub task has stopped following errors.
 
Rebuild Sub task ID: 1539623A51679184CA122FEC557BD83301110000ev1_154
Reason: Auditing
Error Type: NonCritical
 
Description: Auditor Thread for 11B32970E489449CDBB0DC9FE7D5EBA4E1013b00ev1_1042C98998A056F4FB8BF1CBCA624800D1013a00ev1_1539623A51679184CA122FEC557BD83301110000ev1_154 Failed to audit 
 
For more information, see Help and Support Center at http://evevent.symantec.com/rosetta/showevent.asp?EvtID=41352
 
 
 
Index rebuild subtask report
 
Description:Auditor Thread for 11B32970E489449CDBB0DC9FE7D5EBA4E1013b00ev1_1042C98998A056F4FB8BF1CBCA624800D1013a00ev1_1539623A51679184CA122FEC557BD83301110000ev1_154 Failed to audit. Error Accessing to SQL server EV1 for database EVVSFSA1:
Index #0
Message: Cannot insert duplicate key row in object 'dbo.ItemAdditionStatusLog' with unique index 'IX_IASL_APId_ISN_H'.
LineNumber: 89
Source: .Net SqlClient Data Provider
Procedure: uspu_AuditIndexingItemAdditions
Index #1
Message: The statement has been terminated.
LineNumber: 89
Source: .Net SqlClient Data Provider
Procedure: uspu_AuditIndexingItemAdditions
 
. Cannot insert duplicate key row in object 'dbo.ItemAdditionStatusLog' with unique index 'IX_IASL_APId_ISN_H'.
The statement has been terminated.
 
For more information, see the online index troubleshooting technical note at:
 
http://www.symantec.com/docs/TECH160420
 
 

Also if we try to run Verify that fails too. Below report

 

04/01/2013 12:45:41 The verify subtask has failed: There was an error verifying the index entries against the vault store database.The conversion of the nvarchar value '643070643070643070643070643070643070' overflowed an int column.

The statement has been terminated.

 
 
 

Comments 2 CommentsJump to latest comment

JesusWept3's picture

Best suggestion would be to call support on this one, I mean the error is straight forward but the fix doesn't appear to be apparant

SOLUTION