2135853 - Crash with "Index Cardinality Exceeded Converting index to flat" - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2135853 - Crash with "Index Cardinality Exceeded Converting index to flat" - SAP IQ

Symptom

Update a nullable column so that NBit roll over to flat FP, would cause
IQ crash SILENTLY without stack trace, after repeating the same message over and over in IQMSG.

Excerpt of IQMSG:

I. 02/24 22:40:43. 0000288469 Informational: Index Cardinality Exceeded Converting index to flat:
I. 02/24 22:40:43. 0000288469      Owner Name : jog37
I. 02/24 22:40:43. 0000288469      Table Name : P033_Measures_Aggs_ACCT_PROGS
I. 02/24 22:40:43. 0000288469      Column Name: viewing_mins_annualised
I. 02/24 22:40:43. 0000288469      Index Name : jog37.P033_Measures_Aggs_ACCT_PROGS.ASIQ_IDX_T526071_C7_FP
I. 02/24 22:40:43. 0000288469      Token Count: 500003
I. 02/24 22:40:43. 0000288469      Token Limit: 500000
I. 02/24 22:40:43. 0000288469 Informational: Index Cardinality Exceeded Converting index to flat:
I. 02/24 22:40:43. 0000288469      Owner Name : jog37
I. 02/24 22:40:43. 0000288469      Table Name : P033_Measures_Aggs_ACCT_PROGS
I. 02/24 22:40:43. 0000288469      Column Name: viewing_mins_annualised
I. 02/24 22:40:43. 0000288469      Index Name : jog37.P033_Measures_Aggs_ACCT_PROGS.ASIQ_IDX_T526071_C7_FP
I. 02/24 22:40:43. 0000288469      Token Count: 500003
I. 02/24 22:40:43. 0000288469      Token Limit: 500000
I. 02/24 22:40:43. 0000288469 Informational: Index Cardinality Exceeded Converting index to flat:
I. 02/24 22:40:43. 0000288469      Owner Name : jog37
I. 02/24 22:40:43. 0000288469      Table Name : P033_Measures_Aggs_ACCT_PROGS
I. 02/24 22:40:43. 0000288469      Column Name: viewing_mins_annualised
I. 02/24 22:40:43. 0000288469      Index Name : jog37.P033_Measures_Aggs_ACCT_PROGS.ASIQ_IDX_T526071_C7_FP
I. 02/24 22:40:43. 0000288469      Token Count: 500003
I. 02/24 22:40:43. 0000288469      Token Limit: 500000


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

 update, Nbit, cardinality, exceeded, converting, flat, silent, crash , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.