Symptom
opt_TableNode.cxx internal error is occurred when executing union all query is executed.
[Error in iqmsg]
********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at optlib/opt_TableNode.cxx:280 on thread 434 (TID 32)
**
...
..opt_ViewNode18GatherLeafMetaDataEv
..opt_QueryTree16ProcessQueryTreeEv
..opt_Select12GenerateDFOsEP7df_HeapP12opt
..opt_Driver12GenerateTreeEP9QueryNodeP9st
..st_cursorIQtoSA5ParseEv
[Problematic Query]
select top 1000 "T2".*
from "OWNER1"."TAB001" as "T2",
"OWNER1"."TAB002" as "MA" ,
"OWNER1"."TAB003" as "M6" ,
(select '1' as "COL001"
union all select '2' as "COL001"
union all select '3' as "COL001"
union all select '4' as "COL001") as "TTT"
where 1 = 1 and "T2"."Date_Col" = '201601'
and "MA"."Date_Col" = '201601' and "M6"."Date_Col" = '999912'
and "M6"."COL002" = "T2"."COL002"
...
Read more...
Environment
SAP IQ16
Product
Keywords
IQ, SYBASE, DB, union all, dummy, iq_dummy, opt_TableNode, opt_TableNode.cxx:280, opt_ViewNode18GatherLeaf , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , HAN-DYT , SAP HANA Dynamic Tiering , 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.