SAP Knowledge Base Article - Preview

2761298 - SELECT query fails with a s_barray.cxx Non-Fatal abort at s_bArrayLocater::LoadPage, barray ridmap missing error - SAP IQ

Symptom

  • SELECT query failing Non-Fatal IQ Internal Error Detected at slib/s_barray.cxx:7983 
     
  • Stacktrace contains this call sequence..

s_bArrayLocater::LoadPage
s_bArrayLocater::LocateTokenRecord
s_indexfetch::s_fetchRetVal hs_dpfetch::FetchNoCopyContiguous
s_fetchRow::FetchContiguous()
vp_Cursor::Fetch()
dfo_Root::FetchOpus(
st_cursorIQtoSA::FetchRows
st_cursorIQtoSA::Fetch()
hos_thread::Main()
hos_lwtask::Start

  • Exception Thrown from slib/s_barray.cxx:7984, Err# 16

  • O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006003, SQLState: 'QBA03', Severity: 23

  • If a sp_iqcheckdb VERIFY is run against table objects involved in the failing query it may return Barray ridmap errors similar to these 

barray t913 OSS_ID: CheckColumnEBMCoverage
barray t913 *** ridmap missing region for [10,14] last region: [1,9]
DBCC: *** missing recid in ridmap/mergemap - <table name> : slib/s_dpidx.cxx:4556
slib/s_dpidx.cxx:3937 *** <table name> (varchar): ridmap token counts and columnEBM mismatch - 9, 14

Exception Thrown from slib/s_dpidx.cxx:3942, Err# 5, tid 906 origtid 906
O/S Err#: 0, ErrID: 2065 (hs_BArrayexception); SQLCode: -1009149, SQLState: 'QSB45', Severity: 14

  • The sp_iqcheckdb VERIFY also reports Inconsistent / Non-Completed Index errors with a specific message like this ...

** Missing recids in FP RidMap/MergeMap: 3  ****** 


Read more...

Environment

  • SAP IQ 16.1  Multiplex environment  

Product

SAP IQ 16.1

Keywords

sybase, crash, abort, failure, corruption, dbcc, chckdb, CR817661, CR#817661, 817661, instrumentation, barray_exception, indexes, internal, clone, rename, stktrc, 'stack trace' , 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.