SAP Knowledge Base Article - Preview

2479251 - Query error "dfo.cxx:1982", non-fatal abort on s_workAllocator*dfo::ConstructWorkAllocatorInternal- SAP IQ

Symptom

A join query could encounter Non-Fatal error 'dfo.cxx:1982' in Distinct Sort(inserter) phase while it is processing with shadow parallel mode.

Similar stack trace can be seen in Order by instead of Distinct Sort.


 * Error =>

    ..  ********************************************************
    ..  **
    ..  **   Non-Fatal IQ Internal Error Detected
    ..  **   at dflib\dfo.cxx:1982  on thread 3400 (TID 146)
    ..  **   Error detected at DFO #43 Distinct Sort (inserter) (shadow 0)
    ..  **
    .. 
    ..  Exception Thrown from dflib\dfo.cxx:1982, Err# 0, tid 146 origtid 146
    ..  O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006001, SQLState: 'QBA01', Severity: 23
    ..  [20239]: IQ Internal error. Please report this to SAP IQ support.  -- (dflib\dfo.cxx 1982)

 * Stack =>

   ===== Thread Number ...=====
    ..  void __cdecl pcpstack( ..
    ..  void __cdecl StackTraceForThisThread( ..
    ..  df_Exception::df_Exception( ..
    ..  df_Exception::ThrowException( ..
    ..  dfo::ConstructWorkAllocatorInternal( ..
    ..  dfo::ConstructWorkAllocator( ..
    ..  dfo_cOrderByParaIn::PrefetchAndSort( ..
    ..  dfo_cOrderBy::SourcePreFetch( ..
    ..  dfo::SourcePreFetch( ..
    ..  dfo::SourcePreFetch( ..
    ..  dfjo_Hash::ExecWork( ..
    ..


Read more...

Environment

  • SAP IQ 16.1 SP04.x
  • SAP IQ 16 SP11.x

Product

SAP IQ 16.0

Keywords

CR815231 ; CR#815231 ; 815231 ; SQLCode: ; SQLCode ; -1006001"dfo.cxx:1982" ; "dfo_cOrderByParaIn" ; "Distinct Sort" ; "Order By" ; s_workAllocator*dfo::ConstructWorkAllocatorInternal ; dfo::ConstructWorkAllocatorInternal ; ConstructWorkAllocatorInternal ; s_workAllocator*dfo::ConstructWorkAllocator ; dfo::ConstructWorkAllocator ; ConstructWorkAllocator; Dml_Options7 ; Dml_Options8 , 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.