SAP Knowledge Base Article - Preview

2764096 - Server aborted with stack 'MedianAggregate , CalculateEven_numeric ' -- SAP IQ

Symptom

A Customer has been encountered temporary crashes while inserting data using procedures.

  • Current findings :

        - Nothing reproduce on customer system and in-house both
        - When aborted, executed procedure and insert queries were different.
           Those applcations are existing program and have been executed a lot of times every day.
        - After crash, re-run the same step was not reproduced the problem at all.
        - Mostly customer uses 'Domain' -- pre-defined datatype -- for columns in table.

  • Abort & Stack :

I. 03/05 08:39:08. 0000699875 [20896]: Insert for '#Tab001' completed in 1 seconds. 286536 rows inserted.
I. 03/05 08:39:08. 0000699875 CrT
I. 03/05 08:39:08. 0000699875 **************************************************
I. 03/05 08:39:08. 0000699875 *** SAP IQ Abort:
I. 03/05 08:39:08. 0000699875 *** From: stcxtlib/st_server.cxx:2065
I. 03/05 08:39:08. 0000699875 *** PID: 7376
I. 03/05 08:39:08. 0000699875 *** Message: caught signal 11, program abort
I. 03/05 08:39:08. 0000699875 *** Thread: 140475209250560 (TID: 450)
I. 03/05 08:39:08. 0000699875 **************************************************
..
I. 03/05 08:39:08. 0000699875 ** Command text:
call "DBA"."USER_Procedures001"('2019-03-05',1)
..
===== Thread Number ... =====
..
.. hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x26a
.. SigHndlr+0x4f
.. _fini+0x377b126c
.. _fini+0x36d20fc5
.. dfe_MedianAggregate::CalculateEven_numeric (dfe_MedianAggregate*)+0x92
.. dfe_MedianAggregate::Evaluate()+0xa3
.. dfo_GroupByOrdered::FetchOpus()+0x1ee
.. dfo_InsertPrepare::FetchOpus()+0x109
.. dfo_CheckConstraintFilter::FetchOpus()+0x126
.. dfo_ColumnVectorBase::FetchOpus()+0x82
.. dfo_RowID::FetchOpus()+0x4e
.. dfo_IndexInsert::FetchOpus()+0x7a
.. df_CombinerFetchContext::Fetch()+0x5d
.. hc_dfrun::FillRun(unsigned int&, int, int)+0x37
.. hc_dmfrun::InitNextWorkUnit ..
..


Read more...

Environment

  • SAP IQ16.1 SP02.03
  • SAP IQ16.1 SP03.07
  • SAP IQ16.1 SP04.06

Product

SAP IQ 16.1

Keywords

MedianAggregate , CalculateEven_numeric , dfe_MedianAggregate , dfe_MedianAggregate::Evaluate , DOMAIN , , 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.