Error: Did not finish. Error activating the marketing effort: An error occurred before executing the process ''Marketing Effort Segment Record Count Calculation- when activating a marketing effort"

When activating marketing acknowledegments, users may receive the following message:

Did not finish.  Error activating the marketing effort: An error occurred before executing the process ''Marketing Effort Segment Record Count Calculation" :
Error calculating the segment record counts:
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for object name "dbo.MKTSEGMENTATIONDATA_EB9FDA0F_565B_474E_B6C7_33B2F61BBB64" and the the index name "UIX_MKTSEGMENTATIONDATA_EB9FDA0F_565B_474E_B6C7_33B2F61BBB64_FINDERNUMBER".
The duplicate key value is (11160243147).  
BBERR_ORIGINAL_ERROR: 1505 BBERR_ORIGINAL_PROCEDURE: BBERR_ORIGINAL_LINE_NUMBER:1

Download and install the latest version and patch, if applicable. 

Environment

 2.9.1001, patch 69
 2.94.1524 ; 2.9.1001, patch 78

Was this article helpful?