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