U4-6144 - Deleting an assigned composition causes SQL Exception

Created by Peter Gregory 15 Jan 2015, 21:56:21 Updated by Claus Jensen 14 Apr 2016, 10:10:08

I have a composition that is assigned to a number of document types. But I no longer need the composition and want to delete it. However when I go to delete the composition I see the following error.

The DELETE statement conflicted with the REFERENCE constraint "FK_cmsPropertyData_cmsPropertyType_id". The conflict occurred in database "****", table "dbo.cmsPropertyData", column 'propertytypeid'. The statement has been terminated.

Only way to delete is to first un-assign the composition from all doctypes.

I would either expect Umbraco to tell me it cant be deleted as "Composition is currently assigned to the following doctypes:" And give me the option to cancel or un-assign from doctypes and delete anyway.


Shannon Deminick 25 Nov 2015, 15:32:24

This seems to work currently in 7.4, we need to re-test this before release to make sure it works properly.

Priority: Major

Type: Bug

State: Fixed


Difficulty: Normal


Backwards Compatible: True

Fix Submitted:

Affected versions: 7.3.0, 7.2.1, 7.3.1

Due in version: 7.4.0


Story Points: