Return
-
Title
ERROR Unable to upgrade Retention Engine, Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. -
Description
After upgrading Archive Manager to version 5.x you get the following retention error in the RPS.wlog2015-11-06 15:30:14,155 [7] ERROR IncrementalUpgrader - {{d6962136-37c5-410b-9f8e-d20ee0571e6a}} Unable to upgrade Retention Engine; retryingSystem.Data.SqlClient.SqlException (0x80131904): 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) -
Cause
SQL Timeout -
Resolution
Set the following to increase the SQL command timeouts.
For Archive Manager 5.x and above open the Configuration Console and click Advanced Settings. Add the following two settings and values:CommandTimeout | 86400RetentionTimeoutSec | 86400Add the "CommandTimeout" key and value to the registry on the Archive Manager server:1. Open Registry Editor on Archive Manager Server.2. Go to HKEY_LOCAL_MACHINE\Software\Aftermail on a 32 bit OS or HKEY_LOCAL_MACHINE\Software\WOW6432NODE\Aftermail on a 64bit OS3. Add string value "CommandTimeout" with value 86400.4. Close registry editor.5. Restart Archive Manager Message Retention Policy Service and the Archive Manager Full Text Search service.