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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.