Problem Note 52008: An exception might be generated when aggregating a calendar plan and a category plan with the same scope in a batch run
 |  |  |  |  |
In SAS® Promotion Optimization, an exception might be generated when aggregating a calendar plan and a category plan with the same scope in a batch run. The exception generated in the MerchIntelGridSvr.log might be similar to the following:
2013-12-17 00:27:52,257 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: 00:27:52 rpp_prep_137_cal_agg_-11544: Warning: unable to DROP TABLE 'nl_110234_19356_137_n11544'. Trying an explicit delete of the file.
2013-12-17 00:27:52,257 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: 00:27:52 rpp_prep_137_cal_agg_-11544: TKStatus = 0x80fff802
2013-12-17 00:27:52,257 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: 00:27:52 rpp_prep_137_cal_agg_-11544: Diagnostic Record 1: SQL State HY000, BASE driver, cannot terminate table creation process
2013-12-17 00:27:52,257 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: 00:27:52 rpp_prep_137_cal_agg_-11544: ERROR: Assertion failed: TKTS_SUCCEEDED(tks), file /u/sckell/dev/mva-f3ro52-HF1/di/src/adapter_base.c, line 1756
2013-12-17 00:27:52,280 [pool-10-thread-3] DEBUG TkMiServerUtils - STDOUT: 00:27:52 dimlq_208202_306651: Completed Loading Dim for partition_id=208202 gps=1845082 sk=306651 in 259 seconds (dim -> 4 MB/s, io adapter -> ~0.0 MB/s)
2013-12-17 00:27:52,462 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: 00:27:52 rpp_prep_137_cat_agg_-11544: Error: job 'rpp_prep_137_cat_agg_-11544' encountered a fatal error
2013-12-17 00:27:52,462 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: 00:27:52 rpp_prep_137_cat_agg_-11544:
2013-12-17 00:27:52,462 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: ERROR: TKTException code = 6 (Access violation)
2013-12-17 00:27:52,462 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: /apps/sas/SASFoundation/9.3/sasexe/tkmi.so(tktracex+0x2d) [0x2b51181f788d]
2013-12-17 00:27:52,462 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: /apps/sas/SASFoundation/9.3/sasexe/tkmi.so(tkmi_exception_handler+0x6b) [0x2b5117f1e6db]
2013-12-17 00:27:52,462 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: /apps/sas/SASFoundation/9.3/sasexe/tkmk.so(bktExcept+0x66) [0x2b511168c196]
2013-12-17 00:27:52,462 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: /apps/sas/SASFoundation/9.3/sasexe/tkmk.so(bkt_segv+0xb) [0x2b511168f19b]
2013-12-17 00:27:52,462 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: /apps/sas/SASFoundation/9.3/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x2b511168c764]
2013-12-17 00:27:52,462 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: /lib64/libpthread.so.0 [0x3ebee0eca0]
2013-12-17 00:27:52,462 [pool-10-thread-2] DEBUG TkMiServerUtils - STDOUT: /apps/sas/SASFoundation/9.3/sasexe/tkmi.so(__intel_new_memcpy+0x888) [0x2b51183c59e8]
This issue occurs only in batch runs, and not in online aggregation.
There is no workaround for this issue.
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#52008| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2014-05-06 13:14:53 |
| Date Created: | 2014-01-09 11:48:16 |