Symptom
- When Nbit is converted to Flat FP, "IQ Internal error" is raised.
I. 05/09 18:58:01. 0000008459 Informational: Index Cardinality Exceeded Converting index to flat:
I. 05/09 18:58:01. 0000008459 Owner Name : prd
I. 05/09 18:58:01. 0000008459 Table Name : Table_Name
I. 05/09 18:58:01. 0000008459 Column Name: Col_name
I. 05/09 18:58:01. 0000008459 Index Name : User.Table_Name.ASIQ_IDX_T16766_C2_FP
I. 05/09 18:58:01. 0000008459 Token Count: 59
I. 05/09 18:58:01. 0000008459 Token Limit: 58
I. 05/09 18:58:01. 0000008459 Exception Thrown from slib/s_dpstore.cxx:4745, Err# 2, tid 2125 origtid 2125
I. 05/09 18:58:01. 0000008459 O/S Err#: 0, ErrID: 533 (hos_assertexception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
I. 05/09 18:58:01. 0000008459 [20238]: IQ Internal error. Please report this to SAP IQ support.
-- (slib/s_dpstore.cxx 4745)
- sp_iqcheckfpconsistency returns no error
- sp_iqcheckdb verify on the table returns no error
- IQ UNIQUE values are defined as 0
- The following options are set:
FP_NBIT_Autosize_Limit ='0'
FP_NBIT_Enforce_Limits =ON
FP_Prefetch_Size = 10
Read more...
Environment
SAP IQ 16.0 SP11 PL22
Product
Keywords
CR819447 ; CR#819447 ; 819447; "SQLCode: -1006000" ; "Index Cardinality Exceeded Converting index to flat:" ; Cardinality ; Exceeded ; Converting ; flat ; FP ; , 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.