-
Title
SQL attachability check fails with error "The wait operation timed out" -
Description
SQL attachability check fails due to the timeout period elapsed prior to completion of the operation or the server is not responding while the following error is logged.
ERROR 2016-07-18T05:17:24 [3750] - Replay.Core.Implementation.Sql.AgentAttachabilityJob ()
Job 'Performing the attachability check on Maul' failed
...Microsoft.SqlServer.Management.Common.ExecutionFailureException depth 3: An exception occurred while executing a Transact-SQL statement or batch. (0x80131501) ---> System.Data.SqlClient.SqlException depth 4: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (0x80131904) ---> System.ComponentModel.Win32Exception depth 5: The wait operation timed out -
Cause
Heavy load on the Core or protected machine during nightly jobs results in attachability checks failing.
-
Resolution
Windows Registry Disclaimer:
Quest does not provide support for problems that arise from improper modification of the registry. The Windows registry contains information critical to your computer and applications. Make sure you back up the registry before modifying it. For more information on the Windows Registry Editor and how to back up and restore it, refer to Microsoft Article ID 256986 “Description of the Microsoft Windows registry” at Microsoft Support.
Extend the attachability check's execution and connection timeout values as described below:
On the Core server:- Open the registry and export a copy of the registry before editing.
- Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\AppRecovery\Core\SqlService\CoreSqlSettings\AttachabilitySettings\ 'ExecutionTimeout' and 'ConnectionTimeout' change the time to 02:00:00.
- HKEY_LOCAL_MACHINE\SOFTWARE\AppRecovery\Core\CoreSettings\ClientTimeoutSettings\ 'ConnectionTimeout' and 'ReadWriteTimeout' change to 01:30:00.
- Restart the Core service.
- Monitor the attachability checks.
If the issue is not resolved, please open a support case at https://support.quest.com.