SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Environment

IQ15.2, 15.4 GA

Product

SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

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

About this page

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

Search for additional results

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