SAP Knowledge Base Article - Preview

2754124 - sp_iqrebuildindex internal IQ error - SAP IQ

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

SAP IQ 16.0

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.