https://answers.axonivy.com/questions/795/can-i-retry-a-database-conversion-after-a-failed-run<p>Because we had to move the ivy environment from one server to another, we did a backup of the ivy db and restored it to the new environment (for test and prod). </p> <p>The convertion on the first system was successful. Trying to convert the Ivy System database on the second we got the error: Failure while system database conversion: Error 'Column names in each table must be unique. Column name 'BusinessCalendarId' in table 'IWA_Application' is specified more than once.' while executing statement 'ALTER TABLE IWA_Application ADD BusinessCalenderId INTEGER NULL'</p> <p>how can we solve the problem?</p> <p>Thanks</p>enFri, 20 Jun 2014 08:46:46 -0400https://answers.axonivy.com/questions/795/can-i-retry-a-database-conversion-after-a-failed-run/801<p>Did you try to convert the system database and it failed and now you are retrying to convert it? </p> <p>Note that <strong>after a failure in converting the database we suggest to restore the database first from a backup before retrying to convert it</strong>. Otherwise, some conversions may were executed successful before the failure. In this case the database schema is in a intermediate version that cannot be converted successfully.</p>Reto WeissFri, 20 Jun 2014 08:46:46 -0400https://answers.axonivy.com/questions/795/can-i-retry-a-database-conversion-after-a-failed-run/801