BBDM:Error - Cannot insert duplicate key in object 'dbo.#TEMP_SEGMENTATIONSEGMENT'

The following error occurs when trying to calculate the segment counts on a direct marketing effort.

Error message:

Error calculating the segment record counts. Violation of PRIMARY KEY constraint 'PK__#TEMP_SE__3214EC270A1F9DAA'. Cannot insert duplicate key in object 'dbo.#TEMP_SEGMENTATIONSEGMENT'.
The duplicate key value is (513461).

BBERR_ORIGINAL_ERROR:2627
BBERR_ORIGINAL_PROCEDURE:
BBERR_ORIGINAL_LINE_NUMBER:1
We are currently evaluating this issue for a fix in a future service pack.

 

Steps to Duplicate

Steps to duplicate:

1.      In BBDM, go the Marketing and Communications functional area

2.      Search and select Marketing effort causing the error

3.      Calculate segments

4.      Observe error:

Error calculating the segment record counts. Violation of PRIMARY KEY constraint 'PK__#TEMP_SE__3214EC270A1F9DAA'. Cannot insert duplicate key in object 'dbo.#TEMP_SEGMENTATIONSEGMENT'.
The duplicate key value is (513461).

BBERR_ORIGINAL_ERROR:2627
BBERR_ORIGINAL_PROCEDURE:
BBERR_ORIGINAL_LINE_NUMBER:1

Environment

 Blackbaud Direct Marketing
 4.0
 4.0.144.2

Was this article helpful?