Problem Note 49946: SAS® Digital Marketing replies that are held in a Teradata database fail to update the Common Data Model Response and Contact History tables
 |  |  |  |  |
Some or all of the Reply Categories in SAS Digital Marketing might be configured to update the Customer Intelligence Response or Contact History Common Data Model tables. This update fails when the SAS Digital Marketing Replies table is held in a Teradata database.
In addition, when you query the reply data from SAS® Digital Marketing Studio and the Replies table is held in a Teradata database, results are not returned. You might experience the following error:
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.10.00.31]
[Error 3707] [SQLState 42000] Syntax error, expected something like
'(' between the 'Type' keyword and ','.
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 Digital Marketing | Microsoft® Windows® for x64 | 5.4 | 6.3 | 9.4 TS1M1 | |
| 64-bit Enabled AIX | 5.4 | 6.3 | 9.4 TS1M1 | |||
| 64-bit Enabled HP-UX | 5.4 | 6.3 | 9.4 TS1M1 | |||
| 64-bit Enabled Solaris | 5.4 | 6.3 | 9.4 TS1M1 | |||
| HP-UX IPF | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Linux for x64 | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Solaris for x64 | 5.4 | 6.3 | 9.4 TS1M1 | |||
A fix for this issue for SAS Digital Marketing 5.4_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/E12.html#49946A fix for this issue for SAS Digital Marketing 5.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F60.html#49946A fix for this issue for SAS Digital Marketing 6.1_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K90.html#49946| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-06-03 12:39:35 |
| Date Created: | 2013-05-15 09:01:51 |