SAP Knowledge Base Article - Preview

2801379 - When Nbit is converted to Flat FP, "IQ Internal error" is raised - SAP IQ

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

SAP IQ 16.0

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.