Symptom
IQ failed to execute due to below internal error when IQ chose the Nested-Loop Pushdown as a join algorithm.
[SQL]
select COL001
from TAB001 T1, TAB002 T2
where
(1=1)
And (CASE WHEN COL001 IS NULL THEN COL002 ELSE COL001 END = T1.COL003);
[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
- SAP IQ 15.4 ESD1
- SAP IQ 15.4 ESD2
- SAP IQ 15.4 ESD3
Product
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 , Bug Filed
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.