Problem Note 46996: Calibration generates an "ERROR: File WORK1.PROD_ATTR_TMP_1.DATA does not exist." error
In SAS® Promotion Optimization and SAS® Regular Price Optimization, calibration might generate the following error:
ERROR: File WORK1.PROD_ATTR_TMP_1.DATA does not exist.
The error is generated in the di_dm_forecast_extract job when there are leftover entries in the MODEL_GEO_PROD table. The leftover entries in the MODEL_GEO_PROD table are due to model configuration changes and/or product reclassification. The MODEL_GEO_PROD table is incorrectly updated via the update statement instead of regenerated each time that calibration runs.
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
| SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| SAS System | SAS Promotion Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
*
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: | alert |
| Date Modified: | 2012-08-14 09:55:52 |
| Date Created: | 2012-07-13 13:53:05 |
