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
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.
SAP Knowledge Base Article - Preview