Camp_result_proc is not updated in the sending mail process.
SummaryBussiness created a view in the Formerly Chordiant Marketing Directory. When they are executing the campaign to send out emails, the camp_result_proc is not updated with number of emails sent. As a result, they are not able do a re-run of the campaign; otherwise, their customer will be receiving duplicate email.
The User does not have no issues with the other views. They seek the support's advise where they can look so that they are able to track the campaign, and just do a re-run of the campaign.
Error MessagesCAMP_RESULT_PROC table does not get updated even though email campaign is successful.
Steps to ReproduceRe-running the campaign.
Root CauseThe type_1 and type_2 columns of customer table were populated with alpha-numeric values.
ResolutionUpdate type_1and type_2 columns of customer table to contain only numeric values.
Published May 15, 2017 - Updated July 13, 2017