SAP Knowledge Base Article - Preview

3110661 - IQ server node crashes on df_Heap::GenConstList (large IN-clause) -SAP IQ

Symptom

IQ secondary node crashed on one specific query involving large IN-List ( 14585 values ).

According to IQ Maximum Limits, IQ supports up to 250,000 IN-List values.

Stacktrace generated :
 
0000208644 **************************************************
0000208644 ***   SAP IQ Abort:
0000208644 ***      From:  stcxtlib\st_server.cxx:1114
0000208644 ***      PID: 4592
0000208644 ***      Message: Program Abort
0000208644 ***      Thread: 5776  (TID: 88)
0000208644 **************************************************
0000208644 0000005776 Stacktrace requested from stcxtlib\st_server.cxx:1114 on thread 5776 (TID 88) start stacktrace
0000208644     **  IQ Version:  SAP IQ/16.1.040/14235/P/SP04.06
**  OS info:  IQ built on: MS/Windows 2012 R2,  Executed on: Windows/KMDSAPIQ2006/WinNT/10.0/Build 14393//x86 Family/level 6/Model 85/Stepping 7/20 CPU(s)
0000208644     **  Command status when error occurred:  CURSOR ACTIVE
0000208644     **  Command text: 
select  ... where  col in(......)
0000208644     **  Dump all thread stacks at stcxtlib\st_server.cxx:1114 for PID: 4592
***************** This is the STACKTRACE ***************
 .. 
 .. void __cdecl hos_ABORT( ..
 .. long __cdecl ExcpFilter( ..
 .. UnhandledExceptionFilter + 0x157
 .. memset + 0x21b1
 .. _C_specific_handler + 0x96
 .. _chkstk + 0x11d
 .. RtlImageNtHeaderEx + 0x483
 .. KiUserExceptionDispatcher + 0x3a
 .. memmove + 0x39
 .. <unknown>
 .. <unknown>
 .. private: void __cdecl df_Heap::GenConstList(..
 .. private: class df_Evaluable * __ptr64 __cdecl df_Heap::GenInDFP( ..
 .. public: class df_Evaluable * __ptr64 __cdecl df_Heap::GenerateDF( ..
 .. public: void __cdecl opt_QueryTree::AttachQueryNodesRestrictions( ..
 .. public: void __cdecl opt_QueryTree::CreateNextQueryNode( ..


Read more...

Environment

  • SAP IQ 16.1
  • Windows

Product

SAP IQ 16.1

Keywords

SYBASE , CR825190, CR#825190,  825190, large IN-List , IN-List , "IN List" , , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.