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