V7 to V8 Database Upgrade Error

Josh Taylor asked on August 27, 2014 18:06

I received an error during the database upgrade from Kentico 7 to Kentico 8. The error I received is below:

Msg 547, Level 16, State 0, Line 7 The DELETE statement conflicted with the REFERENCE constraint "FK_CMS_UIElement_ElementResourceID_CMS_Resource". The conflict occurred in database "DiscoverCorona_Kentico_Staging", table "dbo.CMS_UIElement", column 'ElementResourceID'. The statement has been terminated.

I am not sure which record it was trying to delete from CMS_UIElement that caused the error. Any thoughts?

Recent Answers

Sandro Jankovic answered on November 21, 2014 13:29

Hello,

When did you download the upgrade package? There were some problems related to UI elements which caused this error and it should have been already fixed. If you have not downloaded the package in the last few days, please do so and roll back the backups and perform the upgrade again.

It seems that there is an inconsistency in the DB. Could you please check the CMS_UIElement table and search for any records that have the same ElementResourceID - duplicates? If possible, I would recommend to remove the duplicates form the DB and then try to repeat the operation.

Please let me know if you have any additional questions or concerns.

Best Regards,

Sandro

0 votesVote for this answer Mark as a Correct answer