Error: The DELETE statement conflicted with the Reference Constraint "FK_DESIGNATION_DESIGNATIONLEVEL2ID" - when deleting a designation

I am trying to delete a fund in our fundraising hierarchy. There are no gifts recorded in the fund, so I should be able to delete it but receive the following error message: Data could not be saved.  
The DELETE statement conflicted with the REFERENCE constraint "FK_DESIGNATION_DESIGNATIONLEVEL2ID". The conflict occurred in database "XXX", table "dbo.DESIGNATION", column 'DESIGNATIONLEVEL2ID'.

 
We are currently evaluating this issue and will update this article when we have more information. While we are working, we can follow the steps below to mark the designation as inactive:
  1. Click Fundraising > Fundraising Hierarchies
  2. Click the arrow next to a designation 
  3. Click Mark Inactive

Steps to Duplicate

  1. Click Fundraising > Fundraising Hierarchies
  2. Click the arrow next to a designation 
  3. Click Delete > Receive error message

Environment

 Altru Arts & Cultural

Was this article helpful?