PSIcapture Error: GetLimitBatchRetentionToSpecificTimes

Problem:

You encounter the following issue when attempting to process batches with batch retention.

Exception occurred in GetLimitBatchRetentionToSpecificTimes: Connection Timeout Expired.  The timeout period elapsed during the post-login phase.  The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=794; handshake=2144; [Login] initialization=0; authentication=0; [Post-Login] complete=12854;
   at PSIGEN.Capture.Modules.BatchManager.BatchManagerService.GetLimitBatchRetentionToSpecificTimes()
   at PSIGEN.Capture.Modules.BatchManager.BatchManagerService.RunBatchRetention(Object stateInfo)
   at System.Threading.TimerQueueTimer.CallCallbackInContext(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.TimerQueueTimer.CallCallback()
   at System.Threading.TimerQueueTimer.Fire()
   at System.Threading.TimerQueue.FireNextTimers()
   at System.Threading.TimerQueue.AppDomainTimerCallback()
=== INNER EXCEPTION ===
Connection Timeout Expired.  The timeout period elapsed during the post-login phase.  The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=794; handshake=2144; [Login] initialization=0; authentication=0; [Post-Login] complete=12854;
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)

Solution:

This means that Batch Retention is failing at some level within the configuration. Adjust batch retention settings related to specific timings until this issue ceases.