SUPPORT / SAMPLES & SAS NOTES
Problem Note 37578: Duplicate records might exist in tables that are related to pricing rules
 |  |  |  |  |
In SAS® Markdown Optimization, you might find duplicate records in tables that are related to pricing rules. Duplicates can occur when two users with the same product-location scope save the same rule without seeing the other's save first. Currently there is no unique index on these tables to enforce uniqueness.
These pricing rule tables are affected by this issue:
- GEO_PROD_SETTING
- PRICE_GRID
- GEO_PROD_MARGIN_RULE
- GEO_PROD_COMP_RULE
- GEO_PROD_STRATEGY
- MIN_MAX_PRICE_CHG_RULE
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 | 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||