Problem Note 51789: The %DI_MAINTAIN_JOB PURGE_DT parameter might be incorrectly interpreted as '1960-01-01 hh:mm:ss' and fail to purge the intended plans
In SAS® Pack Optimization, the %DI_MAINTAIN_JOB PURGE_DT parameter might be incorrectly interpreted as '1960-01-01 hh:mm:ss' and fail to purge the intended plans. For example, if you specify "'01DEC2013'd" as the value for PURGE_DT, it is incorrectly interpreted as "1960-01-01 hh:mm:ss" by %DI_MAINTAIN_JOB. Messages similar to the following are generated in the purge_po_plans.log after specifying PURGE_DT='01DEC2013'd:
CREATE DATE: TIMESTAMP '1960-01-01 05:12:58'
PLAN SELECTION: CREATED_DT <= TIMESTAMP '1960-01-01 05:12:58' and END_DT <= TIMESTAMP '1960-01-01 05:12:58'
There are no plans to delete
NOTE: szpk_purge_po_plans finished successfully for inputs: CREATED_DT <= TIMESTAMP '1960-01-01 05:12:58' and END_DT <= TIMESTAMP
'1960-01-01 05:12:58' .
Contact Technical Support for a workaround for this issue.
Operating System and Release Information
| SAS System | SAS Pack Optimization | Linux for x64 | 3.2_M3 | 3.2_M4 | 9.3 TS1M2 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 3.2_M3 | 3.2_M4 | 9.3 TS1M2 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 3.2_M3 | 3.2_M4 | 9.3 TS1M2 | 9.3 TS1M0 |
*
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: | 2019-11-05 12:48:18 |
| Date Created: | 2013-12-10 12:49:57 |
