SAP Knowledge Base Article - Preview

2760519 - ALTER TABLE SPLIT PARTITION hits problem 'Bitmap verification failed' & 's_bm.cxx' - SAP IQ

Symptom

ALTER TABLE SPLIT PARTITION hits 'Bitmap verification failed', but table has no corruption.

ALTER table dbo.XXX_RobK 
PARTITION BY RANGE (D_PERIODE)
(P2018 VALUES <= ('2018-12-31'), -- all rows must be in the first partition
P2019 VALUES <= ('2019-12-31'), -- none at the moment
P9999 VALUES <= (MAX) ) ;
Checkpoint;
ALTER TABLE dbo.XXX_RobK SPLIT PARTITION P2018 INTO 
(P2015 VALUES <= ('2014-12-31'), -- still empty
P2018 VALUES <= ('2018-12-31') ) ; -- all

/*Could not execute statement.
Bitmap failed internal checks. You may have a damaged index. Please
check your IQ message file for additional information.
--
(slib\s_bm.cxx 1458)
SQLCODE=-1009045, ODBC 3 State="HY000"
Line 116, column 1


Read more...

Environment

  • SAP IQ 16.0 
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

RID, ALTER PARTITION, PARTITION, "Bitmap failed", "s_bm.cxx" , SPLIT, , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.