Problem Note 44132: ERROR: Variable class_cd is not on file ODF_TMP._GP_NEW_PROD_LIKE_G
You might encounter the following error when you run calibration in SAS Promotion Optimization and SAS Regular Price Optimization:
ERROR: Variable class_cd is not on file ODF_TMP._GP_NEW_PROD_LIKE_G.
This error occurs within the di_dm_forecast_extract job because there are new products that have like products that exist in another model group. The workaround is to redefine the like products in the PRODUCT_RELATION table so all like products are within the same model groups as the new products.
Operating System and Release Information
| SAS System | SAS Promotion Optimization | Microsoft Windows Server 2003 for x64 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2008 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2008 for x64 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| 64-bit Enabled AIX | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 for x64 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2008 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2008 for x64 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| 64-bit Enabled AIX | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
*
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: | 2012-05-29 10:59:54 |
| Date Created: | 2011-08-29 08:48:33 |
