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.LON_CNSL_CNLN_NO                                                                                 
    into #bonbu1_01                                                                                                                 
    FROM (                                                                                                                         
          SELECT A.CSNCS_TS                                                                   
               , A.LON_CNSL_CNLN_NO                                                                                                 
               , A.LON_CNLN_PGRS_SCD                                                                                                
            FROM A_TAB A                                                    
    ) T2                                                                                   
    ,(SELECT   T3.LON_APLC_DCD                                                                                                          
              , T3.LON_CNSL_CNLN_NO                                                                                                 
              , T3.TRN_SCD                                                                                                        
    FROM B_TAB T3                                                                                                 
          LEFT OUTER JOIN (SELECT LON_CNSL_CNLN_NO                                                                                                                                                                               
                                , RANK() OVER (PARTITION BY LON_CNSL_CNLN_NO, CSNCS_SRN ORDER BY CNRT_ARR_SRN DESC) RK              
                             FROM C_TAB
                               ) T6                             
            ON T3.LON_CNSL_CNLN_NO = T6.LON_CNSL_CNLN_NO                                                                                                                                                                  
           AND T6.RK = 1                                                                                                           
    ) TX                                                                                                                              
    WHERE T2.LON_CNSL_CNLN_NO        = TX.LON_CNSL_CNLN_NO                                                                           
    AND TX.TRN_SCD      = '2'                                                                
    AND TX.LON_APLC_DCD IN ('01','02','04','05','06','07')                                                                        
    AND T2.LON_CNLN_PGRS_SCD = '1'                                                      
    AND DATEFORMAT(T2.CSNCS_TS,'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.