Problem with SASMerchIntelGridSvr5.41

[John_Wick]

Hi all! 

I'm facing a problem with SASMerchIntelGridSvr5.41. If you run plan optimization in Regular Price Plans in SAS Merchandise Intelligence, an error appears in the interface: ERROR: A fatal error was encountered while processing the STP request.

An error appears in the SASMerchIntelGridSvr5.41 log:

Spoiler

2024-04-05 18:54:53,131 [http-bio-5191-exec-8-0509] DEBUG com.sas.solutions.di.server.invoke - <- com.sun.proxy.$Proxy13.getRequestStatus took 3 ms.
2024-04-05 18:55:00,994 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - TKMI LOG: sk-sas-grid: rpo_optimize.2.log (LOCAL)
2024-04-05 18:55:00,994 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI -
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - <U+FEFF>20240405:18.54.45.93: running command: run='rpo_optimize'
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.45.97: Loading Dim for partition_id=1 gps=0 sk=244810
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.57.34: Completed Loading Dim for partition_id=1 gps=0 sk=244810 in 11 second
s (dim -> 162 MB/s, io adapter -> ~0.0 MB/s)
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.58.70: ERROR: consumer thread 'c_(null)' encountered a fatal error
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.58.70:
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - ERROR: TKTException code = 10 (Domain exception)
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #4 0x00007fede1e00c46 in tkmi_exception_handler ()
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #5 0x00007fedf000d3f2 in bktExcept ()
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmk.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #6 0x00007fedf0011d0d in bkt_fpe ()
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmk.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #7 0x00007fedf000da44 in bkt_signal_handler ()
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmk.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #8 <signal handler called>
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #9 0x00007fede1dfc153 in io_get_int ()
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #10 0x00007fede20a538e in rpo_plan_member_cb ()
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #11 0x00007fede1df7834 in process_rows ()
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #12 0x00007fedf000b494 in sktMain ()
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmk.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #13 0x00007fedf000d231 in bktMain ()
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmk.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #14 0x00007fedf1418ea5 in
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.58.70: start_thread () from /lib64/libpthread.so.0
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #15 0x00007fedf0a04b0d in clone () from /lib64/libc.so.6
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI -
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI -
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI -
2

2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI -
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.58.70: ERROR: Assertion failed: ! this->pc_error, file /sas/wky/mva-m1ro541/di/src/input_adapter.c, line 726
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.58.70: Error while reading table '(null)' (see previous error message(s))
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI -
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.59.83:
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - ERROR: TKTException code = 6 (Access violation)
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #4 0x00007fede1e00c46 in tkmi_exception_handler ()
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #5 0x00007fedf000d3f2 in bktExcept ()
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmk.so
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #6 0x00007fedf000da44 in bkt_signal_handler ()
2024-

[SASKiwi]

I doubt there are many users on the Community who have experience with this specialist prooduct, so opening a Tech Support track will likely get you a faster response.

[John_Wick · Accepted solution]

It was the problem with value RPO_PLAN_MEMBER_SK in the table DI_DM.RPO_PLAN_MEMBER.

Id has become more than MAX_VALUE of int in the C language.

So it was an overflow problem.