Errors - Truncation and usp_upd_SearchVault_Warning

[Ariphaneus]

We've been receiving a lot of error 42086 and the team that is responsible for the Vault has been looking into it.  However when I ran a test search this morning whereas there was no error in the DA console on the server I recieved a few repetition of the following two errors.  Not sure if I should be concerned or if these too are issues with our Vault.

Log Name:      Symantec Enterprise Vault
Source:        Accelerator Service Processor
Date:          10/15/2013 10:29:34 AM
Event ID:      42086
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      SDCSEVDISAPPW01.AD.CHPNET.ORG
Description:
APP AT - Customer ID: 2 - Error:
Error getting the truncation reason

Description:
String or binary data would be truncated.
ERROR_usp_upd_SearchVault_Warning_UpdateError
The statement has been terminated.
Reason: String or binary data would be truncated.
ERROR_usp_upd_SearchVault_Warning_UpdateError
The statement has been terminated.
Stack:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at KVS.Accelerator.Search.VaultToSearch.ReportStatus(String sp, Int32 nItemInserted, String Info, Int32 StatusID)
   at KVS.Accelerator.Search.VaultToSearch.SearchIndexVolume()
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Accelerator Service Processor " />
    <EventID Qualifiers="0">42086</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-10-15T14:29:34.000000000Z" />
    <EventRecordID>1528483</EventRecordID>
    <Channel>Symantec Enterprise Vault</Channel>
    <Computer>SDCSEVDISAPPW01.AD.CHPNET.ORG</Computer>
    <Security />
  </System>
  <EventData>
    <Data>APP AT - Customer ID: 2 - Error:
Error getting the truncation reason

Description:
String or binary data would be truncated.
ERROR_usp_upd_SearchVault_Warning_UpdateError
The statement has been terminated.
Reason: String or binary data would be truncated.
ERROR_usp_upd_SearchVault_Warning_UpdateError
The statement has been terminated.
Stack:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at KVS.Accelerator.Search.VaultToSearch.ReportStatus(String sp, Int32 nItemInserted, String Info, Int32 StatusID)
   at KVS.Accelerator.Search.VaultToSearch.SearchIndexVolume()</Data>
  </EventData>
</Event>

Log Name:      Symantec Enterprise Vault
Source:        Accelerator Service Processor
Date:          10/15/2013 10:29:34 AM
Event ID:      327
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      SDCSEVDISAPPW01.AD.CHPNET.ORG
Description:
APP AT - Customer ID: 2 - An error occurred executing 'usp_upd_SearchVault_Warning'. System.Data.SqlClient.SqlException: String or binary data would be truncated.
ERROR_usp_upd_SearchVault_Warning_UpdateError
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at KVS.Accelerator.Search.VaultToSearch.ReportStatus(String sp, Int32 nItemInserted, String Info, Int32 StatusID)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Accelerator Service Processor " />
    <EventID Qualifiers="0">327</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-10-15T14:29:34.000000000Z" />
    <EventRecordID>1528482</EventRecordID>
    <Channel>Symantec Enterprise Vault</Channel>
    <Computer>SDCSEVDISAPPW01.AD.CHPNET.ORG</Computer>
    <Security />
  </System>
  <EventData>
    <Data>APP AT - Customer ID: 2 - An error occurred executing 'usp_upd_SearchVault_Warning'. System.Data.SqlClient.SqlException: String or binary data would be truncated.
ERROR_usp_upd_SearchVault_Warning_UpdateError
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at KVS.Accelerator.Search.VaultToSearch.ReportStatus(String sp, Int32 nItemInserted, String Info, Int32 StatusID)</Data>
  </EventData>
</Event>

[EV_Ajay · Accepted solution]

Hi,

 Error :  An error occurred executing 'usp_upd_SearchVault_Warning'. System.Data.SqlClient.SqlException: String or binary data would be truncated.
ERROR_usp_upd_SearchVault_Warning_UpdateError
The statement has been terminated.
 

It means unable to execute Store Procedure when DA search generate the Warning / Error. I think the SP is unable to execute because of the Table fragmentation issue and table index issue. It will be helpful to run SQL maintance against EV & DA Databases.

Article :

-----------------

How to automatically back up and perform recommended maintenance for Enterprise Vault SQL databases.  (DBCC)

http://www.symantec.com/docs/TECH74666

[EV_Ajay · Accepted solution]

Hi,

If you are also getting following Event ID on EV Server then apply the Solution steps :

Event ID : 42086
Level : Warning
Computer : EVServer.xyz.com
Description:

APP AT – CustomerID:2 – Warning:

Some items could not be searched:

Archive:’Journal1’

ID:174441945702828468103EB38AEAmailarchive

Index Volume:215

Search ID:10

For more information, see Help and Support Centre at

http://evevent.symantec.com/rosetta/showevent.asp

Solution : 

1. Log on to the Enterprise Vault Server.
2. Check the “Index Volume” Tab for the archive which Archive ID is present in the Event Log.
3. Check the “Failed Item” Option and check How many items Failed for Index.
4. Open the Index folder for the affected archive and open the “Indexmissing.log” file.
5. Check the Saveset IDs present in the “Indexmissing.log” file.
6. Search for the physical DVS file from the SavesetID which present in the “Indexmissing.log” file.
7. If DVS files are not found in the correct location then restore them from backup.
8. If DVS files are found then repair the index volume for the affected archives. (Right Click on the Index Location and select “Repair” option. The status will change to “Rebuilding”. )
9. Then give some time for synchronization between the EV & DA Server.

Refer :

-----------

Event ID 42086, Some items could not be searched.
http://www.symantec.com/docs/TECH189198

[EV_Ajay]

Also Refer :

When performing a Compliance Accelerator (CA) or Discovery Accelerator (DA) search, the Info column entry "Some items could not be searched" occurs.
http://www.symantec.com/docs/TECH127715

[EV_Ajay]

Hi,

Have you carried out the action plan give me above thread ?

If you have any question , please let me know.

[Kenneth_Adams]

Hello, Ariphaneous;

A few weeks ago you reported another issue with your DA 9.0 environment receiving errors and was thinking those errors were related to SQL maintenance.  While those particular errors were only related to index volumes havig failed items, the error you are receiving now could be related to database maintenance as EVAjay noted.  They could also be related to something in the data your database is trying to process (i.e., the data is in the bigint range but headed for a column set to just the int range).

Please ensure your DA Customer database health is good by ensuring proper maintenance has been run (see http://www.symantec.com/docs/TECH74666 as a reference) with the Enterprise Vault Accelerator Manager Service stopped to ensure no background task has any database table locked while the indexes are to be rebuilt.

If the db maintenance does not resolve the issue, please open a Support case so we can work directly with you to capture the SQL Profiler and dtrace logs we'll need to identify the root cause of your error and get it fixed.

[EV_Ajay]

Hi,

Are you still facing the issue. Please share more details about the issue.

[Ariphaneus]

Have not seen this error again, we do have a nightly maintenance.  Also turns out that, despite what my vault admin has told me, there are indexmissing.log files that we need to take care of.

[EV_Ajay]

Many thanks for your reply and marking as solution.