Orchestrator upgrade to 2020.4 fails during database migration

News Knowledge Base
1

The Upgradation to 2020.4 does not work , How to handle the following error that is found in the log - System.Exception: Error:-1, Message:An error occurred while migrating orchestrator data. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.The statement has been terminated. at UiPath.OrchestratorCAs.IdentityDatabaseManager.RunIdentityMigrationTool(String arguments) at UiPath.OrchestratorCAs.IdentityDatabaseManager.MigrateUsersFromOrchestratorDb(String webConfigPath, String identityPublicUrl) at UiPath.OrchestratorCAs.IdentityDatabaseManager.ApplyDbConfigMigrationsOnInstalling(String webConfigPath, String identityAppSettingsJsonPath) at UiPath.OrchestratorCAs.CustomActions.Deferred.UpdateConfigurationAndDatabasesAction.ApplyIdentityDbConfigMigrations() at UiPath.OrchestratorCAs.CustomActions.Deferred.UpdateConfigurationAndDatabasesAction.Execute() at UiPath.OrchestratorCAs.CustomActions.Base.BaseCustomAction.InternalExecute()

The exception occurs during upgradation to 2020.4, as below -
System.Exception: Error:-1, Message:An error occurred while migrating orchestrator data. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.The statement has been terminated. at UiPath.OrchestratorCAs.IdentityDatabaseManager.RunIdentityMigrationTool(String arguments) at UiPath.OrchestratorCAs.IdentityDatabaseManager.MigrateUsersFromOrchestratorDb(String webConfigPath, String identityPublicUrl) at UiPath.OrchestratorCAs.IdentityDatabaseManager.ApplyDbConfigMigrationsOnInstalling(String webConfigPath, String identityAppSettingsJsonPath) at UiPath.OrchestratorCAs.CustomActions.Deferred.UpdateConfigurationAndDatabasesAction.ApplyIdentityDbConfigMigrations() at UiPath.OrchestratorCAs.CustomActions.Deferred.UpdateConfigurationAndDatabasesAction.Execute() at UiPath.OrchestratorCAs.CustomActions.Base.BaseCustomAction.InternalExecute()

This can be handled as following: 

  1. Verify the hardware requirements are satisfied by following the general requirements here.
  2. Now reduce the data in the logs table to make it run faster, by referring the maintenance considerations suggested here.