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.