|
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). 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' how can we solve the problem? Thanks |
Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
Tags:
Asked: 17.06.2014 at 12:41
Seen: 1,978 times
Last updated: 23.06.2014 at 10:02
Simply make sure the TO-conversion is to an empty database. If you try to convert your database onto an existing database with the same scheme you result in such an error.
As it is a movement on to another server, the ivy system db is not empty at all. it just need to be converted. the first run on the test environment was successful. on the 2nd environment occurs the error mentioned before.