When you add user-defined formats that set time or datetime to a SAS Customer Intelligence Studio campaign, incorrect values are stored for the underlying SAS® Customer Intelligence Common Data Model. This problem occurs when you perform steps similar to the following:
After this last step, you can see that the values in the common data model do not match what is specified in the SAS Customer Intelligence Studio interface.
Note: A similar problem exists for the SAS Customer Intelligence Studio interface. For details, see SAS Note 60718, "The time or datetime values in a user-defined format incorrectly change when they are used in a SAS Customer Intelligence Studio campaign."
Click the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Customer Intelligence Studio | Microsoft® Windows® for x64 | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 |
Microsoft Windows 8 Enterprise 32-bit | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Microsoft Windows 8 Enterprise x64 | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Microsoft Windows 8 Pro 32-bit | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Microsoft Windows 8 Pro x64 | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Microsoft Windows 8.1 Enterprise 32-bit | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Microsoft Windows 8.1 Enterprise x64 | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Microsoft Windows 8.1 Pro 32-bit | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Microsoft Windows 8.1 Pro x64 | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Microsoft Windows 10 | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Microsoft Windows Server 2008 | 6.3 | 9.4 TS1M2 | ||||
Microsoft Windows Server 2008 R2 | 6.3 | 9.4 TS1M2 | ||||
Microsoft Windows Server 2008 for x64 | 6.3 | 9.4 TS1M2 | ||||
Microsoft Windows Server 2012 Datacenter | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Microsoft Windows Server 2012 R2 Datacenter | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Microsoft Windows Server 2012 R2 Std | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Microsoft Windows Server 2012 Std | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Windows 7 Enterprise 32 bit | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Windows 7 Enterprise x64 | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Windows 7 Home Premium 32 bit | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Windows 7 Home Premium x64 | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Windows 7 Professional 32 bit | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Windows 7 Professional x64 | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Windows 7 Ultimate 32 bit | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Windows 7 Ultimate x64 | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
64-bit Enabled AIX | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
64-bit Enabled Solaris | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
HP-UX IPF | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Linux for x64 | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
Solaris for x64 | 6.3 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 |
A fix for this issue for SAS Marketing Automation 6.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H8P.html#61010A fix for this issue for SAS Marketing Optimization 6.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H8Q.html#61010A fix for this issue for SAS Management Console 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8N.html#61010A fix for this issue for SAS Middle Tier 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8T.html#61010A fix for this issue for SAS Grid Manager Plug-ins for SAS Management Console 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E5T.html#61010A fix for this issue for SAS Job Flow Scheduler Orchestrator 9.46 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E3I.html#61010A fix for this issue for SAS Job Flow Scheduler Trigger 9.46 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G6W.html#61010A fix for this issue for SAS Marketing Automation 6.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z77.html#61010A fix for this issue for SAS Middle Tier 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V10.html#61010A fix for this issue for SAS Management Console 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V11.html#61010A fix for this issue for SAS Marketing Automation 6.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/U53.html#61010A fix for this issue for SAS Management Console 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R76.html#61010A fix for this issue for SAS Middle Tier 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R75.html#61010A fix for this issue for SAS Marketing Automation 6.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R60.html#61010A fix for this issue for SAS Management Console 9.4_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M93.html#61010A fix for this issue for SAS Middle Tier 9.4_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M92.html#61010Type: | Problem Note |
Priority: | high |
Date Modified: | 2017-12-13 16:40:43 |
Date Created: | 2017-09-01 11:03:16 |