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 : user1
I. 02/24 22:40:43. 0000288469 Table Name : Table1
I. 02/24 22:40:43. 0000288469 Column Name: col1
I. 02/24 22:40:43. 0000288469 Index Name : user1.Table1.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 : user1
I. 02/24 22:40:43. 0000288469 Table Name : Table1
I. 02/24 22:40:43. 0000288469 Column Name: col1
I. 02/24 22:40:43. 0000288469 Index Name : user1.Table1.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 : user1
I. 02/24 22:40:43. 0000288469 Table Name : Table1
I. 02/24 22:40:43. 0000288469 Column Name: col1
I. 02/24 22:40:43. 0000288469 Index Name : user1.Table1.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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.