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).
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
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).