SAP Knowledge Base Article - Preview

2362250 - opt_TableNode.cxx:280 internal error is occurred when executing union all query is executed.

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

SAP IQ 16.0

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.