SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 59193: Incorrect dates are published to the CI_TREATMENT_DATE_UDF table and are displayed in the export preview in SAS® Customer Intelligence Studio

DetailsHotfixAboutRate It

In SAS Customer Intelligence Studio, incorrect dates are published to the CI_TREATMENT_DATE_UDF table, and these incorrect dates are displayed in the export preview. This issue occurs only when the web browser on which SAS Customer Intelligence Studio runs is set to a different time zone than that of the SAS® Customer Intelligence servers.

For example, consider the following treatment, which is created with the custom fields and values that are shown below:

59193_1

A campaign is created using this treatment, and the export writes the treatment fields. However, instead of the values from the treatment being displayed, the following values are displayed in the export preview:

  • September 19, 2016
  • 13:13:55 PM
  • December 30, 2016 15:13:58 PM

As you can see from the previous display, the values for Time type and Date & Time type are incorrect.

In addition, when the campaign is published, the following values are written to the CI_TREATMENT_DATE_UDF table:

  • September 19, 2016
  • September 19, 2016 14:13:55
  • December 30, 2016 15:13:58

Again, the values for Time type and Date & Time type are incorrect.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Customer Intelligence StudioMicrosoft® Windows® for x646.39.4 TS1M2
Microsoft Windows 8 Enterprise 32-bit6.39.4 TS1M2
Microsoft Windows 8 Enterprise x646.39.4 TS1M2
Microsoft Windows 8 Pro 32-bit6.39.4 TS1M2
Microsoft Windows 8 Pro x646.39.4 TS1M2
Microsoft Windows 8.1 Enterprise 32-bit6.39.4 TS1M2
Microsoft Windows 8.1 Enterprise x646.39.4 TS1M2
Microsoft Windows 8.1 Pro 32-bit6.39.4 TS1M2
Microsoft Windows 8.1 Pro x646.39.4 TS1M2
Microsoft Windows 106.39.4 TS1M2
Microsoft Windows Server 20086.39.4 TS1M2
Microsoft Windows Server 2008 R26.39.4 TS1M2
Microsoft Windows Server 2008 for x646.39.4 TS1M2
Microsoft Windows Server 2012 Datacenter6.39.4 TS1M2
Microsoft Windows Server 2012 R2 Datacenter6.39.4 TS1M2
Microsoft Windows Server 2012 R2 Std6.39.4 TS1M2
Microsoft Windows Server 2012 Std6.39.4 TS1M2
Windows 7 Enterprise 32 bit6.39.4 TS1M2
Windows 7 Enterprise x646.39.4 TS1M2
Windows 7 Home Premium 32 bit6.39.4 TS1M2
Windows 7 Home Premium x646.39.4 TS1M2
Windows 7 Professional 32 bit6.39.4 TS1M2
Windows 7 Professional x646.39.4 TS1M2
Windows 7 Ultimate 32 bit6.39.4 TS1M2
Windows 7 Ultimate x646.39.4 TS1M2
64-bit Enabled AIX6.39.4 TS1M2
64-bit Enabled Solaris6.39.4 TS1M2
HP-UX IPF6.39.4 TS1M2
Linux for x646.39.4 TS1M2
Solaris for x646.39.4 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.