We are currently evaluating this issue for a fix in a future service pack.
Blackbaud Community
Connect and collaborate with fellow Blackbaud users.
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
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
Article Number: 107930
Products:
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
