SAP Knowledge Base Article - Preview

2490143 - Index corruptions after upgrading to SAP IQ 16


  • Upgrade from IQ 15.4 to IQ 16.
  • After upgrade, DBCC (Data Base Consistency Check) reports no error
  • After 1 day of activity the upgraded database could become corrupt with stack trace and FP damaged index and disk corruption errors.
  • Some of the FP corrupt indexes can be rebuild
  • For some other FP corrupt indexes, sp_iqrebuildindex fails with bufman errors.
  • OS disk check finds no error

Excerpt of IQMSG

** Non-Fatal IQ Internal Error Detected
at slib/s_bm.cxx:1456 on thread 212 (TID 5)
Bitmap result bitcount not in legal range.
***************** This is the STACKTRACE ***************

void StackTraceForThisThread
sbm_exception::sbm_exception #Nvariant 1
void s_bm::SetBits
void s_VersioningBlockmap::Deallocate
void s_bufpartition::Destroy
void s_blockmap::DestroyAllMappedPages
void hs_dp::ConvertMetadataFrom15x
hs_dp::hs_dp #Nvariant 1
void dfe_BaseColumn::OpenIndexes
unsigned long long dfe_BaseColumn::GetNullCount
void opt_TableNode::RemoveRedundantDisjPreds
void opt_TableNode::AnalyzeRanges
void opt_TableNode::AnalyzeRanges
void opt_QueryTree::ProcessPredicates
void opt_Select::ProcessPredicates
void opt_Driver::OptimizeQueryExp

Exception Thrown from slib/s_bm.cxx:1456, Err# 1, tid 5 origtid 5
O/S Err#: 0, ErrID: 2049 (sbm_exception); SQLCode: -1009045, SQLState: 'QSA45', Severity: 14
Bitmap failed internal checks. You may have a damaged index. Please check your IQ message file for additional information.
-- (slib/s_bm.cxx 1456)

main Bufman: Incorrect page header read; from slib/s_trycatch.cxx:2928
expected: btype=14,pbn=77473158,txn=9617456869,sp=1,nlb=16,npb=16,iscmp=0,uid=52062950,blk=77473158,mn=2,upmn=2,flgs=0x80000008
head: btype=14,pbn=77473158,txn=9617456370,sp=335,nlb=16,npb=16,iscmp=0,ctr=131,cta=131,ver=1,pb=134,pus=57202
{212} buffer: 0x000e00100010838300000000049e2586000000023d3ebcf20000014f0186df72
{212} Expected Pad1: 134 (0x86), Pad2: 27366 (0x6ae6)
{212} Got Pad1: 134 (0x86), Pad2: 57202 (0xdf72)
There was an s_buf::Read() error during s_bufman::Find().

Disk corruptions could be found in IQMSG

Exception Thrown from slib/s_blockmap.cxx:5782, Err# 0, tid 7 origtid 7
O/S Err#: 0, ErrID: 2100 (s_corruptdiskblkhdrexception); SQLCode: -1009039, SQLState: 'QSA39', Severity: 14
main Bufman: An error was detected on a database page. You may have a damaged index. For additional information, please check your IQ message file or run sp_iqcheckdb.
-- (slib/s_blockmap.cxx 5782)



  • SAP IQ 15.4
  • SAP IQ 16


SAP IQ 16.0 ; SAP Sybase IQ 15.4


KBA , BC-SYB-IQ , Sybase IQ , Problem

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.