Problem Note 47819: Temporary tables are not deleted after successful updates of the SAS® Customer Intelligence Common Data Model Response History table
 |  |  |  |  |
SAS® Digital Marketing is often integrated with SAS® Marketing Automation. You can track responses to SAS Digital Marketing emails that are created from a SAS Marketing Automation campaign. The system can be configured to update the SAS Customer Intelligence Common Data Model Response History table with these tracked responses.
Successful updates to the Response History table leave behind the temporary CI_INTABLES, which should be deleted as part of the process. This behavior might generate problems with disk space.
To work around this issue, in SAS® Management Console select Customer Intelligence ► Environment Settings and change the Presented Treatments Counts from NONE to No Duplicates.
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 64-Bit Itanium-based Systems | 5.3 | |||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 5.3 | |||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 5.3 | |||||
| Microsoft Windows XP 64-bit Edition | 5.3 | |||||
| Microsoft® Windows® for x64 | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Microsoft Windows 8 | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Microsoft Windows 95/98 | 5.3 | |||||
| Microsoft Windows 2000 Advanced Server | 5.3 | |||||
| Microsoft Windows 2000 Datacenter Server | 5.3 | |||||
| Microsoft Windows 2000 Server | 5.3 | |||||
| Microsoft Windows 2000 Professional | 5.3 | |||||
| Microsoft Windows 2012 | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Microsoft Windows NT Workstation | 5.3 | |||||
| Microsoft Windows Server 2003 Datacenter Edition | 5.3 | |||||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3 | |||||
| Microsoft Windows Server 2003 Standard Edition | 5.3 | |||||
| Microsoft Windows Server 2003 for x64 | 5.3 | |||||
| Microsoft Windows Server 2008 | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Microsoft Windows Server 2008 for x64 | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Microsoft Windows XP Professional | 5.3 | |||||
| Windows 7 Enterprise 32 bit | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Enterprise x64 | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Home Premium 32 bit | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Home Premium x64 | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Professional 32 bit | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Professional x64 | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Ultimate 32 bit | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Ultimate x64 | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Windows Millennium Edition (Me) | 5.3 | |||||
| Windows Vista | 5.3 | |||||
| Windows Vista for x64 | 5.3 | |||||
| 64-bit Enabled AIX | 5.3 | 6.3 | 9.4 TS1M1 | |||
| 64-bit Enabled HP-UX | 5.3 | 6.3 | 9.4 TS1M1 | |||
| 64-bit Enabled Solaris | 5.3 | 6.3 | 9.4 TS1M1 | |||
| HP-UX IPF | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Linux | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Linux for x64 | 5.3 | 6.3 | 9.4 TS1M1 | |||
| Solaris for x64 | 5.3 | 6.3 | 9.4 TS1M1 | |||
A fix for this issue for SAS Marketing Automation 5.3_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C18.html#47819A fix for this issue for SAS Marketing Automation 5.4_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/E08.html#47819A fix for this issue for SAS Marketing Automation 5.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E88.html#47819| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-11-06 09:00:55 |
| Date Created: | 2012-09-06 05:11:01 |