Error calculating the segment record counts: Violation of PRIMARY KEY constraint 'PK__UFN_MKTS__C79734904879CB73'. Cannot insert duplicate key in object 'dbo.@GAPS'.

Users receive this error when calculating segment counts in Marketing Efforts: Error calculating the segment record counts: Violation of PRIMARY KEY constraint 'PK__UFN_MKTS__C79734904879CB73'. Cannot insert duplicate key in object 'dbo.@GAPS'. The duplicate key value is (36394182). BBERR_ORIGINAL_ERROR:2627 BBERR_ORIGINAL_PROCEDURE:USP_DATAFORMTEMPLATE_ADD_MKTSEGMENTATIONFINDERNUMBER BBERR_ORIGINAL_LINE_NUMBER:35
This is a data specific problem that requires a script fix to resolve.  Please contact customer support or create a case if you're encountering this issue

Steps to Duplicate

  1. Go to Direct Marketing Efforts
  2.  Find 17_XMAS_CATALOGUE_EDM2_AU
  3. Select Test Efforts and open TEST17_XMAS_CATALOGUE_EDM2_AU
  4. Click on link next to counts generated
  5.  Notice error

Environment

 Blackbaud CRM
 4.0

Was this article helpful?