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
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.