SAP Knowledge Base Article - Preview

2748492 - Query with CASE expressions could hit non-fatal stacks at s_barray - SAP IQ

Symptom

Query with CASE expressions, depending on data cardinality and/or distribution could hit non-fatal error in  slib\s_barray.cxx:8010/7964/7941...

Excerpt of IQMSG and stack trace

I. 10/08 09:15:57. 0000004675 [20896]: Insert for 's_barray_7942' completed in 0 seconds.  1048576 rows inserted.
I. 10/08 09:15:58. 0000004675 [20896]: Insert for 's_barray_7942' completed in 1 seconds.  2097152 rows inserted.
I. 10/08 09:15:58. 0000004675 Cmt 4930367
I. 10/08 09:15:58. 0000004675 TINFO t=4930366 v=4930366 c=4930367 gt=0 gc=0 pcv=0 ME=0 MSE=0 TRR=0 #=0
I. 10/08 09:15:58. 0000004675 Txn 4930368 0 4930368
I. 10/08 09:15:58. 0000004675 LoadPage, recid=1: no matching ridmap/mergemap
I. 10/08 09:15:58. 0000004675  barray t10484 C1 BEGIN dump RidMap:
I. 10/08 09:15:58. 0000004675 barray t10484 C1 startRecid=961 endRecid=88256 block=2 hasNBit=1
I. 10/08 09:15:58. 0000004675 barray t10484 C1 startRecid=89025 endRecid=176320 block=3 hasNBit=1

s_bArrayLocater::LoadPage
s_bArrayLocater::LocateTokenRecord
hs_dpfetch::FetchToken
vpp_FindIter::DoOneWorkunit
vpp_FindIter::ExecWork
workAllocator::DoWork


Read more...

Environment

  • SAP IQ16.0
  • SAP IQ16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

s_bArrayLocater::LoadPage;  s_bArrayLocater::LocateTokenRecord; "no matching ridmap/mergemap" ;  ridmap ; mergemap; , 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.