Symptom
Execution of a delete statement on a newly upgraded nearly 1TB sized table results in FP index corruption and subsequent loads and deletes on the table will result in the following non-fatal stacktrace
s_TokenCountTable::ReAllocate
s_dpNBit::Initialize
hs_dp::CreateDictionary
hs_dp::hs_dp
db_IndexDef::OpenSIndexWithLock
db_IndexDef::OpenSIndex
db_IndexDef::OpenSIdxInsert
df_IdxDefAndInserter::OpenIndexInserter
df_Table::AddIndexDef
opt_Load::OpenSingleColumnIndexes
opt_LoadTable::GenerateDFEs
opt_Driver::GenerateTree
db_LoadTable::Execute
st_command::DoCmdThroughResourceGate
st_iqdml::Load
UIQDML_LOAD
On executing sp_iqcheckdb on the nBit indexes will show some of the indexes resulting in 'FP blockmap entries mismatch' error.
Read more...
Environment
SAP IQ 16.0 SP11 PL11
Product
SAP IQ 16.0
Keywords
Sybase , CR811409, CR#811409, 811409 , 751477, cr751477 SP08 , SP 11, PL 11 , corruption , error detected , stacktrace, stktrc , stack trace , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.