Exclusion solicit codes are duplicated on a communication template after it is copied

A user may notice, after copying a communication template, that the required exclusion solicit codes are duplicated on the copied template.  If you attempt to copy the template again you will receive Error:  Error:   Record operation could not be performed.  Cannot insert duplicate key row in object 'dbo.MKTCOMMUNICATIONTEMPLATEDEFAULTSOLICITCODES' with unique index 'UIX_MKTCOMMUNICATIONTEMPLATEDEFAULTSOLICITCODES_COMMUNICATIONTEMPLATEID_SOLICITCODEID'. The duplicate key value is (be9d0237-cc92-4066-a18f-64ae70c4407f, 6381b85c-625c-4739-b068-09d68fb95c62). BBERR_ORIGINAL_ERROR:2601 BBERR_ORIGINAL_PROCEDURE:USP_MKTCOMMUNICATIONTEMPLATEDEFAULTSOLICITCODES_GETEXCLUDESOLICITCODES_ADDF BBERR_ORIGINAL_LINE_NUMBER:43.  If a user tries to create a marketing effort with the template, they may receive Error:  Data could not be saved. Cannot insert duplicate key row in object 'dbo.BUSINESSPROCESSCOMMPREFEXCLUSIONS' with unique index 'UIX_BUSINESSPROCESSCOMMPREFEXCLUSIONS_BUSINESSPROCESSPARAMETERSETID_SOLICITCODEID'. The duplicate key value is (76bae0fd-73c5-412c-98ae-bddccfef9be4, 6381b85c-625c-4739-b068-09d68fb95c62).
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.

Environment

 Blackbaud CRM
 4.0
 4.0
 Service Pack 4
 4.0.138, patch 2

Was this article helpful?