SAP Knowledge Base Article - Preview

2067600 - Internal Error "dflib/dfo_Combiner.cxx:2099"

Symptom

1. IQ server returns an error "dflib/dfo_Combiner.cxx:2099" against a select statement.

SELECT TX.COL001
into #TMPTAB001
FROM (
SELECT A.COL002
, A.COL001
, A.COL003
FROM TAB002 A
) T2
,(SELECT T3.COL004
, T3.COL001
, T3.COL005
FROM TAB003 T3
LEFT OUTER JOIN (SELECT COL001
, RANK() OVER (PARTITION BY COL001, COL006 ORDER BY COL007 DESC) COL008
FROM TAB004
) T6
ON T3.COL001 = T6.COL001
AND T6.COL008 = 1
) TX
WHERE T2.COL001 = TX.COL001
AND TX.COL005 = '2'
AND TX.COL004 IN ('01','02','04','05','06','07')
AND T2.COL003 = '1'
AND DATEFORMAT(T2.COL002,'YYYYMMDD') BETWEEN SUBSTR('20111130', 1, 6) || '01' AND '20111130' ;

2. Error messages

** Non-Fatal IQ Internal Error Detected
** at dflib/dfo_Combiner.cxx:2099 on thread 20866832 (TID 759)
** with Query_Name: Error_SQL
** Error detected at DFO #51 Parallel Combiner
................
................
pcstkwalk(...........
ucstkgentrace(...........
StackTraceForThisThread(...........
df_Exception::df_Exception(...........
df_Exception::ThrowException(...........
dfo_Combiner::GetWorkAllocator(...........
dfo_cOrderBy::AllocateShadowResources(...........
dfo::RecursivelyAllocateShadowResources(...........

 
3. If "INTO " clause is removed from the problematic query, it works fine.


Read more...

Environment

SAP IQ 16.0 sp 08 PL04 and below

Product

SAP IQ 16.0

Keywords

SAP IQ, IQ, CR 764089, CR764089, dfo_Combiner, dflib/dfo_Combiner, Parallel Combiner, dfo_cOrderBy::AllocateShadowResources, dfo_cOrderBy, AllocateShadowResources , 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.