Problem Note 59202: The %TKMI_JOB_RO etl_end_service task generates "ERROR: TKTException code = 10 (Domain exception)"
 |  |  |  |  |
The SAS® Revenue Optimization %TKMI_JOB_RO etl_end_service task might generate the following error in the MerchIntelGridsvr.log file:
DEBUG - STDOUT: <HH:MM:SS> c_geo_prod_vat: ERROR: consumer thread 'c_geo_prod_vat' encountered a fatal error DEBUG - STDOUT: <HH:MM:SS> c_geo_prod_vat: DEBUG - STDOUT: ERROR: TKTException code = 10 (Domain exception) DEBUG - STDOUT: #4 0x00007f35575f720c in tkmi_exception_handler (thread=0x2f93, ctxt=0x7f352fff628c, code=TKTE_UnknownException) at /sas/dev/mva-f4ro52/di/src/tkmi_exception.c:88 DEBUG - STDOUT: #5 0x00007f3560eac116 in bktExcept () from <SASHOME>/SASFoundation/9.3/sasexe/tkmk.so DEBUG - STDOUT: #6 0x00007f3560eaf825 in bkt_fpe () from <SASHOME>/SASFoundation/9.3/sasexe/tkmk.so DEBUG - STDOUT: #7 0x00007f3560eac6e4 in bkt_signal_handler () from <SASHOME>/SASFoundation/9.3/sasexe/tkmk.so DEBUG - STDOUT: #8 DEBUG - STDOUT: #9 0x00007f35576d395e in prod_add_vat (prod=0x7f3550b819e0, geo=0x7f3551c15e20, start_dt=18294, end_dt=20709, vat=0) at /sas/dev/mva-f4ro52/di/src/product.c:447 DEBUG - STDOUT: #10 0x00007f355771f91d in vat_row_callback (context=0x7f3550b819e0, a=0x7f3551c15e20) at /sas/dev/mva-f4ro52/di/src/dim_data_loader.c:2205 DEBUG - STDOUT: #11 0x00007f35575f0622 in process_rows (context=0x7f353fff6cc8) at /sas/dev/mva-f4ro52/di/src/input_adapter.c:856 DEBUG - STDOUT: #12 0x00007f3560eaa926 in sktMain () from <SASHOME>/SASFoundation/9.3/sasexe/tkmk.so DEBUG - STDOUT: #13 0x00007f3560eabf7b in bktMain () from <SASHOME>/SASFoundation/9.3/sasexe/tkmk.so DEBUG - STDOUT: #14 0x0000003f91207aa1 in start_thread () from /lib64/libpthread.so.0 DEBUG - STDOUT: #15 0x0000003f90ee8aad in clone () from /lib64/libc.so.6
This issue occurs when one or more rows in DI_DM.GEO_PROD_VAT have a missing value for VAT_PCT.
To resolve this issue, send STG_GEO_PROD_VAT records to provide a value for VAT_PCT for geo-prods that are missing a value. If there is no VAT, then set the value of VAT_PCT to 0.
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 Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 | ||
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#59202| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-02-17 10:43:19 |
| Date Created: | 2016-10-21 13:09:14 |