SAP Knowledge Base Article - Preview

3163896 - Double Abort issue while query session cleaning up -- SAP IQ

Symptom

An out-of-space exception is raised during Select statement, and a cleanup routine is called. As part of the cleanup, the user connection is destroyed. However, the connection has a unreported pending error, and this triggers a second abort, resulting in a double-abort scenario.

IQ crashing with the following error without additional stack trace info...

.. **************************************************
.. *** SAP IQ Abort:
.. *** From: /home/iqabuild/views/links/r16.1.0_sp04_nbld_linux_64/gitsrc/cm/iqa/include/hos_canary.h:74
.. *** Rethrown from: oslib/hos_throw.cxx:316
..
.. **************************************************
..
.. ** Error from IQ connection: SA connHandle: 10291 SA connID: 17 IQ connID: 0000184342 User: fid_tblu_ro
.. ** Time of error: 2022-02-23 09:24:14
.. ** IQ Version: SAP IQ/16.1.040/15175/P/SP04.09
..
.. ** Command text:
.. ' when not("credit_supermart"."fyr_actg_prd" = 202003) then(case when("credit_supermart"."fyr_actg_prd" = 202004) then 'Apr''20'
.. ... then(case when("credit_supermart"."fyr_actg_prd" = 202207) then ..
.. While handling one abort, encountered another abort from the same thread.
.. Calling emergency shutdown.


Read more...

Environment

SAP IQ16.1 SP04.09(+)

Product

SAP IQ 16.0

Keywords

CR 826223, 826223, "encountered another abort", double abort, , 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.