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]