2086947 - IQ 15.4 aborts at st_server.cxx:1440 in dfjo_NestedLoopOuters::FetchOpus

Symptom

On executing a SELECT query on columns of a view, which in turn is based on multiple views/tables with UNION ALLs and OUTER JOINS, caused IQ to abort at st_server.cxx:1440

The stacktrace will include the following frames in the aborting thread (usually the top most thread in the stacktrace, which will be either in the IQ server's .iqmsg file and/or a separate stacktrace file):

I. 06/04 16:07:08. 0000310963 pc: 0x7f154269565f hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x18f
I. 06/04 16:07:08. 0000310963 pc: 0x7f15431434df SigHndlr+0x4f
I. 06/04 16:07:08. 0000310963 pc: 0x3431c0f500 
I. 06/04 16:07:08. 0000310963 pc: 0x7f154255de74 dfjo_NestedLoopOuters::FetchOpus()+0xa94
I. 06/04 16:07:08. 0000310963 pc: 0x7f154260b2dc df_UnionAllFetchIterator::ExecWork(int&, unsigned int)+0xdc
I. 06/04 16:07:08. 0000310963 pc: 0x7f15428e48a7 workAllocator::DoWork(unsigned int)+0xb7

Environment

IQ 15.4, any SP up to and including SP04.10

Product

SAP Sybase IQ 15.4

Keywords

IQ 15.4, abort, outer join, union all, nested views , 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.