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

A fix for this issue for SAS Revenue Optimization 5.2_M1 is available at: