SAP Knowledge Base Article - Preview

2002321 - [SAP IQ] Non-Fatal IQ Internal Error Detected at dfo_Join.cxx:452.

Symptom

IQ failed to execute due to below internal error when IQ chose the Nested-Loop Pushdown as a join algorithm.

[SQL]

select C12_HESAP_NO
from PAR3 PAR, C$_0FIS_SHIP_CMPLD_WRK3
where
(1=1)
And (CASE WHEN C12_HESAP_NO IS NULL THEN C11_KISI_NO ELSE C12_HESAP_NO END = PAR.PAR_NO_SRC_STM) ;

[Error]

 ******************************************************** 
 ** 
 ** Non-Fatal IQ Internal Error Detected 
 ** at dfo_Join.cxx:452 on thread 3861047040 (TID 35) 
 ** Error detected at DFO #03 Join (Nested-Loop PushDown) 
 ** for expression: CAST(DUMMY.C$_0FIS_SHIP_CMPLD_WRK3.C12_HESAP_NO AS INT64) (qb:1, addr:0x7fafc801a348) 
 ** 
 ...
 ** Command text: 
 ***************** This is the STACKTRACE ***************
 ...
  dfo_Join::ValidateLocalInternalConsistency()….
  dfo::ValidateInternalConsistency()….
  dfo_Root::Prepare()….
  st_cursorIQtoSA::Prepare()….
  df_OpenCursor::Prepare()….


Read more...

Environment

IQ 15.4 ESD1,2,3

Product

SAP Sybase IQ 15.4

Keywords

dfo_Join.cxx, ValidateLocalInternalConsistency, 733441, dfo_Join.cxx:452, SAP IQ, SYBASE, CR #733441, CR 733441 , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.