Symptom
1) While inserting data into a table column the index cardinality exceeds an upper threshold and a dynamic conversion to a Flat style FP index occurs. These messages seen in the iqmsg file:
===
Informational: Index Cardinality Exceeded Converting index to flat:
Owner Name : user01
Table Name : ##tba01
Column Name: cola01
Index Name : user01.##tba01.ASIQ_IDX_ix01_FP
Token Count: 1048594
Token Limit: 1048576
====
2) The FP rollover to flat fails with a ridmap missing region message and ridmap dump:
====
barray t140723880146688 cola01: CheckColumnEBMCoverage
barray t140723880146688 *** ridmap missing region for [2147393,2147393] previous region: [2136705,2147392] current region: [67108929,67141632]
t140723880146688 *** user01.##tba01.ASIQ_IDX_ix01_FP cola01 RidMap:
Ridmap Identity Version: 1
barray t140723880146688 C32: cola01
barray t140723880146688 C32 BEGIN dump RidMap:
Read more...
Environment
-
SAP IQ 16.1 SP03 PL04
Product
Keywords
rollover roll-over roll over RidMap dump ridmap missing region Index Cardinality Exceeded Converting index to flat index cardinality exceeds dynamic conversion Flat style FP index 822019 CR 822019 CR822019 , 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