Problem Note 63333: The SAS® Merchandise Intelligence update_datamart.sas script might generate "ERROR: The macro DI_UTIL_RENAME_PK will stop executing"
 |  |  |  |  |
In SAS® Merchandise Intelligence, the update_datamart.sas script might generate the following error messages:
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was:
ERROR: The macro DI_UTIL_RENAME_PK will stop executing.
ERROR: The macro DI_UTIL_RENAME_PK will stop executing.
This issue occurs when the %DI_UTIL_RENAME_PK macro tries to rename the Primary key and the Primary Key index as <table_nm>_pk. In certain cases, when the Primary key indexes are different from those that generally get created along with the Primary keys, the %DI_UTIL_RENAME_PK macro might not execute properly.
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 | Linux for x64 | 5.4 | 9.4 TS1M4 | ||
| Microsoft® Windows® for x64 | 5.4 | 9.4 TS1M4 | ||||
| SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.4 | 9.4 TS1M3 | ||
| Linux for x64 | 3.4 | 9.4 TS1M3 | ||||
| SAS System | SAS Pack Optimization | Microsoft® Windows® for x64 | 3.4 | 9.4 TS1M3 | ||
| Linux for x64 | 3.4 | 9.4 TS1M3 | ||||
| SAS System | SAS Regular Price Optimization | Linux for x64 | 5.4 | 9.4 TS1M4 | ||
| Microsoft® Windows® for x64 | 5.4 | 9.4 TS1M4 | ||||
| SAS System | SAS Promotion Optimization | Linux for x64 | 5.4 | 9.4 TS1M4 | ||
| Microsoft® Windows® for x64 | 5.4 | 9.4 TS1M4 | ||||
A fix for this issue for SAS Size Optimization 3.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D3R.html#63333A fix for this issue for SAS Revenue Optimization 5.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B3R.html#63333| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2019-06-12 09:42:28 |
| Date Created: | 2018-12-05 09:37:22 |