Error: 'packages migration has failed' when upgrading Orchestrator

Issue Description: When upgrading Orchestrator from v2020.4.3 to v.20.10.8 we are getting an error saying that "packages migration has failed".

The following error is recorded in the logs: 'System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.__PackagesMigration'.

Most likely, there is an issue with the specific user with which the upgrade is being run. To overcome this issue, create a new login, with user and password, in SQL. The following files have to be edited with the new login:

  • Web.config in C:\Program Files (x86)\UiPath\Orchestrator
  • appSettings.production.json in C:\Program Files (x86)\UiPath\Orchestrator\Identity
  • appSettings.production.json in C:\Program Files (x86)\UiPath\Orchestrator\Webhooks

Running the upgrade with that SQL User was successful after dropping xxxxx.__PackagesMigration together with dbo.__PackagesMigration.

Once the upgrade is completed and Orchestrator is up an running, it is possible to modify the files above with the required user login.