cancel
Showing results for 
Search instead for 
Did you mean: 

Getting Event id 285/296 when running searches in CA

nirender
Level 3

Since upgrading to 10.0.4 we have started to see issues when running searches in Compliance Accelerator.  The searches never complete, but there are no errors as such in the CA console. We are seeing these errors in the eventlogs on the CA server.

 

Event 285
APP AT - Customer ID: 2 - An Error has occured while bulk inserting search items. System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   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.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at KVS.Accelerator.Common.TraceDLCommand.ExecuteScalar(IDbCommand command, Boolean RetryDLs)
   at KVS.Accelerator.Common.TraceDLCommand.ExecuteScalar(IDbCommand command)

Event 296
APP AT - Customer ID: 2 - Error processing bulk search items: Unrecoverable error bulk inserting search items. System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at KVS.Accelerator.Search.SearchItems.InsertBulkSearchItem(SearchResults results)
   at KVS.Accelerator.Search.SearchQueues.SearchResultsProcessWork(ThreadSafeQueue& theQueue, Object queuedItem)

 

We run SQL maintenance once a week when we stop all the services.

 

Any help would be appreciated.

 

Teddy

1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

there was a similar issue solved here:

https://www-secure.symantec.com/connect/forums/compliance-accelerator-90-configuration#comment-9866001

Outside of engaging SYMC I imagine that is worth a look...

View solution in original post

1 REPLY 1

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

there was a similar issue solved here:

https://www-secure.symantec.com/connect/forums/compliance-accelerator-90-configuration#comment-9866001

Outside of engaging SYMC I imagine that is worth a look...