Error: calculating the segment record counts: Violation of PRIMARY KEY constraint - when running segment count for Marketing Effort

When running the segment count process for a marketing effort, the following error is surfaced:

Error calculating the segment record counts: Violation of PRIMARY KEY constraint 'PK__#TEMP_SE__3214EC273D860CC9'. Cannot insert duplicate key in object 'dbo.#TEMP_SEGMENTATIONSEGMENT'. The duplicate key value is (500282). BBERR_ORIGINAL_ERROR:2627 BBERR_ORIGINAL_PROCEDURE: BBERR_ORIGINAL_LINE_NUMBER:1
We're currently evaluating this issue for a fix in a future patch or service pack.

Steps to Duplicate

  1. In BBDM, go the Marketing and Communications functional area
  2. Create a Marketing effort
  3. Calculate segments
  4. Observe error

Environment

 Blackbaud CRM
 3.0

Was this article helpful?