Error: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT_CONSTITUENTID" - when running the assign security group process.

Error:  The INSERT statement conflicted with the FOREIGN KEY constraint "FK_CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT_CONSTITUENTID". The conflict occurred in database "{ID}", table "dbo.CONSTITUENT", column 'ID'. The statement has been terminated.

Users may generate the above error when running an assign constituent security process.
We're currently evaluating this issue for a fix in a future patch or service pack.

Steps to Duplicate

1.  Select Security from the Administration functional area
2.  Select Constituent Security
3.  Click assign security groups
4.  Select the group in question
5.  Note the Recent Status tab and the History tab for the times this error has occured

Environment

 Blackbaud CRM
 3.0

Was this article helpful?