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.