Symptom
Following Query returns a Non-Fatal error or Abort like below,
* SQL
WITH "t1"
as (select "Col1_ID","count"(distinct "fbc") as "Col2_Cards"
from "User1"."TAB1"
where "Log_Date" >= '2022-07-01'
group by "Col1_ID"
having "Col2_Cards" between 3 and 200
order by "Col2_Cards" desc)
select "Log_Date","count"("Log_Date") as "Col2_Events"
from "User1"."TAB1"
where "Col1_ID" = any(select distinct "Col1_ID" from "t1")
and "Log_Date" >= '2022-07-01'
group by "Log_Date"
order by "Col3_OFE ;
* Non-Fatal error or Abort :
.. **************************************************
.. ** Non-Fatal IQ Internal Error Detected
.. ** at dflib/dfo_VerticalLeafCursor.cxx:3361 on thread 140643606918912 ..
.. ** Error detected at DFO #06 Leaf (shadow 0)
..
===== Thread Number ... =====
..
.. StackTraceForThisThread ..
..
.. df_Exception::ThrowException ..
.. dfo_VerticalLeafCursor::ExecuteINSubQueryBody ..
.. dfp_In::ExecuteSubqueryBody ..
.. dfo_VerticalLeafCursor::ExecuteUnCorrelatedSubqueries ..
..
..
Or,
.. **************************************************
.. *** SAP IQ Abort:
.. *** From: stcxtlib/st_server.cxx:2455
===== Thread Number ... =====
.. hos_ABORT ..
..
.. dfo_VerticalLeafCursor::ExecuteINSubQueryBody ..
.. dfp_In::ExecuteSubqueryBody ..
.. dfo_VerticalLeafCursor::ExecuteUnCorrelatedSubqueries ..
.. dfo_VerticalLeafCursor::EnsureBindPredsExecuted ..
.. dfo_VerticalLeafCursor::LeafShadowPreFetch ..
.. dfo_VerticalLeafCursor::SourcePreFetch ..
..
Read more...
Environment
SAP IQ16.1 SP04.x
Keywords
ExecuteINSubQueryBody , ExecuteSubqueryBody , dfo_VerticalLeafCursor , CR827203, , 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.