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