Problem Note 50710: The RPP_PLAN.EVAL_OPT_REQ_CD value is not updated from 1 to 0 after batch optimization plans are submitted for optimization again
Following a batch optimization that is run in SAS® Promotion Optimization, the RPP_PLAN.EVAL_OPT_REQ_CD field is not correctly updated from 1 (Evaluate or optimize one time at night) to 0 (Do not evaluate or optimize). As a result of the 1, plans are submitted for optimization again in the next batch run.
To work around this issue, after each batch run execute the following SQL statements against the transactional database:
update rpp_plan
set eval_opt_req_cd = 0
where eval_opt_req_cd = 1
and eval_opt_process_cd in (100, 900);
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M2 | 5.2_M3 | 9.3 TS1M2 | 9.3 TS1M2 |
Linux for x64 | 5.2_M2 | 5.2_M3 | 9.3 TS1M2 | 9.3 TS1M2 |
*
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: | high |
Date Modified: | 2013-08-09 15:11:44 |
Date Created: | 2013-08-09 14:47:43 |