53051 - Optimization might fail after successful calibration

Problem Note 53051: Optimization might fail after successful calibration

Optimization might fail after a successful calibration in SAS^® Promotion Optimization and SAS^® Regular Price Optimization.

The SAS Promotion Optimization client displays the following error message for the optimization failure:

ERROR: No valid product-locations remain after removing those that are inactive, have no reference price, forecast, output spec, or do not belong to model group.

The SAS Regular Price Optimization client displays the following error message for the optimization failure:

ERROR: A fatal error was encountered while processing the STP request. Please contact your system administrator and check the log files.

A warning message similar to the following is generated in the MerchIntelGridSvr.log file before the optimization failure for both SAS Promotion Optimization and SAS Regular Price Optimization:

WARNING: There is no calibration status record for model group XXX, ODF will skip this model group with YYY pgs.

The optimization failures are generated despite successful calibration because the MODEL_GROUP_EST_STATUS table does not contain calibration status for the model groups that include the products in the failing plans. The MODEL_GROUP_EST_STATUS table is not properly maintained in the following conditions:

All configurations: The solution incorrectly deletes all rows in the table at the beginning of the %TKMI_JOB_RO run when you use the SCHEDULING_NUM_GROUP parameter to specify model groups to be calibrated.
Multiple captains with multiple partitions configuration: Even if you do not use the SCHEDULING_NUM_GROUP parameter when calling %TKMI_JOB_RO, the solution incorrectly removes all rows in the table at the beginning of processing for each partition.

The workaround for this issue is to run with a grid server that functions as a single captain and not use the scheduling_num_group parameter when calling %TKMI_JOB_RO.

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
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS Regular Price Optimization	Linux for x64	5.2_M4	5.4	9.3 TS1M2	9.4 TS1M4
SAS System	SAS Regular Price Optimization	Microsoft® Windows® for x64	5.2_M4	5.4	9.3 TS1M2	9.4 TS1M4
SAS System	SAS Promotion Optimization	Linux for x64	5.2_M4	5.4	9.3 TS1M2	9.4 TS1M4
SAS System	SAS Promotion Optimization	Microsoft® Windows® for x64	5.2_M4	5.4	9.3 TS1M2	9.4 TS1M4

* 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:	alert

Date Modified:	2014-05-30 09:35:58
Date Created:	2014-05-23 14:57:38

Support

Problem Note 53051: Optimization might fail after successful calibration

Operating System and Release Information