Problem Note 51648: Optimization in SAS® Regular Price Optimization might fail with "ERROR: TKTException code = 2 (Floating point divide by zero)"
In SAS Regular Price Optimization, optimization might fail with errors similar to the following in the MerchIntelGridSvr.log:
[pool--thread-] DEBUG - STDOUT: ERROR: TKTException code = 2 (Floating point divide by zero)
[pool--thread-] DEBUG - STDOUT: #4 0x00007f568380767c in tkmi_exception_handler (thread=0x4ea4, ctxt=0x7f5688e34b0c, code=TKTE_UnknownException) at /sas/wky/mva-m3ro52/di/src/tkmi_exception.c:88
[pool--thread-] DEBUG - STDOUT: #5 0x00007f56933ba196 in bktExcept () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so
[pool--thread-] DEBUG - STDOUT: #6 0x00007f56933bd8a5 in bkt_fpe () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so
[pool--thread-] DEBUG - STDOUT: #7 0x00007f56933ba764 in bkt_signal_handler () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so
[pool--thread-] DEBUG - STDOUT: #8
[pool--thread-] DEBUG - STDOUT: #9 0x00007f5683a8a1fa in load_rpp_plan_prod_asgmnt_hash (this=0x0, assignments=-2087730464) at /sas/wky/mva-m3ro52/dippr/src/rpp_data_loader.c:303
[pool--thread-] DEBUG - STDOUT: #10 0x00007f5683a8c838 in rpp_data_loader_scope (rpp_mgr=0x0, start_dt=-2087730464, end_dt=1, prod_hier_assoc_cd=0, geo_hier_assoc_cd=0, plan_sk_list=0x7f564b73e0f0 "") at /sas/wky/mva-m3ro52/dippr/src/rpp_data_loader.c:253
[pool--thread-] DEBUG - STDOUT: #11 0x00007f5683924f02 in price_service_new (dim=0x0, opt=...) at /sas/wky/mva-m3ro52/di/src/price_service.c:
[pool--thread-] DEBUG - STDOUT: 20131117:11.47.33.72: 413
[pool--thread-] DEBUG - STDOUT: #12 0x00007f5683874efd in odf_service_get_price_service (odf_arg=0x7f56280a1810, effective_price=1, promo_support=1, out_period_type=0, new_price_service_created=0x7f5688e3be30) at /sas/wky/mva-m3ro52/di/src/odf_scoring_data.c:262
[pool--thread-] DEBUG - STDOUT: #13 0x00007f5683886d7f in odf_load_price_service (odf_arg=0x0, mg_list=0x7f56838fc2e0) at /sas/wky/mva-m3ro52/di/src/odf_util.c:1673
[pool--thread-] DEBUG - STDOUT: #14 0x00007f568386b8d8 in odf_service_run (this=0x0, odf_arg=0x7f56838fc2e0) at /sas/wky/mva-m3ro52/di/src/odf_service.c:182
[pool--thread-] DEBUG - STDOUT: #15 0x00007f5683a41932 in rpo_service_call_odf (rpo_plan=0x0) at /sas/wky/mva-m3ro52/dipca/src/rpo_service.c:1961
[pool--thread-] DEBUG - STDOUT: #16 0x00007f5683a3c264 in rpo_service_process_plan (plan_sk=101456, request_type=RPO_OPT) at /sas/wky/mva-m3ro52/dipca/src/rpo_service.c:1700
[pool--thread-] DEBUG - STDOUT: #17 0x00007f5683a3b81b in rpo_service_optimize (plan_sk=0) at /sas/wky/mva-m3ro52/dipca/src/rpo_service.c:1812
[pool--thread-] DEBUG - STDOUT: #18 0x00007f56837e6106 in run_cmd_internal (cmd=0x0) at /sas/wky/mva-m3ro52/di/src/tkmi.c:1235
[pool--thread-] DEBUG - STDOUT: #19 0x00007f56837e454b in run_cmd (cmd=0x7f5688e47db0) at /sas/wky/mv
2013-11-17 11:47:48,489 [RequestThread-149814] DEBUG - STDOUT: 20131117:11.47.33.72: a-m3ro52/di/src/tkmi.c:989
[pool--thread-] DEBUG - STDOUT: #20 0x00007f56837e2f98 in tkmi_run (tkmi_inst=0x0, cmd_string=0x7f56838fc2e0 "AWAVAUATUSH\201\354(\001", callback_fn=0x1) at /sas/wky/mva-m3ro52/di/src/tkmi.c:770
[pool--thread-] DEBUG - STDOUT: #21 0x00007f568844f748 in miExecuteBridge (exports=0x7f56838fc2e0, pool=0x1, parms=0x0, returnValue=0x0, jnl=0x7f564b73e0f0) at /sas/wky/mva-m3ro52/di/src/tkmibridge.c:102
[pool--thread-] DEBUG - STDOUT: #22 0x0000000000408536 in executeFunction ()
[pool--thread-] DEBUG - STDOUT: #23 0x000000000040721c in clientHandler ()
[pool--thread-] DEBUG - STDOUT: #24 0x00007f56933b89a6 in sktMain () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so
[pool--thread-] DEBUG - STDOUT: #25 0x00007f56933b9ffb in bktMain () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so
[pool--thread-] DEBUG - STDOUT: #26 0x00000039a3407851 in start_thread () from /lib64/libpthread.so.0
[pool--thread-] DEBUG - STDOUT: #27 0x00000039a30e894d in clone () from /lib64/libc.so.6
When you optimize a regular price plan, promotions are loaded in order to calculate the sales forecasts for the products in the plan. Future promotions might also be loaded when Apply Future Promotions is selected in the regular price plan optimization settings. This error is generated when a promotion with all of the following conditions are loaded during optimization of a regular price plan:
- The promotion overlaps in time scope with the regular price plan.
- The promotion is Approved or Tentatively Approved.
- The promotion contains an absolute forecast override.
- The promotion contains product-locations that are outside the scope of the regular price plan.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M3 | 5.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 |
| Linux for x64 | 5.2_M3 | 5.2_M4 | 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: | alert |
| Date Modified: | 2013-12-06 13:54:47 |
| Date Created: | 2013-11-19 10:29:46 |
