SAP Knowledge Base Article - Preview

2390414 - Query using Nested-Loop PushDown join fails in opt_Driver::ApplyShadowTransform - SAP IQ

Symptom

Query with joins on 2 permanent tables and a temporary table using Nested-Loop PushDown join generates a non-fatal stack trace in
opt_Driver::ApplyShadowTransform.

Excerpt  of IQMSG


********************************************************
**
**       Non-Fatal IQ Internal Error Detected
**       at optlib\opt_ShadowTransform.cxx:2550  on thread 2724 (TID 48)
**       Error detected at DFO #06 Join (Nested-Loop PushDown)
**
**  Command text:

 select "t0".*

    from "ltb_andr_agrcus" as "t0"
      join "tb_1" as "t1" on "t1"."rtlcustid" = "t0"."rtlcustid" and "t1"."verfindate" = '2999-12-31'
      join "tb_2" as "t2" on "t2"."rtlcusprid" = "t1"."rtlcustid" and "t2"."verid" = "t1"."verid";

opt_Driver::ApplyShadowTransform
opt_Driver::AddParallelShadowSubtrees
opt_Driver::AddParallelShadowSubtrees
opt_Driver::GenerateTree
st_cursorIQtoSA::Parse
df_OpenCursor::Parse
st_command::DoCmdThroughResourceGate
st_iqdml::OpenCursor


Read more...

Product

SAP IQ 16.0

Keywords

803047 ; CR 803047 ; CR# 803047 ; stack trace ;
opt_Driver::ApplyShadowTransform ; opt_Driver ; ApplyShadowTransform ;
opt_Driver::AddParallelShadowSubtree ; AddParallelShadowSubtree ; , KBA , BC-SYB-IQ , Sybase IQ , 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.