Symptom
IQ Internal error 's_ohcidx.cxx:9340' happened when trying to rebuild index using sp_iqrebuildindex.
Error occurs even on new table with data loaded. Currently founded followings,
- Retiering of the column does not help
- Datatype of column involved in varchar(10)
- Other tables have the same issue
- Issue has existed in previous PL's as well
- Error & Stack trace
(etl)> drop index xxx.table1.npi_hg;
Execution time: 0.586 seconds
(etl)> create hg index pharmacy_npi_hg on xxx.table1( npi);
Execution time: 57.25 seconds
(etl)> call sp_iqrebuildindex ( 'xxx.table1', 'index npi_hg');
Could not execute statement.
..
.. ** Non-Fatal IQ Internal Error Detected
.. ** at slib/s_ohcidx.cxx:9340 on thread 139987057411840 ( TID 11)
.. **
****** STACKTRACE ******
..
.. hs_ThrowIdxException
.. hs_ohc::ReleaseInsertSubIndex
.. dfo_HGIndexInsert::PostFetchOpus
.. df_CombinerFinalFetchHelper::ExecWork
.. workAllocator::DoWork
.. hos_team::StartWork
.. hos_team::Exec
.. df_CombinerFinalFetchHelper::Run
.. dfo_Combiner::FetchOpus
..
Read more...
Environment
SAP IQ 16.0
Product
Keywords
ReleaseInsertSubIndex , 'sp_iqrebuildindex' , 813073, s_ohcidx.cxx , , 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.