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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | ||
A fix for this issue for SAS Revenue Optimization 5.2_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K36.html#50710A fix for this issue for SAS Size Optimization 3.2_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K37.html#50710| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-08-09 15:11:44 |
| Date Created: | 2013-08-09 14:47:43 |