Migration Failed: Init Database - The Statistics 'Purpose' Is Dependent On Column 'Purpose' While Upgrade From 2019.10 To 2020.10

How to handle when an error - Migration failed: Init Database - The statistics 'Purpose' is dependent on column 'Purpose' while upgrade from 2019.10 to 2020.10, is encountered?

  1. Go to the database expand the tables in the Orchestrator database
  2. Expand dbo.PackageDefinitions and dbo.PackageMetadata under the Statistics folder and delete the purpose table in the both the tables
  3. Once deleted Start the upgrade to 2020.10


Note : Ensure to take the backup of the database before deleting the table.