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.

  • The command:

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

  • The error message:

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