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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.