Problem Note 58217: The START_DTTM and END_DTTM columns in the CI_CAMPAIGN table are incorrect in SAS® Marketing Automation
The START_DTTM and END_DTTM columns in the CI_CAMPAIGN table in the database might be incorrect after you publish a scheduled campaign in SAS® Marketing Automation.
The values in the START_DTTM and END_DTTM columns might appear as 100 years earlier than the actual dates. For example, if you schedule a campaign with a start date of 2040 and with an end date of 2041, then the year might appear as 1940 and 1941 in the database, respectively.
This problem might occur when you schedule a campaign at least ten years from the current date. However, the dates in the application's campaign schedule are still correct.
Operating System and Release Information
SAS System | SAS Marketing Automation | Microsoft® Windows® for x64 | 5.41 | 6.5 | 9.3 TS1M0 | 9.4 TS1M3 |
64-bit Enabled AIX | 5.41 | 6.5 | 9.3 TS1M0 | 9.4 TS1M3 |
64-bit Enabled HP-UX | 5.41 | 6.5 | 9.3 TS1M0 | 9.4 TS1M3 |
64-bit Enabled Solaris | 5.41 | 6.5 | 9.3 TS1M0 | 9.4 TS1M3 |
HP-UX IPF | 5.41 | 6.5 | 9.3 TS1M0 | 9.4 TS1M3 |
Linux for x64 | 5.41 | 6.5 | 9.3 TS1M0 | 9.4 TS1M3 |
Solaris for x64 | 5.41 | 6.5 | 9.3 TS1M0 | 9.4 TS1M3 |
*
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2020-04-06 07:43:08 |
Date Created: | 2016-05-16 16:11:25 |