How to adjust timeout settings? (4277401)

During migration jobs, particularly those involving large amount of data, the user experiences errors that the job terminated due to not being able to read from the source or target SharePoint site. The term "timeout" is often mentioned. Below is an example of a SQL Server Timeout:

Exception thrown: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Details:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun( ...

This is often caused by resources, which can either be the network, the memory usage on the server or the SQL Server itself.

One way to facilitate the migration jobs in an over-taxed resource environment is to increase the allowed timeout settings for accessing the SharePoint data.

1. Close all instances of the Content Matrix Console.
2. Open the C:\ProgramData\Metalogix\EnvironmentSettings.xml file using Notepad.
3. Increase the value of the following applicable settings:
   • SQLQueryTimeoutTime: which controls the amount of time in seconds before SQL queries will time out.
   • WebServiceTimeoutTime: which controls the amount of time in seconds before the Extensions Web Service (MEWS) calls will time out. The default is 300 seconds, it is recommended to increase it to 600 seconds.
   • WebServiceRetriesNumber, which controls the number of times Content Matrix will make a call to the MEWS before returning an exception. It does not technically stop timeouts, but it can help to retry the calls until environmental issues causing the timeouts stop occurring.
   • WebServiceRetriesDelay, which is a helper to the previous setting. It sets the number of seconds that the application will sleep before retrying the web service call if it fails. If the previous setting is set to 0, this setting will not have any effect.
4. Save the file, and then re-launch the Content Matrix Console.