Problem Note 63754: Datetime values that are written by Teradata and Oracle data processes are in different time zones
 |  |  |  |  |
In SAS® Real-Time Decision Manager, you might notice that datetime values that are written from data processes to the Teradata database do not correctly account for time zone. This issue occurs under the following circumstances:
- You use data processes that write to both Oracle and Teradata databases.
- You configure the SAS® Decision Services sasds.designserver.default.timezoneid, the sasds.engine.default.timezoneid property, or both for Oracle, according to SAS Note 55831, "SAS Real-Time Decision Manager incorrectly assumes that dates returned from queries to Oracle are in the GMT time zone."
There is no workaround for this issue.
A fix for this issue is planned for a future software release.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Real-Time Decision Manager | 64-bit Enabled Solaris | 6.4 | 9.4 TS1M2 | ||
| 64-bit Enabled AIX | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Ultimate x64 | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Ultimate 32 bit | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Professional x64 | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Professional 32 bit | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Home Premium x64 | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Home Premium 32 bit | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Enterprise x64 | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Enterprise 32 bit | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2012 Std | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2012 R2 Std | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2012 Datacenter | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 for x64 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 R2 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 10 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8.1 Pro x64 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8 Pro x64 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8 Pro 32-bit | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8 Enterprise x64 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8 Enterprise 32-bit | 6.4 | 9.4 TS1M2 | ||||
| Microsoft® Windows® for x64 | 6.4 | 9.4 TS1M2 | ||||
| HP-UX IPF | 6.4 | 9.4 TS1M2 | ||||
| Linux for x64 | 6.4 | 9.4 TS1M2 | ||||
| Solaris for x64 | 6.4 | 9.4 TS1M2 | ||||
| SAS System | SAS Decision Services | Microsoft® Windows® for x64 | 6.4 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Enterprise 32-bit | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8 Enterprise x64 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8 Pro 32-bit | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8 Pro x64 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 8.1 Pro x64 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows 10 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 R2 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 for x64 | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2012 Datacenter | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2012 R2 Std | 6.4 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2012 Std | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Enterprise 32 bit | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Enterprise x64 | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Home Premium 32 bit | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Home Premium x64 | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Professional 32 bit | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Professional x64 | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Ultimate 32 bit | 6.4 | 9.4 TS1M2 | ||||
| Windows 7 Ultimate x64 | 6.4 | 9.4 TS1M2 | ||||
| 64-bit Enabled AIX | 6.4 | 9.4 TS1M2 | ||||
| 64-bit Enabled Solaris | 6.4 | 9.4 TS1M2 | ||||
| HP-UX IPF | 6.4 | 9.4 TS1M2 | ||||
| Linux for x64 | 6.4 | 9.4 TS1M2 | ||||
| Solaris for x64 | 6.4 | 9.4 TS1M2 | ||||
A fix for this issue for SAS Decision Services 6.4_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z24.html#63754A fix for this issue for SAS Decision Services 6.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V46.html#63754| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-10-10 14:18:11 |
| Date Created: | 2019-02-26 16:20:48 |