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?
- Go to the database expand the tables in the Orchestrator database
- Expand dbo.PackageDefinitions and dbo.PackageMetadata under the Statistics folder and delete the purpose table in the both the tables
- Once deleted Start the upgrade to 2020.10
Note : Ensure to take the backup of the database before deleting the table.