Problem Note 55130: Category plan aggregation fails with "TKTException Code = 6 ( Access violation)..."
 |  |  |  |  |
In SAS® Promotion Optimization, category plan aggregation might fail with an error similar to the following in the MerchIntelGridSvr.log file:
2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: ERROR: TKTException code = 6 (Access violation) 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #4 0x00002b576b6caf4c in tkmi_exception_handler (thread=0x828d, ctxt=0x2b57766f3e9c, code=TKTE_UnknownException) at /sas/dev/mva-f4ro52/di/src/tkmi_exception.c:88 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #5 0x00002b5762297196 in bktExcept () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #6 0x00002b576229a19b in bkt_segv () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #7 0x00002b5762297764 in bkt_signal_handler () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #8 <signal handler called> 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #9 0x00002b576b8495e1 in odf_category_demand_discount (odf_arg=0x2b59efc680e8, mg_est=0x0, pgs=0x8, pgs_bak=0x2b5700000008, daily=-856621185) at /sas/dev/mva-f4ro52/di/src/odf_category_demand.c:253 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #10 0x00002b576b744421 in odf_service_run_model_group (odf_arg=0x2b59efc680e8, pgs=0x0, like_for_new_item=0x8, like_item_inactive=0x2b5700000008, like_for_short_item=0x1d070080ccf0ff7f, like_store_inactive=0x0, process_like=0, fill_default=0, status_filter=1) at /sas/dev/mva-f4ro52/di/src/odf_ 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: 20150122:15.56.01.76: run_model_group.c:384 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #11 0x00002b576b7321e4 in odf_service_process (odf_arg=0x2b59efc680e8, gp_to_process=0x0, like_for_new_item=0x8, like_item_inactive=0x2b5700000008, like_for_short_item=0x1d070080ccf0ff7f, like_store_inactive=0x0, process_like=0, fill_default=0) at /sas/dev/mva-f4ro52/di/src/odf_service.c:1237 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #12 0x00002b576b731030 in odf_service_run_unit (context=0x2b59efc680e8) at /sas/dev/mva-f4ro52/di/src/odf_service.c:906 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #13 0x00002b576b7308fb in odf_service_run (this=0x2b59efc680e8, odf_arg=0x0) at /sas/dev/mva-f4ro52/di/src/odf_service.c:187 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #14 0x00002b576b97253c in rpp_agg_call_odf_service (context=0x2b59efc680e8) at /sas/dev/mva-f4ro52/dippr/src/rpp_agg_service.c:1226 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #15 0x00002b576b971827 in rpp_agg_service_cat_run (this=0x2b59efc680e8, plan=0x0) at /sas/dev/mva-f4ro52/dippr/src/rpp_agg_service.c:724 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #16 0x00002b576b970ff4 in rpp_agg_service_main (this=0x2b59efc680e8) at /sas/dev/mva-f4ro52/dippr/src/rpp_agg_service.c:1629 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #17 0x00002b576b97e595 in rpp_prep_service_cat_agg2 (context=0x2b59ef 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: 20150122:15.56.01.76: c680e8) at /sas/dev/mva-f4ro52/dippr/src/rpp_prep_service.c:2179 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #18 0x00002b576b6b6cc8 in logic_fn (ctxt=0x2b57709b76f0, req=0x2b594ff65190, thread=0x2b57760b4d70, cb=0x2b576b303c88) at /sas/dev/mva-f4ro52/di/src/job_manager.c:1281 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #19 0x00002b576a8fed0b in basicPuddleMain () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkepdl.so 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #20 0x00002b57622959a6 in sktMain () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #21 0x00002b5762296ffb in bktMain () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #22 0x0000003b75a079d1 in start_thread () from /lib64/libpthread.so.0 2015-01-22 15:57:03,645 [RequestThread-447980] DEBUG - STDOUT: #23 0x0000003b752e886d in clone () from /lib64/libc.so.6
The failure occurs because there is no category demand after estimation for one of the product-locations in the category plan. Category demand might be missing for a product-location when all of the following are true:
- The FCST_DISAGG model specification is turned on for the model group that contains the product-location with missing category demand.
- The location is defined as a noncomparable store.
- The first product of the noncomparable store category is inactive in the like store.
- The entire category for this first product in the like store is inactive.
The following workarounds are available for this issue:
- Change the value of the NON_COMP_STORE_PERIOD model specification to a smaller value so that the location in question is not classified as a comparable store.
- Define the like store to be a store whose first product is active in the like store in the PROD_GEO_RELATION table.
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_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#55130| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2015-04-14 09:48:53 |
| Date Created: | 2015-02-03 15:55:46 |