The vRealize Automation migration task does not finish and the migration log indicates that a wait operation has timed out.
The migration task must finish in a specified amount of time or it fails with a timeout error. A sample timeout error message is as follows.
Command Update-VmUsers failed. Error: 'System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out.
The migration task did not finish in the allocated amount of time. This might occur in an environment where there are a large number of users to be migrated.
As a first course of corrective action, verify that your target SQL server is properly resourced according to the reference architecture.
You can increase the timeout value to address the problem. The default timeout value is 10 minutes, specified as 600 seconds in the
migration.exe.config file. Use the following procedure to set a different timeout value. After you have specified the value, restart the migration tool and rerun the migration task.
Locate and open the migration.exe.config file.
<add key="userMigrationCommandTimeout" value="600" />line in the
<appSettings>section of the file.
Set a new timeout value, for example 30 minutes specified as
<add key="userMigrationCommandTimeout" value="1800" />.
Save and close the Migration.exe.config file.
Start the vCACMigration.exe migration tool.
Follow the prompts and click Migration on the Migration Tasks page to rerun the migration task.