2398097 - IQ Crash at hs_ohc::GetHashFromLookupFP -- SAP IQ

• Server intermittantly crashes on simple select query - rerunning the query works without problem.

Stacktrace:

hos_mbtext::cnv_to_dtvchar_cond_actual
hos_keycond_dtvchar_actual
hs_ohc::GetHashFromLookupFP
hs_ohcGroup<s_btdiskblock, s_btitem>::GetUnconditionedKey
hs_ohcGroup<s_btdiskblock, s_btitem>::FetchOrdered
s_fetchOrdered::Fetch
vp_Cursor::Fetch
dfo_VerticalLeafCursor::FetchOpus
dfo_Root::FetchOpus
st_cursorIQtoSA::FetchRows
st_cursorIQtoSA::Execute
df_OpenCursor::Execute
st_command::DoCmdThroughResourceGate
st_iqdml::OpenCursor
UIQDML_OpenCursor
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholddml::OpenCursor

• Runnining a sp_iqcheckdb DBCC consistency checker to verify objects shows no issues

• Similar stack seen running an SELECT DISTINCT ... ORDER BY in SAP IQ 16.1 server

_fini+
s_fetchOrdered::Fetch()
vp_Cursor::Fetch()
dfo_cOrderBy::PrefetchAndSort()
dfo_cOrderBy::FetchOpus()
dfo_Root::FetchOpus()
st_cursorIQtoSA::Execute()
df_OpenCursor::Execute()

• SAP IQ 16.0
• SAP IQ 16.1

hs_ohc::GetHashFromLookupFP; hs_ohcGroup; stcxtlib/st_server.cxx:1919; st_server.cxx, sybase, core, crash, fail, select, distinct, CR799384, CR#799384, 799384, 's_fetchOrdered::Fetch', fetchordered, st_server, 'signal 11' , 813567 , 805352 , 797083 , 781529 , CR813567 , CR805352 , CR797083 , CR781529 , KBA , BC-SYB-IQ , Sybase IQ , Problem