Problem Note 45678: Memory errors during optimization
 |  |  |  |  |
When you run SAS® High-Performance Markdown Optimization batch optimization, you might notice the system becomes unresponsive or deadlocked. This is a caused by a memory error. Because memory errors can have unpredictable results, the same issue might not cause a deadlock but might cause optimization to fail with the any of the following errors in the HiPerfMerchIntelGridSvr.log file.
2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: 10:06:30 MDO_739585_misc_out : Error: job 'MDO_739585_misc_out' encountered a fatal error 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: 10:06:30 MDO_739585_misc_out : 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: ERROR: TKTException code = 6 (Access violation) 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: at /sas/wky/mva-m2tkmi43/di/src/tkmi_exception.c:117 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: #4 0x00002aaaaae32b42 in tkmi_exception_handler (thread=0x6f97, 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: ctxt=0x49edc25c, code=TKTE_UnknownException) 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: at /sas/wky/mva-m2tkmi43/di/src/tkmi_exception.c:81 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: #5 0x00002b7b6539a65b in bktExcept () 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: #6 0x00002b7b6539cda3 in bkt_segv () 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: #7 0x00002b7b6539aa9c in bkt_signal_handler () 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: #82012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: #9 0x00002b7b653a6f13 in bkmPutNormalContainer () 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: #10 0x00002b7b653a1f59 in skm_free_container () 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: #11 0x00002b7b653a112e in skmPoolDestroy () 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: #12 0x00002aaaaae1fea6 in base_memory_pool_delete (this=0x2b7b00000000) 2012-02-14 10:06:30,697 [pool-10-thread-7] DEBUG - STDOUT: at /sas/wky/mva m2tkmi43/di/src/base_memory_pool.c:139
Or
2012-02-08 13:24:43,715 [pool-10-thread-7] DEBUG - STDOUT: ERROR: TKTException code = 6 (Access violation) 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: at /sas/wky/mva-m2tkmi43/di/src/tkmi_exception.c:117 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #4 0x00002aaaaae32b42 in tkmi_exception_handler (thread=0x7d3c, 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: ctxt=0x47b5d25c, code=TKTE_UnknownException) 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: at /sas/wky/mva-m2tkmi43/di/src/tkmi_exception.c:81 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #5 0x00002b8c4e18965b in bktExcept () 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #6 0x00002b8c4e18bda3 in bkt_segv () 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #7 0x00002b8c4e189a9c in bkt_signal_handler () 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #82012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #9 0x00002ab05fdb7b2f in ?? () 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #10 0x0000000070614d20 in ?? () 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #11 0x00002aaaab62880b in tscConAllocHandle () 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tketsc.so 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #12 0x00002aaaab29769c in dcmConAllocHandle () 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkedcm.so 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #13 0x00002aaaaae2d30a in execute_for_partition (this=0x2ab05fdb78c0, 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: partition_id=2108007840, path=0x0) 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: at /sas/wky/mva-m2tkmi43/di/src/input_adapter.c:559 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #14 0x00002aaaaae2d0ef in input_adapter_run (this=0x2ab05fdb78c0) 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: at /sas/wky/mva-m2tkmi43/di/src/input_adapter.c:1207 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #15 0x00002aaaaaf17c24 in mdo_plan_result_loader_run (this=0x2ab05fdb78c0) 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: at /sas/wky/mva-m2tkmi43/di/src/mdo_plan_load_result.c:132 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #16 0x00002aaaaaecee8e in mdo_data_loader_import_data (this=0x2ab05fdb78c0, 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: mdo_srvc=0x2aae7da5a5a0) 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: at /sas/wky/mva-m2tkmi43/di/src/mdo_data_loader.c:1100 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #17 0x00002aaaaaec9c99 in mdo_service_opt (context=0x2ab05da59358) 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: at /sas/wky/mva-m2tkmi43/di/src/mdo_service.c:1066 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #18 0x00002aaaaae24036 in logic_fn (ctxt=0x2b8c4e4cf378, req=0x2ab15db641a8, 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: thread=0x2ab06a159690, cb=0x2aaf1c1dc7f8) 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: at /sas/wky/mva-m2tkmi43/di/src/job_manager.c:1265 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #19 0x00002aaaab9e3e5f in basicPuddleMain () 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkepdl.so 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #20 0x00002b8c4e1881a2 in sktMain () 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #21 0x00002b8c4e1894cb in bktMain () 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: from /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #22 0x000000389380673d in start_thread () from /lib64/libpthread.so.0 2012-02-08 13:24:43,716 [pool-10-thread-7] DEBUG - STDOUT: #23 0x0000003892cd40cd in clone () from /lib64/libc.so.6
Or
2012-02-08 11:30:15,631 [pool-10-thread-7] DEBUG - STDOUT: 11:30:15 MDO_690436 : ERROR: TKMI Base Exception Handler: TKTException code = 6 2012-02-08 11:30:15,631 [pool-10-thread-7] DEBUG - STDOUT: 11:30:15 MDO_690436 : 2012-02-08 11:30:15,631 [pool-10-thread-7] DEBUG - STDOUT: /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmi.so [0x2aaaaaf4c640] 2012-02-08 11:30:15,631 [pool-10-thread-7] DEBUG - STDOUT: /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmi.so(tktracex+0x16) [0x2aaaaaf4c7e4] 2012-02-08 11:30:15,631 [pool-10-thread-7] DEBUG - STDOUT: /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmi.so [0x2aaaaae1e29f] 2012-02-08 11:30:15,631 [pool-10-thread-7] DEBUG - STDOUT: /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so(bktExcept+0x5b) [0x2b999ba5b65b] 2012-02-08 11:30:15,631 [pool-10-thread-7] DEBUG - STDOUT: /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so(bkt_segv+0xb) [0x2b999ba5dda3] 2012-02-08 11:30:15,631 [pool-10-thread-7] DEBUG - STDOUT: /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so(bkt_signal_handler+0xec) [0x2b999ba5ba9c] 2012-02-08 11:30:15,631 [pool-10-thread-7] DEBUG - STDOUT: /lib64/libc.so.6 [0x3892c302d0] 2012-02-08 11:30:15,631 [pool-10-thread-7] DEBUG - STDOUT: /sso/mpv/sfw/sas/920/SASHighPerformanceMerchandiseIntelligenceServer/4.3/HPTKDI/tkext/com/laxno/tkmk.so(bkmPutNormalContainer+0x53) [0x2b999ba67f13] 2012-02-08 11:30:15,631 [pool-10-thread-7] DEBUG - STDOUT: 2012-02-08 11:30:15,631 [pool-10-thread-7] DEBUG - STDOUT:
This error occurs when a plan is using uniform timing (DI_DM2.MDO_PLAN.UNIFORM_TIMING_NUM_MARKDN > 0) and the plan has no remaining weeks when a markdown can be taken (start date of last week of plan < start date of first unfrozen week). Because the beginning of the first unfrozen week is dependant on the system date and DI_DM.GLOBAL_SETTING.PRICE_CHANGE_APPROVAL_LEAD_TIME a plan might not meet this condition during one optimization run, but might meet these criteria during optimization on a different day.
The work-around for this issue is to mark the plan as complete and resume optimization. Use the RESUME=1 option for %TKMI_JOB_RO. A sample call of %TKMI_JOB_RO might look like the following:
%tkmi_job_ro(run_only=%bquote(etl_start_service etl_end_service),resume=1);
The plan should then be edited to either disable uniform timing or extend the plan end date beyond the frozen period before you attempt to optimize it again.
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 High-Performance Markdown Optimization | Linux for x64 | 4.3_M2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
A fix for this issue for SAS High-Performance Markdown Optimization 4.3_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/G22.html#45678| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-03-13 09:10:09 |
| Date Created: | 2012-02-15 10:19:29 |