SAP Knowledge Base Article - Preview

2773281 - A complex select query with subquery & outer join hit several crashes, st_server.cxx -- SAP IQ

Symptom

A complex query with subquery & outer join hit several crashes, but nothing repro. Stack dumped like below,

===== Thread Number 140686164752128 (IQ connID: 0000032839) =====
..
.. hos_ABORT ..
.. SigHndlr+0x59
.. _fini+0xe773bfc
.. dfo_Combiner::FetchOpus()..
.. dfo_PreFilter::FetchOpus()..
.. dfo_GroupBySingle::FetchOpus()..
.. dfo_UnionAll::FetchOpus()..
.. dfo_GroupBySingle::FetchOpus()..
.. dfo_VerticalLeafCursor::ExecuteScalarSubQueryBody..
.. dfp_Compares::ExecuteSubQueryBody()..
..
.. vpp::Execute(s_bm..
.. vp_Predicates::FirstExecute()....
.. dfo_VerticalLeafCursor::ExecuteVerticalPredsAndPrepareToProject()+0x62
..

All base tables check clean, no issues there.


Read more...

Environment

SAP IQ16.0 SP11.x

Product

SAP IQ 16.0

Keywords

818773, , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.