Problem Note 48660: %TKMI_JOB_RO benefits_track_highlvl_agg task generates error ""
 |  |  |  |  |
The SAS® Regular Price Optimization %TKMI_JOB_RO benefits_track_highlvl_agg task might generate the following error in the <ddmmyyyy_hh_mm_ss>_benefits_track_highlvl_agg.log log file:
ERROR: Duplicate values not allowed on index prim_key for file
GEO_PROD_BENEFITS_0.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of
statements.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
This error occurs when there is one or more alternate geography hierarchies present.
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 Regular Price Optimization | Microsoft® Windows® for x64 | 5.2 | 5.2_M2 | 9.3 TS1M1 | 9.3 TS1M2 |
| Linux for x64 | 5.2 | 5.2_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
A fix for this issue for SAS Revenue Optimization 5.2_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J17.html#48660| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-02-01 11:48:14 |
| Date Created: | 2012-12-12 11:39:21 |