Blog posts by Vinit Gavankar2026-08-20T11:58:26.0000000Zhttps://world.optimizely.com/blogs/vinit-gavankar/Optimizely WorldError FK_tblContentSoftlink_tblPropertyDefinition in CMS<p><strong>Example Error :</strong></p>
<div> 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'.</div>
<p> </p>
<p><strong>Description</strong>:</p>
<p>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 <strong>tblPropertyDefinition</strong>. However, there are still rows in <strong>tblContentSoftlink</strong> that reference this property definition.<br /> <br />First, I will ask you to try "Restart one instance at a time" from the "Troubleshoot" tab of the<strong> PAAS Portal</strong> and check again.<br /> <br />If the issue continues, this query will give you all property definitions that have rows in <strong>tblContentSoftlink</strong>, along with their property definition type:</p>
<pre><code>SELECT *<br />FROM tblPropertyDefinition pd<br />INNER JOIN tblPropertyDefinitionType pdtype<br /> ON pdtype.pkid = pd.fkPropertyDefinitionTypeID<br />WHERE EXISTS (<br /> SELECT 1<br /> FROM tblContentSoftlink cs<br /> WHERE cs.fkOwnerPropertyDefinitionID = pd.pkid<br />);</code></pre>
<p>Once you know the property definition to remove, you can delete the dependent softlink rows first (replace <code>X</code> with the <code>pkid</code> of the property definition):</p>
<pre><code>DELETE FROM tblContentSoftlink<br />WHERE fkOwnerPropertyDefinitionID = X;</code></pre>
<p> <br />After that, the modelsync should be able to remove the property definition.<br /> <br />I’d recommend testing this <strong>locally first, using a copy of the preproduction database,</strong> to ensure it behaves as expected.</p>2026-08-20T11:58:26.0000000ZBlog postGet count of pages, blocks , Assets from the CMS.<p>The following queries retrieve details from the CMS database. Make sure to try these queries locally first. </p>
<p> </p>
<p><strong>Step 1 — Discover your content type bases first:<br /></strong></p>
<pre><code>```<br />SELECT Base, COUNT(*) AS TypeCount<br />FROM tblContentType<br />GROUP BY Base<br />ORDER BY TypeCount DESC;<br />```</code></pre>
<p><strong>Step 2 — Count all content grouped by base type (single query):<br /></strong></p>
<pre><code>```<br />SELECT <br /> ct.Base AS ContentBase,<br /> ct.Name AS ContentTypeName,<br /> COUNT(c.pkID) AS ContentCount<br />FROM tblContent c<br />INNER JOIN tblContentType ct ON c.fkContentTypeID = ct.pkID<br />GROUP BY ct.Base, ct.Name<br />ORDER BY ct.Base, ContentCount DESC;<br />```</code></pre>
<p><strong>Step 3 — Individual counts per category:<br /></strong></p>
<pre><code>```<br />-- Pages<br />SELECT COUNT(*) AS PageCount<br />FROM tblContent c<br />INNER JOIN tblContentType ct ON c.fkContentTypeID = ct.pkID<br />WHERE ct.Base = 'Page';<br /><br />-- Blocks<br />SELECT COUNT(*) AS BlockCount<br />FROM tblContent c<br />INNER JOIN tblContentType ct ON c.fkContentTypeID = ct.pkID<br />WHERE ct.Base = 'Block';<br /><br />-- Images (adjust base value based on Step 1 results)<br />SELECT COUNT(*) AS ImageCount<br />FROM tblContent c<br />INNER JOIN tblContentType ct ON c.fkContentTypeID = ct.pkID<br />WHERE ct.Base = 'Image';<br /><br />-- Documents / Files<br />SELECT COUNT(*) AS DocumentCount<br />FROM tblContent c<br />INNER JOIN tblContentType ct ON c.fkContentTypeID = ct.pkID<br />WHERE ct.Base IN ('File', 'Video', 'Media');<br />```</code></pre>2026-08-20T11:52:59.0000000ZBlog post