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.
SAP Knowledge Base Article - Preview