Problem Note 37551: The di_maintain_job macro only purges data the first time it is invoked
 |  |  |  |  |
In the SAS® Revenue Optimization Suite (SAS® Markdown Optimization, SAS® Regular Price Optimization, and SAS® Promotion Optimization) and SAS® Size Profiling, purging only occurs the first time the di_maintain_job macro is run. Purging does not occur for any subsequent invocation of the macro.
There are no warning or error messages.
To work around this issue, you can follow these steps:
- Before the purge, back up the purge_result table.
- Remove all records in the purge_result table.
- Run the purge job.
- Insert the backed up records into the purge_result table.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Markdown Optimization | Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| SAS System | SAS Promotion Optimization | Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| SAS System | SAS Size Profiling | Microsoft Windows Server 2003 Datacenter Edition | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
A fix for this issue for SAS Merchandise Intelligence 3.2 is available at:
http://www.sas.com/techsup/download/hotfix/ro32.html#037551A fix for this issue for SAS Merchandise Intelligence M5 3.2 is available at:
http://www.sas.com/techsup/download/hotfix/ro32m5.html#037551| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-11-12 13:36:46 |
| Date Created: | 2009-10-22 17:21:31 |