Problem Note 42048: History data in the Common Data Model is lost when you upgrade from SAS® Customer Intelligence 5.3 (TS2M0) to the third maintenance release (TS2M3)
 |  |  |  |  |
When you upgrade from SAS Customer Intelligence 5.3 TS2M0, to the third maintenance release (TS2M3), migrated campaigns are published clean the first time they are executed after the upgrade. As a result, the Common Data Model tables are cleared for those migrated campaigns, and the history data is lost.
As a workaround after the upgrade, you can open each campaign and create a new version of it prior to the first execution. Doing this sets the publish state back to unpublished. The preceding history then remains untouched, tied to the previous version. The workaround does have a down side, however. The new version of the campaign will publish new values for the surrogate keys (_SK), so reports that rely on this information must be updated. Any reports based on name (_NM) and folder (_FOLDER) should be okay.
Click the Hot Fix tab in this note to access the hot fix for this issue.
If you currently have SAS Customer Intelligence 5.1, you can migrate directly to SAS Customer Intelligence 5.3 TS2M3 because this problem is fixed in the TS2M3 release.
If you currently have SAS Customer Intelligence 5.3 TS2M0, you should apply the hot fix immediately (when it is available) after upgrading to 5.3 TS2M3 so that you will not run into 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 64-Bit Itanium-based Systems | 5.3 | 5.3_M3 | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Microsoft Windows XP 64-bit Edition | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| 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 NT Workstation | 5.3 | |||||
| Microsoft Windows Server 2003 Datacenter Edition | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 Standard Edition | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 for x64 | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2008 | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2008 for x64 | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Microsoft Windows XP Professional | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Windows 7 Enterprise 32 bit | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Windows 7 Enterprise x64 | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Windows 7 Home Premium 32 bit | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Windows 7 Home Premium x64 | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Windows 7 Professional 32 bit | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Windows 7 Professional x64 | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Windows 7 Ultimate 32 bit | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Windows 7 Ultimate x64 | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Windows Millennium Edition (Me) | 5.3 | |||||
| Windows Vista | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Windows Vista for x64 | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| 64-bit Enabled AIX | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| 64-bit Enabled HP-UX | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| 64-bit Enabled Solaris | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| HP-UX IPF | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
| Linux | 5.3 | 5.3_M3 | 9.2 TS2M3 | |||
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#42048A fix for this issue for SAS Marketing Optimization 5.3_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C19.html#42048| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2011-05-18 11:27:33 |
| Date Created: | 2011-01-07 11:25:40 |