This article describes an issue where importing content from one DXC environment to another you get the following type of errors below and the import fails.
The following errors have occurred:
[Importing content 21006_26699] Exception: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tblWorkContentProperty_tblPropertyDefinition". The conflict occurred in database "epicms", table "dbo.tblPropertyDefinition", column 'pkID'.
Import has been canceled
The following errors have occurred:
Exception: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tblContentTypeToContentType_tblContentType1". The conflict occurred in database "epicms", table "dbo.tblContentType", column 'pkID'. The statement has been terminated.
The most common causes are:
- The Customer / Partner has made changes to page or block types. These changes are made in code, then gets stored in the database
- The Customer / Partner has updated the Code to a newer version the CMS (Or Commerce)
To resolve this issue please create a ticket with Managed Services to perform a restart of the app service. Once that is complete a subsequent import will resolve without this issue. To avoid this from happening again, deploy code using the "Use maintenance page" option.
Please sign in to leave a comment.