Symptom
- Hitting non-fatal error "Assertion in s_dictionaryFetch::FetchNoCopy" during an INSERT execution that triggers an index rollover to Flat FP
- The cardinality of the column + the number of rows to be inserted, is smaller than the value of the option FP_NBIT_Autosize_Limit
- Check table consistency with this command: sp_iqcheckdb 'verify table owner.table_name'
returns NO ERROR
Excerpt of IQMSG
0x7f04267f0f18 Debug: Checking FP index before rollover
Table: table_name
Column: column_name
Index: owner.table_name.ASIQ_IDX_Txxx_Cyy_FP
Assertion failure in s_dictionaryFetch::FetchNoCopy. offset=179246236, _pDataLen=16777228
** Non-Fatal IQ Internal Error Detected
** at slib/s_dpstore.cxx:4736 on thread thread_number (TIX 9)
**
** Command text:
insert into "owner"."table_name" ... select ... from table1, table2 where ...
s_dictionaryFetch::FetchNoCopy
s_mergeRHSReader::NextVectorForRollover
s_mergeFINALWriter::FinalRollover
hs_dpInsert::Rollover
df_FPRolloverIterator::ExecWork
workAllocator::DoWork
hos_team::StartWork
hos_team::Exec
dfiio_FP::RolloverIfNeeded
dfiio_FP::PostFetchOpus
dfo_IndexInsert::PostFetchOpus
dfo_Sequencer::FetchOpus
dfo_Root::FetchOpus
db_dmlcommand::ExecuteDFOTree
db_InsertRoot::Execute
Read more...
Environment
SAP IQ 16.1
Product
Keywords
Nbit, rollover, "Flat FP", flat, s_mergeRHSReader::NextVectorForRollover, s_mergeFINALWriter::FinalRollover, hs_dpInsert::Rollover, df_FPRolloverIterator::ExecWork, dfiio_FP::RolloverIfNeeded , KBA , BC-SYB-IQ , Sybase IQ , Known Error
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.
SAP Knowledge Base Article - Preview