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.