Symptom
While running a select query, suddenly IQ server was aborted with symbol 's_fhashtb::InsertKey'. In a certain case, the select query was a daily job.
Following is stack traces of reported Cases.
- Abort stack in CR-826727 ;
...
.. hos_ABORT ..
.. s_fhashtb::InsertKey(s_fhProber&)+0x346
.. s_phash::InsertAndAggregateWithinQuota()+0x410
.. dfo_GroupByUnordered::FirstFetchWithNullsOrVarchar()+0x152
.. dfo_GroupByUnordered::FirstFetch()+0x36e
.. dfo_GroupByUnordered::FetchOpus()+0xb5
.. dfo_cOrderBy::PrefetchAndSort()+0x58e
.. dfo_cOrderBy::FetchOpus()+0x10c
.. dfo_GroupByOrdered::FetchOpus()+0x16a
.. dfjo_Hash::Fetch_T2_IntoHash()+0x68a
..
- Abort stack in CR-800309 ;
...
.. hos_ABORT ..
.. s_fhasht::InsertKey ..
.. s_phash::Insert ..
.. dfjo_Hash::Fetch_T2_IntoHash ..
.. dfjo_Hash::SourcePreFetch ..
.. dfo_Join::SourcePreFetch ..
.. dfo_cOrderByParaIn15PrefetchAndSort ..
.. dfo_cOrderBy::SourcePreFetch ..
.. dfo_SourcePreFetch ..
..
Read more...
Environment
- SAP IQ16.0 SP10.15
- SAP IQ16.1 SP04.11
Product
Keywords
"fast hash" ; "s_fhashtb::InsertKey" ;CR800309; 800309 ; CR826727, , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.