1963607 - [SAP IQ] IQ Internal Error: Non-Fatal IQ Internal Error Detected at df_MapRecordToDFEs.cxx:199

A query which uses a Rank function was rolled back due to below internal error.

[iqmsg]

  ********************************************************
  **
  ** Non-Fatal IQ Internal Error Detected
  ** at df_MapRecordToDFEs.cxx:199 on thread 23388 (TID 107)
  **
  ...
  ** Error from IQ connection: SA connHandle: 461856 SA connID: 54 IQ connID: 0022906780 User: user001
  ** Time of error: 2013-11-10 09:46:52
  ** IQ Version: Sybase IQ/15.2.0/101123/P/ESD 2
  ** OS info: IQ built on: RS6000MP/AIX 5.3.0, Executed on: AIX/host001/1/6/00CFA0D54C00
  ** Command status when error occured: COMMAND ACTIVE
  ** Command text:
  
  pc: 0x8000000005d4410 .pcstkwalk(stk_trace*,int,db_log*,hos_fd*)+0x170()
  pc: 0x8000000005d3e70 .ucstkgentrace(int,int)+0xb0()
  pc: 0x8000000005d4850 .StackTraceForThisThread(const char*,int,const char*,const char*,const char*)+0x1fc()
  pc: 0x80000000042f384 .df_Exception::df_Exception(const char*,int,df_Exception::df_ErrorCode,const char*,const char*,const dfo*,const df_Evaluable*)+0x240()
  pc: 0x800000000a6c878 .df_MapRecordToDFEs::InitAddDFE(dfe*,dfo*)+0x78()
  pc: 0x800000000d14794 .dfo_Partition::PrepareOpus()+0x298()
  pc: 0x800000000d0e4f8 .dfo_Ranking::PrepareOpus()+0x98()
  pc: 0x8000000004fa02c .dfo::PrepareChildren()+0xa4()
  pc: 0x80000000051d57c .dfo::PrepareOpus()+0x18()
  pc: 0x8000000004e5a88 .dfo_Root::Prepare()+0xf8()
  pc: 0x800000000155454 .db_cursorIQtoIQ::Prepare()+0x2c()
  pc: 0x80000000014cc94 .db_cursorIQtoIQ::Prepare()+0x1c()
  pc: 0x800000000118c10 .db_sqlinsert::SPrepare()+0x104()
  pc: 0x8000000001176ec .db_sqlinsert::Prepare()+0x7a8()
  pc: 0x800000000169de0 .st_command::DoCmdThroughResourceGate()+0x144()
  pc: 0x800000000de9d20 .st_iqdml::Insert(a_statement*,UIConnection*,UICursor*)+0x124()
  ...
  ...
  pc: 0x9000000048d2350 .request_task(void*)+0x2c()
  pc: 0x9000000049935b4 .run_task_body+0x34()
  pc: 0x900000004a62fcc .UnixTask::pre_body(void*)+0x138()
  pc: 0x900000000b4dd54 .fp_swap_rnd+0x9653fc()
  ******************* End of STACKTRACE ******************
  **
  ** End of stack trace from Non-Fatal IQ Internal Error df_MapRecordToDFEs.cxx:199
  **
  ********************************************************
  
  Exception Thrown from df_MapRecordToDFEs.cxx:199, Err# 0, tid 107 origtid 107
  O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
  [20238]: IQ Internal error. Please report this to Sybase IQ support.
  Rbck
  PostRbck

[sqltrc]
  +1,>,461856
  +9,<,461856,PREPARE,call user_proc('20131110') // include a query which use a rank function
  =,>,461856,PREPARE,65539
  =,<,461856,OPEN,65539
  +51179,E,461856,-1006000,IQ Internal error. Please report this to Sybase IQ support. -- (df_MapRecordToDFEs.cxx 199)
  =,>,461856,OPEN,0
  +1,<,461856,DROP_STMT,6553

IQ15.2, 15.4 GA

DML_Options9, df_MapRecordToDFEs, fatal, internal, df_MapRecordToDFEs::InitAddDFE, CR 607152, CR #607152, 607152, SAP IQ, IQ , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed