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

asked 17.06.2014 at 12:41

Nathalie's gravatar image

Nathalie
(suspended)
accept rate: 0%

edited 23.06.2014 at 10:02

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
9.4k31958

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.

(17.06.2014 at 14:51) Daniel Oechslin Daniel%20Oechslin's gravatar image

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.

(18.06.2014 at 10:45) Nathalie Nathalie's gravatar image

Did you try to convert the system database and it failed and now you are retrying to convert it?

Note that after a failure in converting the database we suggest to restore the database first from a backup before retrying to convert it. 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.

link

answered 20.06.2014 at 08:46

Reto%20Weiss's gravatar image

Reto Weiss ♦♦
4.9k202857
accept rate: 74%

edited 23.06.2014 at 08:44

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
9.4k31958

Yes we did a restore and tried again. It fails again. The reason: the conversion was done with anohter database user and when we (the customer side as we have no rights to the database-server) dropped the database and did the restore, the new created tables were still there. So the conversion fails again. Now it worked. Thank you.

(23.06.2014 at 08:34) Nathalie Nathalie's gravatar image

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×14

Asked: 17.06.2014 at 12:41

Seen: 2,042 times

Last updated: 23.06.2014 at 10:02