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.
SAP Knowledge Base Article - Preview