SAP Knowledge Base Article - Preview

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

Symptom

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
...

And when 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)


Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

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

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.