Problem Note 51788: Online aggregation fails
 |  |  |  |  |
SAS® Promotion Optimization online category or calendar aggregation might fail with the following error in the MerchIntelGridSvr.log file:
<YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - <YYYMMDD:HH.MM.SS.MM>: ERROR: Assertion failed: base_file_exists(this->out_path), file /sas/dev/mva-f3ro52/di/src/output_adapter.c, line 132 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - <YYYMMDD:HH.MM.SS.MM>: Error: directory '<di_dm>/aggregation_metrics/_tmp/<partition_id>' must exist before calling output adapter <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - <YYYMMDD:HH.MM.SS.MM>: ERROR: Assertion failed: base_file_exists(this->out_path), file /sas/dev/mva-f3ro52/di/src/output_adapter.c, line 132 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - <YYYMMDD:HH.MM.SS.MM>: Error: directory '<di_dm>/aggregation_metrics/_tmp/<partition_id>' must exist before calling output adapter <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - <YYYMMDD:HH.MM.SS.MM>: ERROR: Assertion failed: base_file_exists(this->out_path), file /sas/dev/mva-f3ro52/di/src/output_adapter.c, line 132 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - <YYYMMDD:HH.MM.SS.MM>: Error: directory '<di_dm>/aggregation_metrics/_tmp/<partition_id>' must exist before calling output adapter <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - <YYYMMDD:HH.MM.SS.MM>: Error: job 'rpp_prep_<n>_cat_agg_-<n>' encountered a fatal error <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - <YYYMMDD:HH.MM.SS.MM>: <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - ERROR: TKTException code = 6 (Access violation) <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - at /sas/dev/mva-f3ro52/di/src/tkmi_exception.c:124 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #4 0x00002b353e6da7fc in tkmi_exception_handler (thread=0x2d31, <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - ctxt=0x2b35dd77225c, code=TKTE_UnknownException) <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - at /sas/dev/mva-f3ro52/di/src/tkmi_exception.c:88 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #5 0x00002b3535f7f196 in bktExcept () <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - from /apps/sas/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #6 0x00002b3535f8219b in bkt_segv () <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - from /apps/sas/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #7 0x00002b3535f7f764 in bkt_signal_handler () <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - from /apps/sas/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #8<YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #9 assert_fn (cond=908560600, cond_str=0x1 , <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - file=0x1 , line=2, <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - msg=0x2b35dd773940 "@9w\335\065+") <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - at /sas/dev/mva-f3ro52/di/src/base.c:1648 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #10 0x00002b353e6d6bcd in output_adapter_new3 (params=0x2b35362788d8, <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - abs_path=0x1 , <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - subdir=0x1 , force_use_schema_from_params=2) <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - at /sas/dev/mva-f3ro52/di/src/out <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - 20131204:18.16.46.76: put_adapter.c:132 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #11 0x00002b353e6d89cd in output_adapter_new2 (params=0x2b35362788d8, <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - subdir=0x1 ) <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - at /sas/dev/mva-f3ro52/di/src/output_adapter.c:76 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #12 0x00002b353e98e6be in rpp_agg_cat_output_params (context=0x2b35362788d8) <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - at /sas/dev/mva-f3ro52/dippr/src/rpp_agg_cat.c:664 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #13 0x00002b353e97d4cf in rpp_agg_service_cat_run (this=0x2b35362788d8, <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - plan=0x1) at /sas/dev/mva-f3ro52/dippr/src/rpp_agg_service.c:772 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #14 0x00002b353e97ca14 in rpp_agg_service_main (this=0x2b35362788d8) <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - at /sas/dev/mva-f3ro52/dippr/src/rpp_agg_service.c:1629 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #15 0x00002b353e98a395 in rpp_prep_service_cat_agg2 (context=0x2b35362788d8) <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - at /sas/dev/mva-f3ro52/dippr/src/rpp_prep_service.c:2078 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #16 0x00002b353e6c6678 in logic_fn (ctxt=0x2b353f851fe0, req=0x2b41f72c0880, <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - thread=0x2b35e44c7ff0, cb=0x2b356cd561e8) <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - at /sas/dev/mva-f3ro52/di/src/job_manager.c:1281 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #17 0x00002b353c8c9d0b in basicPuddleMain () <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - from /apps/sas/SASFoundation/9.3/sasexe/tkepdl.so <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #18 0x00002b3535f7d9a <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - 20131204:18.16.46.76: 6 in sktMain () <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - from /apps/sas/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #19 0x00002b3535f7effb in bktMain () <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - from /apps/sas/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #20 0x0000003ebee0683d in start_thread () from /lib64/libpthread.so.0 <YYYY-MM-DD HH:MM:SS,MMM> [RequestThread-<n>] DEBUG TKMI - #21 0x0000003ebe2d503d in clone () from /lib64/libc.so.6
This error occurs when two or more aggregations are run at the same time that contain data from the same partition.
The workaround for this issue is to run only one calendar or category aggregation at a time for any partition.
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_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 | ||
A fix for this issue for SAS Revenue Optimization 5.2_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M38.html#51788| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2013-12-10 12:51:13 |
| Date Created: | 2013-12-10 12:22:54 |