Symptom
Update statement which is part of a stored procedure results in BUFMAN_BLOCKMAP_INFO_ERROR on nBit FP index after couple of hours of processing.
- The procedure execution terminates with a Non-Fatal stacktrace
- sp_iqcheckdb on FP index shows 'No Errors Detected'
- sp_iqcheckfpconsistency on table also is clean with 'No Errors Detected'
- The thread resulting in stacktrace has the following functions calls:
s_blockmap::GetBlockmapEntryInfo
s_blockmap::FindAndMakeDirtiable
s_bArrayCursor::FindForMerge
s_mergeFINALWriter::LoadPageForMerge
s_mergeFINALWriter::DoInsert()
hs_dpInsert::Insert
hs_dpUpdate::Update
db_sqlinsert::UpdateIndex
db_UpdateIterator::LocalExecWork
db_UpdateIterator::ExecWork
workAllocator::DoWork
hos_thread::Main
hos_lwtask::Start
IQWorkerStarter
Read more...
Environment
SAP IQ 16.0 SP11 PL06
Product
SAP IQ 16.0
Keywords
CR805722, CR#805722, 805722, stacktrace, stktrc, non fatal, corruption, checkdb, fp consistency , 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.
SAP Knowledge Base Article - Preview