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 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 , Problem

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.