SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 37551: The di_maintain_job macro only purges data the first time it is invoked

DetailsHotfixAboutRate It

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:

  1. Before the purge, back up the purge_result table.
  2. Remove all records in the purge_result table.
  3. Run the purge job.
  4. 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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Markdown OptimizationMicrosoft Windows Server 2003 Standard Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
64-bit Enabled AIX3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
SAS SystemSAS Regular Price OptimizationMicrosoft Windows Server 2003 Datacenter Edition3.24.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Enterprise Edition3.24.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Standard Edition3.24.29.1 TS1M3 SP49.2 TS2M0
64-bit Enabled AIX3.24.29.1 TS1M3 SP49.2 TS2M0
SAS SystemSAS Promotion OptimizationMicrosoft Windows Server 2003 Datacenter Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
64-bit Enabled AIX3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
SAS SystemSAS Size ProfilingMicrosoft Windows Server 2003 Datacenter Edition1.22.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Enterprise Edition1.22.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Standard Edition1.22.29.1 TS1M3 SP49.2 TS2M0
64-bit Enabled AIX1.22.29.1 TS1M3 SP49.2 TS2M0
* 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.