Forum Discussion

Ariphaneus's avatar
Ariphaneus
Level 4
12 years ago

Errors - Truncation and usp_upd_SearchVault_Warning

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>

 

 

Discovery Accelerator
Information Governance
Troubleshooting
Windows Server (2003-2008)
  • EV_Ajay's avatar
    EV_Ajay
    12 years ago

    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's avatar
    EV_Ajay
    12 years ago

    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's avatar
    EV_Ajay
    Level 6
    12 years ago

    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's avatar
    EV_Ajay
    Level 6
    12 years ago

    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's avatar
    EV_Ajay
    Level 6
    12 years ago

    Hi,

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

    If you have any question , please let me know.

     

  • Kenneth_Adams's avatar
    Kenneth_Adams
    Level 6
    12 years ago

    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's avatar
    EV_Ajay
    Level 6
    12 years ago

    Hi,

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

     

  • Ariphaneus's avatar
    Ariphaneus
    Level 4
    12 years ago

    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.