Vinit Gavankar
Aug 20, 2026
visibility 755
star star star star star
(0 votes)

Error FK_tblContentSoftlink_tblPropertyDefinition in CMS

Example Error :

 Microsoft.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_tblContentSoftlink_tblPropertyDefinition". The conflict occurred in database "XYZ-epicms", table "dbo.tblContentSoftlink", column 'fkOwnerPropertyDefinitionID'.

 

Description:

This is happening because you’re attempting to remove a property definition, and during model sync on initialization, it tries to delete that row from tblPropertyDefinition. However, there are still rows in tblContentSoftlink that reference this property definition.
 
First, I will ask you to try "Restart one instance at a time" from the "Troubleshoot" tab of the PAAS Portal and check again.
 
If the issue continues, this query will give you all property definitions that have rows in tblContentSoftlink, along with their property definition type:

SELECT *
FROM tblPropertyDefinition pd
INNER JOIN tblPropertyDefinitionType pdtype
ON pdtype.pkid = pd.fkPropertyDefinitionTypeID
WHERE EXISTS (
SELECT 1
FROM tblContentSoftlink cs
WHERE cs.fkOwnerPropertyDefinitionID = pd.pkid
);

Once you know the property definition to remove, you can delete the dependent softlink rows first (replace X with the pkid of the property definition):

DELETE FROM tblContentSoftlink
WHERE fkOwnerPropertyDefinitionID = X;

 
After that, the modelsync should be able to remove the property definition.
 
I’d recommend testing this locally first, using a copy of the preproduction database, to ensure it behaves as expected.

Aug 20, 2026

Comments

error Please login to comment.
Latest blogs
Advanced Reviews 2.2.0

Editable review links without a CMS login and support for headless websites

Bartosz Sekula | Nov 22, 2026 |

No name

Jagmeet Kaur | Nov 19, 2026 |

What the CMS 13 MCP Server Actually Does When You Write Properties

This post covers the setup gotchas, what each

Adnan Zameer | Nov 19, 2026 |

Pick images from Optimizely DAM straight into rich text

Rich text editors in Optimizely CMS (SaaS), and in CMS 13.7.0 on sites that use the Content Manager, have a new image button. It puts images from t...

Stuart Greig | Nov 18, 2026