We are currently evaluating this issue for a fix in a future service pack.
Another alternative solution is to copy the ME itself then try to activate that
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
