We recently upgraded from Kentico 10 to 11. After upgrade we are facing problem with continuous integration object restoration in live environments.
1. After upgrading the code we upgraded the database and ran the continuous integration to update the xml's
2. After that to test the object restoration we ran the continuous integration -r against a database backup and it restores well in local and there was no errors
3. We have Jenkins pipeline which deploys the file changes and also runs the continuous integration -r in the live environments
4. During the Object restoration to live environment the process is trying to delete the fields which were added newly in kentico 11 though the xml's are already updated with new fields.
Example: the below field which process is trying to delete was added in ekntico 11 and updated in xmls
ALTER TABLE COM_PaymentOption DROP COLUMN [PaymentOptionAuthorizedOrderStatusID]
The object 'FK_COM_PaymentOption_PaymentOptionAuthorizedOrderStatusID_COM_OrderStatus' is dependent on column 'PaymentOptionAuthorizedOrderStatusID'.
ALTER TABLE DROP COLUMN PaymentOptionAuthorizedOrderStatusID failed because one or more objects access this column.
Did you apply the upgrade to your production environment first?
Please, sign in to be able to submit a new answer.