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 genrates 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 , 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.