Return
-
Title
Deadlock error when trying to purge a large amount of data with a retention policy. -
Description
The Retention Policy Service Log (RPS.log) is failing with a Deadlock error when try to purge a large amount data from Archive Manager.
Full Error Details:
19:49:44.192 Retention Engine ERROR Configuration.SQL [3067624754-3696774628-4-0x0] Execute NonQuery:An error occurred running a SQL statement. Dumping the SqlCommand.The Exception message was: [Transaction (Process ID 371) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.] and it occurred at:System.Data.SqlClient.SqlException: Transaction (Process ID 371) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.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 AfterMail.CommonClasses.SqlHelper.ExecuteNonQuery(SqlCommand sqlCommand, SqlTransaction sqlTransaction, Boolean arithAbortOn)Command information:Command: [dbo.MessageSetDelete]Connection String: [server=SQLSrvName;Trusted_Connection=yes;database=ArchiveManager; Max Pool Size=1000]
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.