Problem Note 41348: Backend estimation (di_job_est) sets GEO_PROD.GEO_PROD_STATUS to > 100 (inactive statuses) for geo/prods not covered by jobs the model group scope
 |  |  |  |  |
When you attempt to add geo/prods to plans in the SAS® Revenue Optimization Suite (SAS® Markdown Optimization, SAS® Regular Price Optimization, and SAS® Promotion Optimization), you might notice that some geo/prods are unavailable for inclusion that you expected would be available. This issue can occur if the backend di_job_est job has been run with model group scope that does not cover all geo/prods in the GEO_PROD table (e.g. running only a subset of your model groups each week). The di_job_est job will update the GEO_PROD.GEO_PROD_STATUS field for non-covered geo_prods to an inactive status (a value > 100,) thereby making them unavailable for selection into plans.
There is no workaround for this issue.
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 Promotion Optimization | Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| SAS System | SAS Markdown Optimization | Microsoft Windows Server 2003 for x64 | 4.2 | 4.2 | 9.2 TS2M2 | 9.2 TS2M3 |
| 64-bit Enabled AIX | 4.2 | 4.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 4.2 | 4.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M1 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M1 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M1 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 4.2 | 4.2_M1 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 | ||