SAP Knowledge Base Article - Preview

3253635 - A SQL with 'IN-SubQuery' ran into Non-Fatal error or IQ_Abort at "dfo_VerticalLeafCursor::ExecuteINSubQueryBody" -- SAP IQ

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.