2890452 - Updating range partitioned tables may cause FP index corruption - SAP IQ

• When you update a range partitioned table, FP index may corrupt. This issue depends on the content of data.
• When you select the corrupted data, the below stack trace will be reported.

pcstkwalk
ucstkgentrace
StackTraceForThisThread
s_bArrayLocater::LoadPage
s_bArrayLocater::LocateTokenRecord
hs_dpfetch::ColumnScan3_ByteArr
vpp_FindIter::DoOneWorkunit
vpp_FindIter::ExecWork
workAllocator::DoWork
hos_team::StartWork
hos_team::Exec
vpp::ExecuteParallelFind
vpp_Compares::ExecuteOpus
vpp::Execute
vpp_Boolean::ExecuteOpus
vpp::Execute
vp_Predicates::PreExecute
vp_Cursor::PreExecute
opt_QueryExp::PrepareAndExecTops
opt_Driver::OptimizeQueryExp
opt_Driver::GenerateTree
st_cursorIQtoSA::Parse
df_OpenCursor::Parse
st_command::DoCmdThroughResourceGate
st_iqdml::OpenCursor
...

• sp_iqcheckdb is performed for the corrupted table, the below messages will be logged in iqmsg file:

 barray t140325898893056 XXXXX: CheckColumnEBMCoverage
 barray t140325898893056  ***  ridmap missing region for [7046693455,7046728482] previous region: [7046431169,7046693248] current region:   [7046730945,7046877710]
{140325898893056} DBCC:   *** missing recid in ridmap/mergemap - XXXXX.XXXXXX.ASIQ_IDX_T1707_C15_FP: slib/s_dpidx.cxx:4574
{140325898893056} DBCC:   *** blockmap allocation mismatch - XXXXX.XXXXXX.ASIQ_IDX_T1707_C15_FP: 4,266,1 slib/s_dpidx.cxx:4594
slib/s_dpidx.cxx:3955 *** XXXXX.XXXXXX.ASIQ_IDX_T1707_C15_FP(varchar): ridmap token counts and columnEBM mismatch - 451378, 451766
Exception Thrown from slib/s_dpidx.cxx:3960, Err# 5, tid 185 origtid 185
   O/S Err#: 0, ErrID: 2065 (hs_BArrayexception); SQLCode: -1009149, SQLState: 'QSB45', Severity: 14
[20189]:
-- (slib/s_dpidx.cxx 3960)  Internal Inconsistency:
-- (slib/s_dpidx.cxx 3960)  (Ridmap,5,XXXX)

• SAP IQ 16.1
• SAP IQ 16.0

range, partition, FP, index, update, corrupt, stacktrace, ridmap token counts, ridmap token, ridmap missing, s_barray.cxx,  CheckColumnEBMCoverage, , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed