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