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
Read more...
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.