SAP Knowledge Base Article - Preview

2939513 - Exception after a dump RidMap when an index was converting index to flat - SAP IQ

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

SAP IQ 16.1

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.