Problem Note 64846: Updates to the SAS® Customer Intelligence Common Data Model fail during an upgrade from SAS® Marketing Automation 6.4 to SAS® Marketing Automation 6.5
 |  |  |  |  |
When you upgrade from SAS Marketing Automation 6.4 to SAS Marketing Automation 6.5, any updates to the SAS Customer Intelligence Common Data Model fail. When the failure occurs (and if the database for the common data model is Teradata) , the following errors are generated:
ERROR: Teradata execute: Referential integrity violation: cannot drop a referenced (Parent) table.
ERROR: Teradata execute: Syntax error: The name of a PRIMARY KEY or UNIQUE constraint must be the same as the name used for the unique primary index.
To obtain a workaround, contact SAS Technical Support.
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.5 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 6.5 | 9.4 TS1M3 | ||||
| 64-bit Enabled Solaris | 6.5 | 9.4 TS1M3 | ||||
| HP-UX IPF | 6.5 | 9.4 TS1M3 | ||||
| Linux for x64 | 6.5 | 9.4 TS1M3 | ||||
| Solaris for x64 | 6.5 | 9.4 TS1M3 | ||||
| SAS System | SAS Real-Time Decision Manager | Microsoft® Windows® for x64 | 6.5 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 | 6.5 | 9.4 TS1M3 | ||||
| Microsoft Windows Server 2008 R2 | 6.5 | 9.4 TS1M3 | ||||
| Microsoft Windows Server 2008 for x64 | 6.5 | 9.4 TS1M3 | ||||
| Microsoft Windows Server 2012 Datacenter | 6.5 | 9.4 TS1M3 | ||||
| Microsoft Windows Server 2012 Std | 6.5 | 9.4 TS1M3 | ||||
| 64-bit Enabled AIX | 6.5 | 9.4 TS1M3 | ||||
| 64-bit Enabled Solaris | 6.5 | 9.4 TS1M3 | ||||
| HP-UX IPF | 6.5 | 9.4 TS1M3 | ||||
| Linux for x64 | 6.5 | 9.4 TS1M3 | ||||
| Solaris for x64 | 6.5 | 9.4 TS1M3 | ||||
A fix for this issue for SAS Marketing Automation 6.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z77.html#64846| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2019-10-01 10:08:43 |
| Date Created: | 2019-09-27 15:57:51 |