10-15-2013 08:04 AM
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>
Solved! Go to Solution.
10-16-2013 02:35 AM
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)
10-16-2013 05:54 AM
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
Refer :
-----------
Event ID 42086, Some items could not be searched.
http://www.symantec.com/docs/TECH189198
10-16-2013 02:35 AM
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)
10-16-2013 05:54 AM
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
Refer :
-----------
Event ID 42086, Some items could not be searched.
http://www.symantec.com/docs/TECH189198
10-16-2013 05:56 AM
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
10-17-2013 03:02 AM
Hi,
Have you carried out the action plan give me above thread ?
If you have any question , please let me know.
10-17-2013 04:54 AM
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.
10-22-2013 06:52 AM
Hi,
Are you still facing the issue. Please share more details about the issue.
10-25-2013 09:08 AM
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.
10-27-2013 11:24 PM
Many thanks for your reply and marking as solution.