Problem Note 47995: The plan reclassification job fails with a "Variable worksheet_from_merch_level was not found ... No appending done ..." message
 |  |  |  |
When running the SAS® Merchandise Data Integration plan reclassification job, the compute plan adopters module (compute_plan_adopters.sas) fails, and reports the following error while processing merchandise dimension sets:
WARNING: Variable worksheet_from_merch_level was not found on BASE file. The variable will not be added to the BASE file.
ERROR: No appending done because of anomalies listed above. Use FORCE option to append these files.
To address this issue, replace the compute_plan_adopters.sas with a new version of the file. In the new version, the worksheet_from_merch_level variable, referenced in error in the adopter_0_vars_long macro, is commented out.
To implement the solution, follow these steps:
- Contact SAS Technical Support to get the new version of the compute_plan_adopters.sas file.
- Make a backup of your existing $MDI_ROOT/code/sasmacro/compute_plan_adopters.sas file.
- Copy the new version of the compute_plan_adopters.sas file to $MDI_ROOT/code/sasmacro.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Merchandise Financial Planning | Microsoft Windows Server 2003 Enterprise 64-bit Edition | 6.1.3 M5 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 6.1.3 M5 | 6.6 | 9.1 TS1M3 SP4 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 6.1.3 M5 | 6.6 | 9.1 TS1M3 SP4 | 9.4 TS1M0 | ||
| SAS System | SAS Merchandise Assortment Planning | Microsoft Windows Server 2003 Enterprise 64-bit Edition | 6.1.3 M5 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 6.1.3 M5 | 6.6 | 9.1 TS1M3 SP4 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 6.1.3 M5 | 6.6 | 9.1 TS1M3 SP4 | 9.4 TS1M0 | ||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-06-27 16:33:52 |
| Date Created: | 2012-09-25 09:55:29 |