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

• 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  ****** 

• SAP IQ 16.1  Multiplex environment  

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