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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.