Problem Note 66829: SAS® Marketing Automation campaigns that use treatments and the Teradata Common Data Model return an index violation error
 |  |  |  |  |
In SAS Marketing Automation, the following index violation is returned when you have campaigns that use treatments and that have the Common Data Model in a Teradata database. The error that is shown here is just part of the error that is displayed in the SAS® Customer Intelligence core log.
ERROR: Teradata insert: Secondary index uniqueness violation in cdm.CI_TREATMENT_CHAR_UDF
The problem does not happen all the time. Specifically, it happens when a treatment is used in two or more communications of the same campaign and the campaign tries to insert both instances of the treatment at the same time.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Marketing Automation | Microsoft® Windows® for x64 | 6.6 | |||
| 64-bit Enabled AIX | 6.6 | |||||
| 64-bit Enabled Solaris | 6.6 | |||||
| Linux for x64 | 6.6 | |||||
A fix for this issue for SAS Marketing Automation 6.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H8P.html#66829| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-12-23 13:59:02 |
| Date Created: | 2020-10-22 08:07:50 |